[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 User yuko changed the following: What|Old value |New value CC|''|'yuko' --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 07:39:26 + 2008 --- This issue occurs in OOo 3.0. The date format /MM/DD in Excel is displayed as DD-MM-YY in OOo Calc. Please see the attached screenshot. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 07:40:55 + 2008 --- Created an attachment (id=57486) screenshot for date format in Excel and Calc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 07:41:38 + 2008 --- Created an attachment (id=57487) Excel SpreadSheet 2003 xml file - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 User sus changed the following: What|Old value |New value Target milestone|OOo Later |OOo PleaseHelp --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 17:31:11 + 2008 --- Hi, thanks for the bug report. Nevertheless, my work shifted to ODF OASIS Technical Comitee work, esp. metadata in ODF 1.2 and ODFDOM as library, I won't be working on these filters any longer. We here in Hamburg (Sun) are focusing on development the new OOXML (as Microsoft does). If on the elder Microsoft 2003 XML format filters some fix is in need from the community, we need as well someone from the community to fix it. Changed therefore the status to OOo Please help.. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |sus Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Fri Oct 12 08:31:08 + 2007 --- Hi Swante, one more for you. Proceed as needed. Frank - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 80758] Bad date format imported f rom Excel XML
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80758 Issue #|80758 Summary|Bad date format imported from Excel XML Component|Spreadsheet Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|open-import Assigned to|spreadsheet Reported by|joghurt --- Additional comments from [EMAIL PROTECTED] Thu Aug 16 20:55:47 + 2007 --- Preface: I've tried OOo 2.2.1 Hungarian on a Hungarian XP, and exported from a Hungarian Excel. I expected dates keeping their format (-MM-DD, that's how we use dates in Hungarian). 0. Change Windows short date format to something else than DD-MM-YY. (Try the U.S. order MM-DD-YY, or the Japanese/Hungarian YY-MM-DD.) 1. Enter a date in Excel. 2. Format the cell to short date format. 3. Export spreadsheet in XML format. 4. Open in OOo Calc. 5. The date format will be D-M-YY instead of the short date format according to the system/user default locale. In my case, it should have been -MM-DD. Inside the XML file: Cell ss:StyleID=s29Data ss:Type=DateTime2007-06-02T00:00:00.000/Data/Cell while s29 defines NumberFormat ss:Format=Short Date/ - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
