To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77927 Issue #|77927 Summary|WEEKNUM function is not converted from Excel correctly Component|Spreadsheet Version|OOo 2.2 Platform|All URL|http://starsky51.googlepages.com/Book6.xls OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|starsky51
------- Additional comments from [EMAIL PROTECTED] Wed May 30 10:26:18 +0000 2007 ------- When a excel workbook is opened which contains a cell using the WEEKNUM function, the formula is converted to WEEKNUM_ADD, as it should be. However, only one parameter is included in the converted formula (eg. WEEKNUM_ADD(A1)). This gives an err:504 because WEEKNUM_ADD takes two parameters (eg. WEEKNUM_ADD(A1;1)). Example attached. I've only been able to test this in Windows. --------------------------------------------------------------------- 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]
