Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||csv import of "65+"|
|Status:||CLOSED DUPLICATE||QA Contact:||issues@sc <issues>|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description millarpeter 2005-10-24 21:00:18 UTC
Also found in version 1.1.3 on Windows XP and version 1.9.129 on Linux. This line is in a .csv file. (column headings) ,"All","0-15","16-64","65+" Opening with options , separater and " text delimiter. "65+" become the number 65 Also tried "65-" which becomes the number -65 "'65+" is a work around.
Comment 1 frank 2005-11-15 10:43:09 UTC
Hi, not a bug. It's a matter of number recognition. Use text on the column in the import dialog. Frank
Comment 2 frank 2005-11-15 10:43:38 UTC
Comment 3 millarpeter 2005-11-15 20:41:09 UTC
Hi, I have since discovered that if 65+ is typed in any cell it is converted to the number 65. (Typing 65- produces the number -65). I don't think that 65+ is a number. (+65 is a number). This behaviour is carried over to the csv import. (Gnumeric application acts as I would expect).
Comment 4 frank 2005-11-16 09:16:04 UTC
Hi, entering 65+ into a cell gives a number plus an operator with missing second number. So this is converted into a pure number. And normally this is what the User wants. Entering 65- and converting it to -65 is a feature for making it easier to enter negative numbers. If you want 65+ as text, use the option to set the import type of a column on the CSV Import dialog. Frank
Comment 5 frank 2005-11-16 09:16:51 UTC
Comment 6 millarpeter 2005-11-16 13:38:01 UTC
I'm sorry to come back to this. If I type 65+0 it appears as text "65+0". Also 65* and 65/ appear as text. If I type =65+ it is an error with suggested replacement being a formula '=65'. OOo's behaviour seems illogical. Gnumeric and Excel treat 65+ as text. On csv import it is changed to a number even though it has double quotes around it.
Comment 7 atdsm 2005-12-01 14:47:46 UTC
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 ***
Comment 8 frank 2005-12-02 13:41:33 UTC
agreed for the split