To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104424 Issue #|104424 Summary|Request ability to test for and suppress zero printing Component|Word processor Version|1.0.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|writerneedsconfirm Reported by|mrmikel
------- Additional comments from mrmi...@openoffice.org Sat Aug 22 11:31:26 +0000 2009 ------- This is a feature which may or may not be implementable because of a lack in ODF. In a table in writer, I would like the ability to test for blank spaces and suppress the zero which appears in a summary column. In an invoice form, I have the number of items, description, cost each and a column in which the number of items multiplied by cost is displayed. Most often, there are only one of two items, leaving several rows empty. As currently configured, writer will put a series of zeros in the last column, which is not visually appealing, especially if there are 12+ rows. I have tried to specify an IF function for the last column (IF(<a12>*<a14>=0; "", <a12>*<a14>), but it does not work. Wordperfect provides an isblank function which does work with the if function in the word processor which accomplishes this. This is a roadblock to my giving up Wordperfect and cutting over to OpenOffice altogether. --------------------------------------------------------------------- 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...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
