To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72883
Issue #|72883
Summary|DAYS() function export to Excel
Component|Spreadsheet
Version|OOo 2.0
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|save-export
Assigned to|spreadsheet
Reported by|senyahnoj
------- Additional comments from [EMAIL PROTECTED] Fri Dec 22 04:28:13 -0800
2006 -------
The following in-cell code in a Calc .ods spreadsheet
=DAYS("20/01/2007";TODAY())
when 'saved as' a 'Microsoft Excel 97/2000/XP (.xls)', translates it to
=DAYS("20/01/2007",TODAY())
As it doesn't have a DAYS() function, Excel doesn't recognise this (Excel 2002).
Excel would however recognise it if it were translated to:
=DATEDIF(TODAY(),"20/01/2007","d")
Notes:
1. DATEDIF() seems to be a rather obscure Excel function:
http://www.meadinkent.co.uk/xl_birthday.htm
2. Forgive my British English date formats if you are elsewhere (d/m/yyyy)!
---------------------------------------------------------------------
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]
