Technote (troubleshooting)
Problem
When printing a Microsoft Excel spreadsheet in which the zero values are suppressed, the zero values appear when the document is printed using IBM® Lotus® Symphony Spreadsheets.
Symptom
When you open an Excel spreadsheet that has the zero values suppressed into Lotus Symphony, the cells look fine until the file is printed.
Cause
In Lotus Symphony Spreadsheet, you must specify whether to show/hide zero value cells by changing options in preference settings. This behavior is different from that of Microsoft Excel, where the Windows option controls the suppression of zero values in both the display and for printing.
Behavior of displaying the zero value in Microsoft Office is described in the following topic:
http://office.microsoft.com/en-us/excel/HP100704611033.aspx
Resolving the problem
For automatically suppressing zero value cells, you can adjust following two options.
To Show/Hide numbers with zero value:
- Click File -> Preferences... -> IBM Lotus Symphony -> Lotus Symphony Spreadsheets -> View
- Under Display, select or deselect Zero Values.
To Print/Not Print numbers with zero value:
- Click File -> Page Setup -> Sheet
- Under Print, select or deselect Zero Values.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.