Calc - Printing of Cells without Contents

We should finish this until 2011-07-14 so that we can get fixes for 3.5

Specification
This Specification defines how printing of a sheet with cells without real content, but background and / or border formatting information should work. Basic information from Help: "Pages - Suppress output of empty pages - Specifies that empty pages that have no cell contents or draw objects are not printed. Cell attributes such as borders or background colors are not considered cell contents. Empty pages are not counted for page numbering.

Current Situation
Currently LibreOffice does not print all formatted empty cells of a printed sheet. This seems to be a simple bug, but discussion in  - PRINTING only first area with color formatted cells (background, border), same with PDFEXPORT seems to show that there is no agreement concerning all aspects of "Printing empty Cells"

Examples: Please use test kits and sample documents from Bug 39068

Details

 * 1) WYSIWYG, a printed page of a sheet should show the same contents as visible on screen, except settings are different.
 * 2) Never print pages behind last cell with content of page (although Excel does that in a different way).
 * If a user selected fat red border around all cells, he does not want to print all 1 million lines of the sheet, but only the ones with contents


 * 1) Allow user to select how to proceed with empty pages (without cell contents) in front of last page with contents with a preference: Print pages without cell contents
 * 2) if the pages will be printed, all formatting will be printed

User scenarios
If this specification does not respect particular needs, please contribute a user scenario showing that issue.

Preference: Suppress empty pages
There are 3 checkboxes in UI that seem to be all for the same: Suppress printing empty pages: My results As Testcase Spreadsheet background green in 'A1:B6' background blue in 'A8:B300', 'A1=1', 'A120=3'. Expected result: if print of empty pages is suppressed, only pages 1 and 3 should be printed (because of cell content). If print of empty pages is NOT suppressed, pages 1 to 3 (also empty page 2 with only colored background should be printed. Currently it seems to be not clear what setting might have priority (and what one might change other boxes when modified, too). For example it's possible to have Unselected 'Suppress print of empty pages' in 1, but selected in 2. A) Modifications in 2 seem to be without any effect, although "Suppress" is checked, empty page remains visible in print preview and will be printed. The setting is without influence for other documents and is enduring until the document will have been closed. When reopened, the setting from 1 has been taken for that checkbox. B) Modifications in 1 are enduring, also valid for new opened Calc Documents and already opened Calc documents. Checkboxes 2 and 3 will be modified by changes in 1 as expected. C) Modifications in 3 work for the following print as expected for the current print. For the next print the setting from 1 has been taken for that checkbox.
 * 1) Menu 'Tools -> Options -> Calc > Print
 * 2) Menu 'File -> Printer settings
 * 3) Menu 'File -> Print -> LibO Calc - Include output of empty pages

Conclusion: the hierarchic is useful and logic, but we have an UI bug and Help issues. To Do: Repair for not working checkbox from A. Links in Help buttons should be modified that relevant Help will be opened directly with click. Help for 1 should mention influence to 2, 3 and also influence for PDF export.

Navigation within sheet

 * 1) There is no way to reach the end of a formatted area. It's easy to set background for all cells or a column, but how can I reach the end of the formatted area to set filling of last cell to "without"? Ctrl+End will not work. Currently not a real bug, because due to HELP formatting is no contents, but might be irksome for some users.

Competitors
Own conclusions
 * print range: Excel Behavior is not a good idea, LibO Target is more comfortable for most applications. If user wants to print empty pages behind last real cell contents, he can type a blank into the last required page.

UI definitions
If no bugs will be found, no bigger modifications will be required Currently a useful help text concerning influence or "suppress print of empty pages" only will be reached from Menu 'Tools -> Options -> Calc > Print' in lots of steps, from other dialogs you cant reach useful help concerning this particular setting. Clicking Help button should directly lead to expected HELP

Possible settings with influence

what needs to be added / changed

Tool tips and enhanced tool tips

Help texts affected

 * Help more or less contains all required information.
 * But complete definition of Empty pages is missing: Empty pages are pages without contents between 'A1' ad last "real" content of the sheet. Empty cells of a sheet far behind 'A1="x"' are not "empty pages", no suppression is required to prevent from printing 1000 empty pages.
 * Influence to PDF export is missing
 * Calc Printer Setup and Help you reach from Calc Menu 'File -> Printer Settings' is without Calc specific information concerning "Options" button.

Print all formatted cells

 * Pro
 * Contra
 * Unexpected big printouts if all cells of a sheet have background or border
 * Unexpected big printouts if all cells of a sheet have background or border

Related / Open bug reports

 * Direct relation
 * - PRINTING only first area with color formatted cells (background, border), same with PDFEXPORT


 * Indirect relation
 * - EasyHack?: UI: grid lines disappeared in Calc for cells with background color
 * - UI: Checkbox 'Suppress output of empty pages' without influence


 * Not related, but found during investigations:
 * - UI inconsistent concerning suppression of output for empty pages
 * - WIKIHELP: Page completely broken for "Printer Setup"

File Format
no changes

Configuration
no changes

Migration
no changes

Accessibility


= Last but not least =

Terms, Acronyms and Abbreviations
Some may be only valid for this specification