To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59669 Issue #:|59669 Summary:|if resulting from a formula, -1 is formatted as |"TRUE" Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|rmano
------- Additional comments from [EMAIL PROTECTED] Thu Dec 22 02:49:26 -0800 2005 ------- Enter in B1 =IF(A1<0;1;-1) and copy three rows down. Then enter in column A -1, 0, 1 What I see is -1 TRUE 0 TRUE 1 1 i.e., -1 is formatted as "TRUE" by default if resulting from a formula. Choosing a fixed number format correct it. --------------------------------------------------------------------- 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]