[Solved] Not printing hidden cells

Discuss the spreadsheet application
Post Reply
waynesherman
Posts: 2
Joined: Wed Sep 26, 2012 6:16 pm

[Solved] Not printing hidden cells

Post by waynesherman »

How do I prevent hidden cells from printing when I am in an .xls file in Calc?
Last edited by Hagar Delest on Thu Sep 27, 2012 8:20 am, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice.Org 3.4.1 Windows XP
User avatar
kingfisher
Volunteer
Posts: 2127
Joined: Tue Nov 20, 2007 10:53 am

Re: Not printing hidden cells

Post by kingfisher »

I don't know of a way to hide cells. If I hide a column and print to a document, the hidden column is not printed. That was an .ods file saved as an .xls file. It may be different with an .xls file created by MS Office.
Apache OpenOffice 4.1.12 on Linux
waynesherman
Posts: 2
Joined: Wed Sep 26, 2012 6:16 pm

Re: Not printing hidden cells

Post by waynesherman »

Thanks very much. The .xls file was created by Quattro Pro. Saving it as an .ods file, then resaving it as an .xls file from OpenOffice solved the problem.
OpenOffice.Org 3.4.1 Windows XP
Post Reply