To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79752
User fst changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Priority|P2 |P4 -------------------------------------------------------------------------------- Resolution| |DUPLICATE -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Wed Jul 18 11:51:15 +0000 2007 ------- 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 *** --------------------------------------------------------------------- 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]