Calc - Printing of Cells without Contents
We should finish this until 2011-07-14 so that we can get fixes for 3.5
|Main Authors||Rainer Bielefeld|
|Last major Change||2011-07-11|
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.
- 1 Specification
- 1.1 Current Situation
- 1.2 Target Situation
- 1.3 Clarification Need
- 1.4 Competitors
- 1.5 UI definitions
- 1.6 Help texts affected
- 1.7 Alternative Solutions
- 2 Additional Information
- 3 Last but not least
Currently LibreOffice does not print all formatted empty cells of a printed sheet. This seems to be a simple bug, but discussion in tdf#39068 - 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
- WYSIWYG, a printed page of a sheet should show the same contents as visible on screen, except settings are different.
- 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
- 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
- if the pages will be printed, all formatting will be printed
If this specification does not respect particular needs, please contribute a user scenario showing that issue.
Additional required Fixes
Preference: Suppress empty pages
There are 3 checkboxes in UI that seem to be all for the same: Suppress printing empty pages:
- Menu 'Tools -> Options -> Calc > Print
- Menu 'File -> Printer settings
- Menu 'File -> Print -> LibO Calc - Include output of empty pages
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.
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.
- 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.
|print range||like LibO?||If no suppressions have been activated, all pages with cell contents AND formatting will be printed, also behind last cell contents.||....|
- 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.
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
- Unexpected big printouts if all cells of a sheet have background or border
Related / Open bug reports
- Direct relation
- tdf#39068 - PRINTING only first area with color formatted cells (background, border), same with PDFEXPORT
- Indirect relation
- Not related, but found during investigations:
Last but not least
|User Experience||Regina Henschel||........|
|Quality Assurance||Rainer Bielefeld||LibreOffice@bielefeldundbuss.de|
Terms, Acronyms and Abbreviations
Some may be only valid for this specification
|Term, Acronym or Abbreviation||Definition|
|WYSIWYG||What You See Is What You Get|
|Formatting||Cell borders and cell background|
|Print / Printing||also includes PDF export|
|cell contents||values, strings, formulas, but not background or borders|