Apache OpenOffice (AOO) Bugzilla – Issue 79752
Forumla calculation if cel format is text
Last modified: 2007-07-18 12:51:37 UTC
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.
Created attachment 46884 [details] example
Hi, text is text and you can't calculate with text. So the convention is to set text to the value zero. So Calc acts correctly. Please use the search functionality of Issuezilla before submitting Issues. This is a double to a lot of Issues, especially Issue 5658 . For finding such formatted cells, use the Value Highlighting feature which can be reached with CTRL+F8 . Blue is a number, black a text and green are formula results. *** This issue has been marked as a duplicate of 5658 ***
closed double