Calc/ODFF Implementation/OOo3.0

Implementation done for OOo3.0. For other versions and remaining schedule please see one level up.

Created with TaskJuggler via HTML::WikiConverter. Do not edit.

ODFF Implementation for OOo3.0

Implementation of features and changes related to ODFF (aka OpenFormula), the OpenDocument Format Formula specification.

Status

No.

Name

Note

Reference

Flags

Resources

Start

End

Duration

Completed

Status Note

Nov 2007

Dec 2007

Jan 2008

Feb 2008

Mar 2008

Apr 2008

May 2008

Jun 2008

Jul 2008

47

48

49

50

51

52

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

Finished

7.2.1

CWS odff

Critical, give enough time to QA

2008-02-20

3m

100%

v=

==

==

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.1.1

Range Bundle

6.2w

100%

v=

==

==

==

==

==

=v

Finished

7.2.1.1.1

ocRange

i4904

MustHave

Eike Rathke

2007-11-22

2007-12-05

1.8w

100%

[=

==

=]

Finished

7.2.1.1.2

ocUnion / rangelist

i32341

1m

100%

v=

==

==

==

=v

Finished

7.2.1.1.2.1

operator and functions' arguments

MustHave

Eike Rathke

2007-12-06

2007-12-20

2w

100%

[=

==

=]

Finished

7.2.1.1.2.2

INDEX() support rangelist

generalize compiler specialty, (x;y) vs. x~y

MustHave

Eike Rathke

2008-01-03

2008-01-04

42h

100%

[=]

Finished

7.2.1.1.2.3

AREAS() support rangelist

MustHave

Eike Rathke

2008-01-04

2008-01-04

3h

100%

[=]

Finished

7.2.1.2

Patches

pending patches

7.4w

100%

v=

==

==

==

==

==

==

=v

Finished

7.2.1.2.1

FREQUENCY() rank/sort bins

i8946

7.4w

100%

v=

==

==

==

==

==

==

=v

Finished

7.2.1.2.1.1

implementation

MustHave

Kohei Yoshida

2007-12-17

2007-12-17

8h

100%

[=]

Finished

7.2.1.2.1.2

apply patch

MustHave

Eike Rathke

2008-02-06

2008-02-06

3h

100%

[=]

Finished

7.2.1.2.2

SUMIF() third parameter geometry

i85000

6h

100%

v=v

Finished

7.2.1.2.2.1

implementation

MustHave

Kohei Yoshida

2008-01-07

2008-01-07

4h

100%

[=]

Finished

7.2.1.2.2.2

apply patch

MustHave

Eike Rathke

2008-01-07

2008-01-07

2h

100%

[=]

Finished

7.2.1.2.3

MATCH() accept arrays

i8947

3.7w

100%

v=

==

==

==

=v

Finished

7.2.1.2.3.1

implementation

MustHave

Kohei Yoshida

2008-01-11

2008-01-14

3.2d

100%

[=

=]

Finished

7.2.1.2.3.2

apply patch

MustHave

Eike Rathke

2008-02-07

2008-02-07

0d

100%

[=]

Finished

7.2.1.3

error token

to properly handle error returns and results

MustHave

Eike Rathke

2008-01-08

2008-01-11

3d

100%

[=]

Finished

7.2.1.4

variable cell result

number, text, empty, matrix, error, ...

i32340

MustHave

Eike Rathke

2008-01-15

2008-02-01

2.3w

100%

[=

==

=]

Finished

7.2.1.5

resync CWS odff to m243

resolve merge conflicts from CWS xmlfilter02, adapt some sources, build

MustHave

Eike Rathke

2008-01-21

2008-01-22

22h

100%

[=]

Finished

7.2.1.6

ISERROR(undefinedname)

i77280

MustHave

Eike Rathke

2008-02-04

2008-02-06

44h

100%

[=]

Finished

7.2.1.7

resync CWS odff to m244

function wizard crashes in m243, plus give Lv Yue a chance to tune in based on m244

MustHave

Eike Rathke

2008-02-06

2008-02-06

4h

100%

[=]

Finished

7.2.1.8

complete mapping

i81063

MustHave

Eike Rathke

2008-02-08

2008-02-15

1w

100%

[=

=]

Finished

7.2.1.9

CWS odff rfQA

MustHave

Eike Rathke

2008-02-18

2008-02-20

2.5d

100%

[=]

Finished

7.2.2

CWS odff03

2008-05-09

5m

100%

v=

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.2.1

MIN()/MAX()/MINA()/MAXA() no argument

return 0 instead of error if all parameters don't have values

i38759

1m

100%

v=

==

==

==

=v

Finished

7.2.2.1.1

implementation

ShouldHave

Yue Lv

2007-12-10

2008-01-07

4w

100%

[=

==

==

=]

Finished

7.2.2.1.2

apply patch

ShouldHave

Eike Rathke

2008-01-08

2008-01-08

0.1d

100%

[=]

Finished

7.2.2.2

GCD()/LCM() integer arguments

i71158

3.7m

100%

v=

==

==

==

==

==

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.2.2.1

implementation

MustHave

Yue Lv

2008-01-16

2008-02-01

2.3w

100%

[=

==

=]

Finished

7.2.2.2.2

apply patch

MustHave

Eike Rathke

2008-05-08

2008-05-08

3h

100%

[=]

Finished

7.2.2.3

RATE() results

results also for roots < -1; plus non-integer PayType other than {0,1}

i15090

2.8m

100%

v=

==

==

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.2.3.1

implementation

NiceToHave

Regina Henschel

2008-01-27

2008-02-16

20d

100%

[=

==

==

=]

Finished

7.2.2.3.2

apply patch

NiceToHave

Eike Rathke

2008-04-24

2008-04-24

3h

100%

[=]

Finished

7.2.2.4

LOOKUP() in columns and result handling

i74245

2.3m

100%

v=

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.2.4.1

implementation

MustHave

Kohei Yoshida

2008-02-12

2008-02-13

42h

100%

[=]

Finished

7.2.2.4.2

apply patch

MustHave

Eike Rathke

2008-04-23

2008-04-23

4h

100%

[=]

Finished

7.2.2.5

MINA()/MAXA() 0 for formula cell string results

i86171

7w

100%

v=

==

==

==

==

==

==

=v

Finished

7.2.2.5.1

implementation

MustHave

Yue Lv

2008-02-22

2008-02-25

3d

100%

[=]

Finished

7.2.2.5.2

apply patch

MustHave

Eike Rathke

2008-04-10

2008-04-10

0d

100%

[=]

Finished

7.2.2.6

COUNT()/COUNTA() error propagation

ignore/count errors

i86643

5.4w

100%

v=

==

==

==

==

=v

Finished

7.2.2.6.1

implementation

ShouldHave

Yue Lv

2008-03-04

2008-03-20

16d

100%

[=

==

=]

Finished

7.2.2.6.2

apply patch

ShouldHave

Eike Rathke

2008-04-10

2008-04-10

0d

100%

[=]

Finished

7.2.2.7

N() treat all text as 0

i86721

1m

100%

v=

==

==

==

=v

Finished

7.2.2.7.1

implementation

ShouldHave

Yue Lv

2008-03-10

2008-03-11

1d

100%

[=]

Finished

7.2.2.7.2

apply patch

ShouldHave

Eike Rathke

2008-04-10

2008-04-10

0d

100%

[=]

Finished

7.2.2.8

INDEX() compatibility

3.7w

100%

v=

==

==

=v

Finished

7.2.2.8.1

parameter handling

i78781

3.7w

100%

v=

==

==

=v

Finished

7.2.2.8.1.1

implementation

MustHave

Yue Lv

2008-03-17

2008-03-20

3d

100%

[=]

Finished

7.2.2.8.1.2

apply patch

MustHave

Eike Rathke

2008-04-11

2008-04-11

0d

100%

[=]

Finished

7.2.2.8.2

return vector of array

i66930

3.3w

100%

v=

==

==

=v

Finished

7.2.2.8.2.1

implementation

MustHave

Yue Lv

2008-03-19

2008-03-20

1d

100%

[=]

Finished

7.2.2.8.2.2

apply patch

MustHave

Eike Rathke

2008-04-11

2008-04-11

0d

100%

[=]

Finished

7.2.2.9

Replace GetSortArray()

replace occurrences of GetSortArray() with newly implemented one from FREQUENCY

i87726

8.8d

100%

v=

=v

Finished

7.2.2.9.1

implementation

NiceToHave

Yue Lv

2008-04-03

2008-04-08

5d

100%

[=

=]

Finished

7.2.2.9.2

apply patch

NiceToHave

Eike Rathke

2008-04-11

2008-04-11

0d

100%

[=]

Finished

7.2.2.10

resync CWS odff03 to m11

2008-05-09

2008-05-09

16h

100%

[=]

Finished

7.2.2.11

CWS odff03 rfQA

2008-05-09

2008-05-09

4h

100%

[=]

Finished

7.2.3

rfQA Critical 3.0

2008-02-20

2008-02-20

100%

<>

Finished

7.2.4

CWS odff02, UI relevant

2008-03-03

1.6w

100%

v=

==

=v

Finished

7.2.4.1

error constants resource strings

new and move from globstr.src to compiler.src, create OpCodes

i86514

MustHave

Eike Rathke

2008-02-25

2008-03-02

6.2d

100%

[=]

Finished

7.2.4.2

function wizard strings

resources for new functions and parameters, suppressed until implemented

i86514

MustHave

Eike Rathke

2008-02-27

2008-03-01

2.6d

100%

[=]

Finished

7.2.4.3

CWS odff02 rfQA

MustHave

Eike Rathke

2008-03-02

2008-03-03

14h

100%

[=

=]

Finished

7.2.5

rfQA UI 3.0

2008-03-03

2008-03-03

100%

<>

Finished

7.2.6

UI/feature freeze 3.0

2008-03-06

2008-03-06

100%

<>

Finished

7.2.7

CWS odff04

2008-06-25

2.7m

100%

v=

==

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.7.1

GAMMADIST, CHIDIST, GAMMAINV and CHIINV functions' accuracy

i90703

2.6m

100%

v=

==

==

==

==

==

==

==

==

==

==

=v

Finished

7.2.7.1.1

implementation

ShouldHave

Regina Henschel

2008-04-01

2008-05-31

2m

100%

[=

==

==

==

==

==

==

==

=]

Finished

7.2.7.1.2

apply patch

ShouldHave

Eike Rathke

2008-06-18

2008-06-18

2h

100%

[=]

Finished

7.2.7.2

Allow all characters in sheet names

i6087

2.1m

100%

v=

==

==

==

==

==

==

==

==

=v

Finished

7.2.7.2.1

implementation

NiceToHave

Caolan McNamara, Kohei Yoshida

2008-04-16

2008-05-10

24d

100%

[=

==

==

=]

Finished

7.2.7.2.2

apply patch

NiceToHave

Eike Rathke

2008-06-17

2008-06-17

0.2d

100%

[=]

Finished

7.2.7.3

INDIRECT() add r1c1 parameter

i91020

MustHave

Eike Rathke

2008-06-24

2008-06-24

0.1d

100%

[=]

Finished

7.2.7.4

ADDRESS() insert r1c1 parameter

i91020

MustHave

Eike Rathke

2008-06-25

2008-06-25

7h

100%

[=]

Finished

7.2.7.5

CWS odff04 rfQA

Eike Rathke

2008-06-25

2008-06-25

2h

100%

[=]

Finished

7.2.8

rfQA Beta 3.0

2008-04-01

2008-04-01

100%

<>

Finished

7.2.9

Beta freeze 3.0

2008-04-10

2008-04-10

100%

<>

Finished

7.2.10

CWS calcfixes30

2008-07-02

1d

100%

v=v

Finished

7.2.10.1

read/write automatic intersection '!!' operator

i91259

MustHave

Eike Rathke

2008-07-01

2008-07-01

3h

100%

[=]

Finished

7.2.10.2

store ERRORTYPE as ORG.OPENOFFICE.ERRORTYPE

i91294

MustHave

Eike Rathke

2008-07-02

2008-07-02

0d

100%

[=]

Finished

7.2.10.3

CWS calcfixes30 rfQA

Eike Rathke

2008-07-02

2008-07-02

2h

100%

[=]

Finished

7.2.11

rfQA code 3.0

2008-07-03

2008-07-03

100%

<>

Finished

7.2.12

Code freeze 3.0

2008-07-04

2008-07-04

100%

<>

Version 1.8 - Created on 2008-07-18 18:27 with TaskJuggler v2.4.0