Issue 56568

Summary: csv import of "65+"
Product: Calc Reporter: millarpeter <millarpeter>
Component: open-importAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, steve.m.frank
Version: OOo 2.0   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

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)

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

not a bug. It's a matter of number recognition. Use text on the column in the
import dialog.

Comment 2 frank 2005-11-15 10:43:38 UTC
closed invalid

Comment 3 millarpeter 2005-11-15 20:41:09 UTC

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

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.

Comment 5 frank 2005-11-16 09:16:51 UTC
closed invalid
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