Issue 110931 - csv line contents are incorrectly shown
Summary: csv line contents are incorrectly shown
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO310m19
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 110929 (view as issue list)
Depends on:
Reported: 2010-04-16 08:33 UTC by r3ddevil
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

File with single csv line (28 bytes, text/plain)
2010-04-16 08:34 UTC, r3ddevil
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description r3ddevil 2010-04-16 08:33:37 UTC
calc is showing incorrect values for a value in a csv file. I have a csv file 
with following single line 
But when i open the file with open office with settings 
character set: UTF 8 
Separator options: Separated by comma
Text delimiter: "
the contents for column B are shown incorrectly as 6143:26:00 instead of 
Comment 1 r3ddevil 2010-04-16 08:34:25 UTC
Created attachment 68956 [details]
File with single csv line
Comment 2 ooo 2010-04-16 12:12:14 UTC
*** Issue 110929 has been marked as a duplicate of this issue. ***
Comment 3 ooo 2010-04-16 12:32:28 UTC
What happens is that the second field's content 6043:6026 is parsed as time,
which certainly is not wanted, and then is normalized. The same when such a
value is entered in a cell.

It helps to set the column type to Text in the import dialog.
Comment 4 Marcus 2017-05-20 11:11:13 UTC
Reset assigne to the default "".