To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54283 Issue #:|54283 Summary:|Calc prints 0 in empty cells with formulas Component:|Spreadsheet Version:|OOO 2.0 Beta2 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|printing Assigned to:|spreadsheet Reported by:|philipmateescu
------- Additional comments from [EMAIL PROTECTED] Tue Sep 6 09:58:09 -0700 2005 ------- Problem: The attached zip file contains an Excel spreadsheet which has several columns with formulas in them, but which do not show any values. Upon printing, a lot of these cells display 0 instead of nothing. Expected result: Printing should not print values that are invisible on the screen. To reproduce: 1. Open the XLT file. Click either Enable or Disable Macros. 2. Notice the Mileage column shows no values (formula is =(F28*dflt1)) 3. Click the Print Preview button. The mileage column shows $0.00 for it's entire span. (same with some cells in # of Miles, Phone, Other, and the Total Column). I've also attached two images. One of the spreadsheet and the other of the print preview for easy comparison without having to perform the above steps. thank you. --------------------------------------------------------------------- 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]
