https://bugs.freedesktop.org/show_bug.cgi?id=68437
Priority: medium
Bug ID: 68437
Assignee: [email protected]
Summary: Time values in csv import are misinterpreted
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84458
--> https://bugs.freedesktop.org/attachment.cgi?id=84458&action=edit
raw csv data
Hello,
when a csv file contains duration time values like "00:03:10", the values of
this fields are misinterpreted in the way they are not computed correctly.
I attach a csv file which contains a telephon call list. The calling number,
the called number, date and time of the call, the duration, rate and total cost
are listed.
- Import the attached file (charset ISO8859-15/Euro), starting line 1, extended
number recognition on, separated by ";". Set "A-Rufnummer", "B-Rufnummer" to
"Text", "Datum" as date DMY. Let the rest be standard.
- Sort on "A-Rufnummer", "Datum", "Uhrzeit" will give you a well-sorted list
- Now do subtotals ("Teilergebnisse" in german"). Group by "A-Rufnummer" and
sum on "Dauer" and "Preis" (last is not really necessary to show the problem).
When you now look at the sums on "Dauer" (the duration of the call), you will
see an 0.
Trying to convert the field with cell formating to "Time format HH:MM:SS" ends
up in values like: '00:04:23
They are now converted to implicit text! And the sum now displays "00:00:00".
I tried to convert the value back to time with search and replace (regular
expression), but this is very complicated (have to use ^.00: as search item).
Also it results in very strange values (a 00:00:57 sometimes converts to
00:57:00 and so on).
Importing the attached csv file into LO 3.x is without any problem. Importing
the file in any version of OpenOffice (3.x, 4.x) also gives the right results.
Attached files:
lo-time-test.csv is the raw ascii file
lo-time-test-1.ods is the LO spreadsheet after import, sort, subtotal
lo-time-test-2.ods is the LO spreadsheet after import, sort, subtotal and
formating the "Dauer" row as "time format"
oo-time-test.ods is the OpenOffice spreadsheet after import, sorting, subtotals
oo-timne-test.ods shows how it would be correct (and LO previous to 4.1 did
too)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
