Issue 36632 - Hide cells from printing, spreadsheet prints blank page.
Summary: Hide cells from printing, spreadsheet prints blank page.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: printing (show other issues)
Version: 680m71
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-11-04 03:16 UTC by dxg
Modified: 2017-05-20 11:13 UTC (History)
2 users (show)

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

Attachments
File contained inside the zip is "test.sxc" (4.71 KB, application/octet-stream)
2004-11-04 03:18 UTC, dxg 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dxg 2004-11-04 03:16:19 UTC 
The problem is that if I set all non empty cells on a page to "hide when 
printing" (cell protection tab), a blank page is printed.
I have ticked [Tools -> Options -> Spreadsheet -> Print -> Supress output of 
empty pages] which did not resolve the issue.

I have attached an example spreadsheet which demonstrates the problem.
When printed (A4 page size), page 1 should contain the text "This is a test", 
whereas the second page which contains the text "Hidden" (contained in a cell 
which is hidden from printing) should not be printed at all, but instead an 
empty page is produced. Setting an empty header and footer does not help.

Thanks for your time.
Comment 1 dxg 2004-11-04 03:18:21 UTC 
Created attachment 18899 [details]
File contained inside the zip is "test.sxc"
Comment 2 ndtandug 2004-11-25 02:11:49 UTC 
Could not replicate your problem. I downloaded your file and followed the steps
but can print only 1 page when I hide the non-empty cell in second page.

My system: 

P4, win98se, OOo 1.1.3
same behaviour using OOo1.9.60
Comment 3 dxg 2004-11-26 08:05:06 UTC 
Quote:
"...when I hide the non-empty cell..."

How exactly did you do this, because the cell is already hidden from printing in 
the provided file..

I re-downloaded the file, re-tested, and still have the same issue. Deleting the 
cell results in only 1 page being printed, so it's unlikely something else is 
causing this.

How strange...
Comment 4 abdul 2004-12-23 07:04:18 UTC 
I am able to replicate the issue on 1.1.3  and m62

My system : p4, NLD , oo.0 1.1.3, m62
Comment 5 abdul 2005-01-06 10:26:00 UTC 
confirming.....
Comment 6 oc 2005-01-17 11:43:32 UTC 
Hi Niklas, one4you
Comment 7 bettina.haberer 2005-01-18 10:22:09 UTC 
As this issue is an enhancement, it is reset to the correct owner of requirements.
Comment 8 oc 2005-01-18 10:32:59 UTC 
changed issue type to defect and changing owner to nn
Comment 9 Marcus 2017-05-20 11:13:20 UTC 
Reset assigne to the default "issues@openoffice.apache.org".