To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114491 Issue #|114491 Summary|Incompatibility with some date functions of excel spre |adsheet due to parameter type. Component|Spreadsheet Version|OOO320m18 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|giutino
------- Additional comments from [email protected] Tue Sep 14 11:28:05 +0000 2010 ------- The functions "Month", "Day" and "Year" of Openoffice calc work a bit different than the corrispective functions of Microsoft office excel (2007 and 2010) and this cause an incompatibility with some MSOffice xls files. The problem is due to the fact that the "Day" (or Month or Year) function of excel recognize as parameter also a text string representing a date but Oo calc doesn't do this. Example to reproduce the problem: Start Microsoft Excel and create a file test.xlsx with this content [cell A1] ="14/09/2010" (A text string representig a date) [cell B1] =DAY(A1) (We want to put in this cell the day of the data contained in A1. With excel (2007 or 2010) all works properly and the content visualized in the cell B1 is 14. Now if we open the same file with open office calc we have an error in the cell B1, this error is due to the fact that the function DAY of calc doesn't recognize a string as a valid parameter. To solve this problem manually we have to modify the content of the cell B1 as [cell B1] =DAY(DATE.VALUE(A1)) This is not difficult to do when a new oo calc document is created but is problematic when a xslx file created with excel with many cells containing those function is opened in calc. Could you modify the function DAY, YEAR and MONTH? For example when the DAY function notice that the parameter is a string of text it apply automatically and transparently the function DATE.VALUE to its parameter. --------------------------------------------------------------------- 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]
