To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95715 Issue #|95715 Summary|incorrect formula in xls file Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|raal
------- Additional comments from [EMAIL PROTECTED] Fri Oct 31 19:00:18 +0000 2008 ------- When open xls file in OOo, I have incorrect formulas in cells correct formulas in cells: S19,S20,S21,S22 incorrect formulas in cells: S23,S24,S25 for example formula in excel: =IF(FK23=0;0;FK23+(AD23*(FK23/(FK23+FH23+FD23)))) formula in OOo: =IF(AIY23=0;0;AIY23+(AD23*(AIY23/(AIY23+AIV23+AIR23)))) When I delete entire rows 19,20,21,22 in excel,save and open in OOo then formula in cell S19 is correct. On Ubuntu 8.04,00o 2.4(ubuntu version) are formulas correct. Excel 2003, OOo 3 (OOO300m9, build 9358). WinXP. --------------------------------------------------------------------- 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]
