Issue 110931 - csv line contents are incorrectly shown
Summary: csv line contents are incorrectly shown
Status: CONFIRMED
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:
URL:
Keywords:
: 110929 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
File with single csv line (28 bytes, text/plain)
2010-04-16 08:34 UTC, r3ddevil 		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 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 
myfile.csv:61334,6043:6026,0
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 
6043:6026
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 "issues@openoffice.apache.org".