To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=56568
User atdsm changed the following:
What |Old value |New value
================================================================================
CC|'' |'atdsm'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Dec 1 06:47:46 -0800
2005 -------
Frank, I don't think it's a valid workaround to simply assign the entire column
as being in text format. What if there are numbers underneath the cell "65+"
that need to be formatted in a standard format? You wouldn't want to import them
as text.
I think there is another issue here, though. Isn't setting something off in
quotes in a CSV file supposed to delimit it as text? However, on import OOo
doesn't recognize the quotes as marking text; it doesn't differentiate (for
example) between 64.00 and "64.00". In my mind, 64.00 should be imported as 64
(a number), but "64.00" should be a cell containing "64.00" (formatted as text).
Instead, both cases yield an import of 64 (a number).
In other words, the same issues are at stake here as in issue 15274. What's the
point of having text delimiters at all if when the cells are imported they are
converted from being text to being a number, despite their original text status?
I'm splitting this issue into 2 issues. The first (this one) is a duplicate of
issue 15274 about text formatting on import. The second is a new issue about
appending a + sign to a number - whether or not that should be treated as text.
The new issue about formatting of 65+ is issue 58734.
*** This issue has been marked as a duplicate of 15274 ***
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
