To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99075 Issue #|99075 Summary|Formula not recalculated Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|askerix
------- Additional comments from aske...@openoffice.org Tue Feb 10 13:49:24 +0000 2009 ------- I created a spreadsheet which should recognize the application that opened it. Opening the spreadsheet in MS Excel, the cell is correctly recalculated, while it fails in O.O. Calc. I tried also to force recalculation manually, by pressing F9 or editing the cell without modifiy its content. It works only if I modify the cell's content. It happens when you first open the spreadsheet with MS Excel then with Calc. The formula typed in the cell is the following: (italian version) =SE(VAL.ERRORE(ADESSO()+ATTUALE());"MSExcel";"OpenOfficeCalc") (english version) =IF(ISERROR(NOW()+CURRENT());"MSExcel";"OpenOfficeCalc") Best regards. Alessandro --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
