https://issues.apache.org/ooo/show_bug.cgi?id=125294
Issue ID: 125294
Issue Type: DEFECT
Summary: Bad date data transfer from Excel CSV report
Product: Calc
Version: 4.1.0
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83720
--> https://issues.apache.org/ooo/attachment.cgi?id=83720&action=edit
Screen shot of date format missorts
Running and editing a report from a Excel driven medical software system called
Bright Tree.
When saving and importing to AOO everything but the date format transfers
smoothly.
The date format however is what I need the most for proper sorting of
formatting.
When AOO sorts the dates it does not appear in correct date order but rather in
numerical order;
{ie;
should be 8/1/14, 8/2/14, 8/3/14, etc
instead 8/1/14, 8/10(-19)/14,2/14, 8/20(-29)/14, etc}
When I try to change it to the format I want, it does nothing at all. No matter
what date format I ask it to change to it won't change.
This is a HUGE monthly report and I am tired of doing it via copy/paste.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
