Hello all,
during my implementation of FDISTL I saw the following problems.
(1)
I generate a file with a formula =FDISTL(a,b,c) and store it in version
ODF1.2. Unzipping the file I find "of:=FDIST(a,b,c)", which is correct.
Now I open the file in OOo2.4.2. I get the version warning to upgrade.
(BTW, you get the warning only for first opening.) Then it opens and the
cell with "of:=FDIST(a,b,c)" is calculated with cell content
=FDIST(a,b,c) instead of showing a #NAME? error. This must not happen,
because =FDIST in OOo2.4.2 means the right tail, which is internally
"of:=LEGACY.FDIST". The user does not know, that the result is wrong.
Similar for the four parameter form. "of:=FDIST(a,b,c,d)" results in
cell content "=FDIST(a,b,c,d)". The user gets an Err:504 here, because
of the forth parameter.
If you now save the file in OOo2.4.2 and reopen it in OOo3.2, then the
original =fdistl() cell contents are not restored. We have data loss.
Is there any place in source of OOo3.2 where I can avoid that error? Or
can it only be solved in OOo2.4.x?
(2)
Another problem is the following scenario. Save in OOo3.2 with version
ODF1.0. Open in OOo3.1.1. In cells with content "=FDISTL()" you get
correctly content "=fdistl()" and #NAME? error, because this function is
unknown to OOo3.1.1. Now save the file in OOo3.1.1 with version ODF1.2.
and open it in OOo3.2. The cell content is shown as "=fdistl()", but the
now known function is not identified and the cells show a #NAME? error.
Unzipping the file you see a "of:=fdistl()", which small instead of
capital letters. Even a hard recalculate does not help.
Any solution for this?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
