OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[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.


 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]