To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77996 Issue #|77996 Summary|Localized Excel's CELL function fails to re-calculate Component|Spreadsheet Version|OOo 2.2 RC4 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|er Reported by|kohei
------- Additional comments from [EMAIL PROTECTED] Thu May 31 14:13:05 +0000 2007 ------- We've encountered an issue where opening an Excel file saved in French version of Office 2003 in Calc causes Err502 upon recalculation. Further investigation revealed that it was due to CELL function's 1st argument being localized in Excel, but Calc only handles the English keywords in the 1st arg of CELL function. French version of MS Office does the following mapping (fr->en): adresse - address colonne - col contenu - contents couleur - color format - format largeur - width ligne - row nomfichier - filename parentheses - parentheses prefixe - prefix protege - protect type - type A temporary fix is to translate these French keywords into English in ScInterpreter::ScCell() before the 1st arg is compared in a series of if/else-if statements, but I was wondering what the "right" fix would be to solve this problem. Kohei --------------------------------------------------------------------- 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]