To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=95093
User productive changed the following:
What |Old value |New value
================================================================================
OS/Version|Windows Vista |All
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Platform|PC |All
--------------------------------------------------------------------------------
Summary|Calc save-as-XLS doesn't s|Calc save-as-XLS dates mis
|et cells to Date formattin|formatted in Works Spreads
|g |heet
--------------------------------------------------------------------------------
Version|OOo 3.0 |OOo 3.2.1
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Tue Jun 29 10:44:59
+0000 2010 -------
Further testing with the XLS file format shows the following:
(my locale is US-English)
Saved from OO 3.2.1 Opened in Excel 2007 Opened in Works 9
------------------- -------------------- -----------------
June 29, 2010 June 29, 2010 40,358
06/29/10 06/29/10 40358
Saved from Excel 2007 Opened in OO 3.2.1 Opened in Works 9
--------------------- ------------------ -----------------
June 29, 2010 June 29, 2010 June 29, 2010
06/29/10 06/29/10 6/29/2010
Saved from Works 9 Opened in Excel 2007 Opened in OO 3.2.1
------------------ -------------------- ------------------
June 29, 2010 June 29, 2010 June 29, 2010
6/29/2010 6/29/2010 6/29/2010
So Excel is able to do something without user intervention (make the date
readable in Works AND in more complete spreadsheet programs such as OO Calc)
that OO isn't able to do. Hopefully OO's save-as-XLS can be updated to save
date formats however Excel does it so that the date can be read both by Works
and by other spreadsheet programs.
Some users (who need to share their XLS files with people who use MS Office) may
have Works but not MS Office. These users should be able to preview their files
in Works to get some assurance that the files will be read properly in Excel.
Thanks in advance for your 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]
