Ubuntu
openoffice.org package

[Upstream] [hardy] direct export into .PDF shows 0 in cells, while cell is formatted as "0" to be supressed

Bug #129442 reported by mainspecht
4
Affects Status Importance Assigned to Milestone
OpenOffice
Confirmed
Unknown
openoffice.org (Ubuntu)
Won't Fix
Low
Unassigned

Bug Description

Binary package hint: openoffice.org

The spreadsheet is formatted as to suppress "zero" in cells without values.
Extras > Options > OpenOffice.calc > View
The spreadsheet then shows the formatted cells correctly.
When exported into .PDF, the .PDF then shows "zeros" in the cells, not showing "zeros" in the spreadsheet.

Chris Cheney (ccheney)
Changed in openoffice.org:
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
Chris Cheney (ccheney) wrote :

Confirmed on upstream's openoffice.org 2.4.0~rc2.

Revision history for this message
Chris Cheney (ccheney) wrote :

That option is only for view, to supress printing 0's you either have to use 0 suppression in the type field using '0;-0;;@' or go to Format->Page->Sheet->Print uncheck 'Zero Values'. There is an upstream bug I have attached that would if fixed make it more obvious what to do about the Zero Values problem.

Changed in openoffice:
importance: Undecided → Unknown
status: New → Unknown
Bug Watch Updater (bug-watch-updater)
Changed in openoffice:
status: Unknown → Confirmed
Chris Cheney (ccheney)
Changed in openoffice.org:
status: Confirmed → Triaged
Revision history for this message
Duncan Lithgow (duncan-lithgow) wrote :

This is also still the default behaviour in OOo 3.0 Build9347 (running on windows). I agree with the assumption of the original bug that the 0's should be suppressed in printout by default.

Chris Cheney (ccheney)
tags: added: hardy
Björn Michaelsen (bjoern-michaelsen)
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote : migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.