Issue 115982 - calc: CSV-import does not recognize numbers
Summary: calc: CSV-import does not recognize numbers
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.3 RC7
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-08 04:46 UTC by mhatheoo
Modified: 2017-05-20 09:54 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
not working detection of cell-format (Text instead of numbers) (138.54 KB, image/jpeg)
2010-12-08 04:47 UTC, mhatheoo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description mhatheoo 2010-12-08 04:46:02 UTC 
I opened a CSV-file with ASCII-coding CP-437 (thats not importend it does not
function with win1250 either), the numbers will no longer be detected as
numbers/decimals.

a picture will explain it better than ...
look at the apostroph in menu--bar and the detection within the formatting-dialog.

had worked (stopper+regression to 3.2.1)

martin
Comment 1 mhatheoo 2010-12-08 04:47:42 UTC 
Created attachment 75270 [details]
not working detection of cell-format (Text instead of numbers)
Comment 2 mhatheoo 2010-12-08 05:49:40 UTC 
my fault ?!

the "extended recognition" (?) (german: erweiterte Zaqhlenerkennung) is working
as expected. But I had expected it the otherway round 

(after first use of that option, extended is the default, so that is okay) 

m.
Comment 3 Rob Weir 2013-02-07 16:49:59 UTC 
User reported that it was working correctly.