Issue 85076 - Calc won't print/preview documents containing only cell borders
Summary: Calc won't print/preview documents containing only cell borders
Alias: None
Product: Calc
Classification: Application
Component: printing (show other issues)
Version: 680m241
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability, usability
: 95293 95407 (view as issue list)
Depends on:
Reported: 2008-01-08 10:59 UTC by jpryor
Modified: 2017-05-20 11:11 UTC (History)
6 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: ---
Developer Difficulty: ---

sc-print-lines.diff (625 bytes, patch)
2008-01-08 11:01 UTC, jpryor
no flags Details | Diff
Sample Spreadsheet (6.67 KB, application/vnd.sun.xml.calc)
2008-01-08 13:18 UTC, jpryor
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jpryor 2008-01-08 10:59:09 UTC
Calc will not print or page preview documents containing ONLY cell borders (i.e.
no other content, only cell border changes).

To reproduce:

1. Click File->New->Spreadsheet
2. Select cell B2
3. Click Format->Cells...
4. Click the Borders Tab
5. Under Line Arrangement/Default, click "Set all four borders" widget.
6. Click OK.  There should now be a border around cell B2.
7. File->Page Preview.  A blank page is shown.

Printing fares no better; a blank page is generated.
Comment 1 jpryor 2008-01-08 11:01:19 UTC
Created attachment 50734 [details]
Comment 2 niklas.nebel 2008-01-08 12:46:18 UTC
This would conflict with the description of "Suppress output of empty pages" in
the online help. Also, if only single pages out of a larger sheet are concerned,
I think the existing behavior is preferable.
Comment 3 jpryor 2008-01-08 13:18:49 UTC
Created attachment 50736 [details]
Sample Spreadsheet
Comment 4 jpryor 2008-01-08 13:23:06 UTC
The point is that, as far as the user is concerned, when a cell has a border the
docuement is NOT empty.  See the attached "Sitzplan Physiksaal.ods" as an
example -- it resizes cells and applies borders, but has no "content" (images,
text, etc.).  This is deliberate on their part, I assume because they want to
print out the table and write on it by hand afterward.

Yes, the online help says "Cell attributes such as borders or background colors
are not considered cell contents," but I think this is counter-intuitive for
most users, especially since the "Suppress output of empty pages" option is
enabled by default.
Comment 5 jpryor 2008-01-08 17:11:33 UTC
Not sure if this matters, but in a survey of other spreadsheet programs...

A major commercial known-by-everyone spreadsheet program considers cell borders
and cell background color to be "content".

KSpread (the KDE Spreadsheet program) doesn't make a "content" determination; it
always prints something, even if the page is blank.

Gnumeric is stricter about content than Calc; in order to print a cell, the cell
must contain some content (e.g. a space).  So in Calc for "Sitzplan
Physiksaal.ods," a single space in ANY cell would allow EVERYTHING to be
printed.  In Gnumeric, ALL cells with borders would need to have a space in
order for EVERYTHING to be printed.

Given this, I think Calc should follow suit and consider cell borders and
background to be considered as content, so that user expectations are met. 
(Really, who wants to dig through the Calc preferences dialog to find the
"Suppress output of empty pages" checkbox, especially when most people [0] are
going to consider a non-blank page NOT being empty, and thus won't think it
applies to them anyway!)

[0] "most people" statistic completely made up

The key point is matching user expectations.  Pointing to documentation isn't
sufficient, as most people [0] don't read the documentation in the first place.
Comment 6 frank.loehmann 2008-05-06 15:13:25 UTC
change target.
Comment 7 frank.loehmann 2008-05-06 15:13:57 UTC
cc myself
Comment 8 frank.loehmann 2008-10-27 10:45:58 UTC
cc mla.
Comment 9 Marcus 2008-10-27 11:00:47 UTC
*** Issue 95407 has been marked as a duplicate of this issue. ***
Comment 10 Marcus 2008-10-27 11:01:37 UTC
set target to 3.1
Comment 11 Marcus 2008-12-02 16:50:49 UTC
due to short timeframe shifted to OOo 3.2
Comment 12 Regina Henschel 2009-01-10 22:15:04 UTC
*** Issue 95293 has been marked as a duplicate of this issue. ***
Comment 13 Marcus 2009-09-28 17:16:52 UTC
set target to 3.x
Comment 14 Rob Weir 2013-03-11 15:03:20 UTC
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:


Comment 15 Marcus 2017-05-20 11:11:29 UTC
Reset assigne to the default "".