[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: Re: [office-comment] Document openformula-20070208-dwheeler5.odt Section 4.1 Text (String)
Hi James, On Friday, 2007-02-23 12:05:02 -0800, James E. Lang wrote: > Now I guess I'm going to drift off the topic of the original post. Yes, you are ;-) Furthermore, OASIS and this list have nothing in common with OpenOffice.org except that a few people are members of both. Please use the users@sc.openoffice.org list for OOoCalc usage questions, to subscribe mailto:users-subscribe@sc.openoffice.org Just this: > long string (e.g. 123456789456789123789123456) > which was interpreted as a floating point string (e.g. > 1.23456789456789E+026) instead. Enclosing the string in double-quotes moved > the first digit into the second position in the string. I guess there is no > way to enter a long string of digits preserving the integrity of the string > with the first character in the string being the first digit and the last > character in the string being the last digit. Of course there is, to prevent interpretation of a string as number (or anything else) and keep it as text, precede the input with a single quote / apostrophe, enter '123456789456789123789123456, the ' will not be part of the cell content. But this is application specific UI behavior, so let's stop discussion here. > I still believe that the > double-quotes surrounding a string should _not_ be a part of the string in > a cell reference. It _has to_, the quotes are part of the cell content. Eike -- OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]