Dear Eike, Clever answers need clever questions.
My concern with Regina's post was: > (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()", with small > instead of capital letters. Even a hard recalculate does not help. So, what was this problem? It did resemble my problem. Unfortunately, this issue and others bring me to unacceptable shortcomings in Calc. I will take exquisitely the time to detail a couple of issues, time that I am less and less able to devote to OOo. I will open a new thread to detail some of those issues, suffice here to ask a question: How can you quickly know if a number is a number in a cell that was formatted as text? And how can you know if a number entered as string is a string, if a cell is formated as text? Solving this latter issue is slightly easier to accomplish. You need only 4 clicks (if you know which ones) to get the information that answers the question. But question 1 does not provide any feedback. Ff you do not know how OOo behaves, the user is lost. [Even older versions of Excel do answer these questions instantly.] Sincerely, Leonard -------- Original-Nachricht -------- > Datum: Wed, 8 Jul 2009 18:46:02 +0200 > Von: Eike Rathke <e...@sun.com> > An: dev@sc.openoffice.org > Betreff: [sc-dev] i85328 (was: [sc-dev] OOo2.4.2 takes of:=FDIST(a,b,c) as if > it is ooc:=FDIST(a,b,c)) > Hi Leonard, > > On Saturday, 2009-07-04 19:53:56 +0200, Leonard Mada wrote: > > > this brings me to an older issue: > > http://www.openoffice.org/issues/show_bug.cgi?id=85328 > > Which is completely unrelated to the problem we're talking about, you > hijacked the thread. > > Input to a cell that is formatted as text is always treated as text and > never parsed as another data type or formula. This is on purpose, and > Excel does it the same. Usually used to pre-format cells and paste data > from the clipboard or enter text that otherwise would get parsed. > > 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. -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
