Empty and missing parameters in LINEST/LOGEST and TREND/GROWTH

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Empty and missing parameters in LINEST/LOGEST and TREND/GROWTH

Regina Henschel
Hi all,

the draft spec for ODF1.2 allows empty and missing parameters. If I
interpret the syntax description correctly, this cases are possible:

For LINEST/LOGEST
1 Y ; X ; Const ; Stats
2 Y ; X ; Const
3 Y ; X
4 Y ; ; Const ; Stats
5 Y ; ; Const
6 Y
7 Y ;

The syntax variants
8 Y ; X ; ; Stats
9 Y ; ; ; Stats
are not possible. There is no way to get Stats without Const.

For TREND/GROWTH
10 Y ; X ; newX ; Const
11 Y ; X ; newX
12 Y ; X ; ; Const
13 Y ; X
14 Y ; X ;
15 Y ; ; newX ; Const
16 Y ; ; newX
17 Y ; ; ; Const
18 Y
19 Y ;
20 Y ; ;

Not allowed
21 Y ; X ; newX ;
22 Y ; ; newX ;
23 Y ; X ; ;
24 Y ; ; ;
There is no way in the syntax pattern to ommit Const and set the ';' at
the same time.

Excel allows all that variants. Are the missing Const and Stats set to
the defaults during import? If not, should they be set there?

Do you want to allow all variants too when entering a formula? If yes,
which part would be responsible to correct them, at the latest when
saving to valid ODF-format?

I have no solution for 7, 14, 19, 20 which ends with ';'.
Are they really intended? Or need ODF to be changed?

I catch missing parameters in-between (4,5,12,15,16,17) with
IsMissing(). But it does not work for ending ';'. Perhaps ocMissing is
not set for ';' at the end position?

Kind regards
Regina




---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]