You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/07/21 19:26:01 UTC
[Issue 125294] New: Bad date data transfer from Excel CSV report
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: issues@openoffice.apache.org
Reporter: sjphotographx@hotmail.com
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.
[Issue 125294] Bad date data transfer from Excel CSV report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125294
--- Comment #4 from Sheila <sj...@hotmail.com> ---
(In reply to Kay from comment #2)
> I am testing on Linux AOO 4.1.1M2.
>
> I put in a few dates in col A with date format mm/dd/yy. Then sorted and
> everything was OK. Can you check to see how Col A is defined for you
> currently?
> Select the column then go to Format->Number->Date and make sure the correct
> date format is set. I hope this solves your problem.
>
> But as Regina suggested, an attachment would help.
Everything does work great when I start a new spreadsheet, its only when I pull
this report from the software system and that's when it misinterprets the code
for the date changes.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125294] Bad date data transfer from Excel CSV report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125294
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
CC| |rb.henschel@t-online.de
--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
Can you please attach such file itself? A screenshot is not enough for
investigating.
Is the software able to save in a csv format?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125294] Bad date data transfer from Excel CSV report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125294
--- Comment #3 from Sheila <sj...@hotmail.com> ---
(In reply to Regina Henschel from comment #1)
> Can you please attach such file itself? A screenshot is not enough for
> investigating.
>
> Is the software able to save in a csv format?
REPLY: No I am sorry there is detrimental client information on the original
file and I am not at liberty to share that information.
I have not tried saving in csv format, but that is what I am pulling the
original file from.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125294] Bad date data transfer from Excel CSV report
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125294
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |kschenk@apache.org
--- Comment #2 from Kay <ks...@apache.org> ---
I am testing on Linux AOO 4.1.1M2.
I put in a few dates in col A with date format mm/dd/yy. Then sorted and
everything was OK. Can you check to see how Col A is defined for you currently?
Select the column then go to Format->Number->Date and make sure the correct
date format is set. I hope this solves your problem.
But as Regina suggested, an attachment would help.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.