To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79752 Issue #|79752 Summary|Forumla calculation if cel format is text Component|Spreadsheet Version|OOo 2.2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|karlis
------- Additional comments from [EMAIL PROTECTED] Wed Jul 18 11:28:57 +0000 2007 ------- Cell A1 = 1. Format of cell is "text" (@). Cell B1 = 1. Format of cell is "standard" (or number). Cell C1 = A1*B1. Returns value of 0,00. If any of the cells used in the formula are formatted as text, then formula returns a result of 0,00. This behaviuor is wrong. The result should either take into account numeric values of the cells, despite their formatting or report an error. MS Excel uses numeric values of the cells for the calculation of formulas, ignoring the formatting. Thus a file, prepared in Excel can have different results of the formulas, if opened in OOO and the creator has been careless enough to mess with formatting of the cells. Such discrepancies are very hard to detect if they are just silently ignored as currently and can lead to very serious problems where people exchange files between the two spreadsheet applications. --------------------------------------------------------------------- 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]
