Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Forumla calculation if cel format is text | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | karlis <pepu2> | ||||
Component: | code | Assignee: | spreadsheet <spreadsheet> | ||||
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> | ||||
Severity: | Trivial | ||||||
Priority: | P4 | CC: | issues | ||||
Version: | OOo 2.2.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows XP | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
karlis
2007-07-18 12:28:57 UTC
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 |