Re: [sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)
Hi Regina, On Monday, 2009-07-06 11:43:23 +0200, Regina Henschel wrote: I agree, not to implement FDISTL with OOo3.2. I can send you the code which contains the algorithms, so that you can keep it and the algorithms get not lost. Do you want a patch or the complete interpr3.cxx file? Patch please, so chances are that it can be applied in future. I think, that the FDIST problem has to be solved in OASIS. Not necessarily.. it's no OASIS' fault that our implementation is as it is. For CHIDIST it has been solved by introducing the new function name CHISQDIST. Only because CHISQDIST is a more logical name for a function that does some Chi Square computation. The left tailed variant of the F-distribution needs a new name too. At least it should not allow three parameters, so that application can notice the change by counting the parameters. That wouldn't fit with the other functions that have the distribution/cumulated boolean parameter all optional. Do you take the problem to the committee? I can try, but no guarantee. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the e...@sun.com account, which I use for mailing lists only and don't read from outside Sun. Use er...@sun.com Thanks. pgpI7Vi8YWt45.pgp Description: PGP signature
[sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)
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
Re: [sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if it is ooc:=FDIST(a,b,c)
Dear Regina, this brings me to an older issue: http://www.openoffice.org/issues/show_bug.cgi?id=85328 It was suggested within that issue, that the cell was formatted as text, although I would have expected that anything starting with = is interpreted as a formula, while strings get marked as: '= I believe this is a more deeper problem within Calc that needs to be addressed. Sincerely, Leonard Mada -- Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02 - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org