To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108726 Issue #|108726 Summary|wrong data type in formulas Component|Spreadsheet Version|OOo 3.2 RC4 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|netbuster
------- Additional comments from netbus...@openoffice.org Wed Jan 27 23:38:50 +0000 2010 ------- Suppose you have cells from A1 to C1 formatted as numbers and a cell D1 filled with a simple formula (ie = B1-A1-C1). Now suppose to fill cell A1 with a different data type (let's say a character "F") In this case you got an "Error: wrong data type" in cell D1 In former releases this case was treated as "null" or "zero" value so that the formula could come out with a suitable result (i.e in this scenario result should be B1-C1). --------------------------------------------------------------------- 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