[Solved] Hide cell contents in Calc Spreadsheets

Help with installation and general system troubleshooting questions concerning the office suite LibreOffice.

[Solved] Hide cell contents in Calc Spreadsheets

Postby MSwhip » Wed Jun 27, 2012 11:13 am

Is it somehow possible to hide cells contents keeping contained functions -or formulas- without hiding rows and/or columns?

Cant find help on this in the OpenOffice Calc manual.

Does anyone have a good answer?

If it is possible what is the way to toggle the hide and view of those contents?

Thank you.
Last edited by Hagar Delest on Fri Aug 17, 2012 8:15 am, edited 1 time in total.
Reason: tagged [Solved].
User avatar
MSwhip
 
Posts: 17
Joined: Fri Apr 22, 2011 1:15 pm

Re: Hide cell contents in Calc Spreadsheets

Postby acknak » Wed Jun 27, 2012 2:46 pm

How would that work? I mean how would you hide one cell without hiding the whole row and/or column?

You can use tricks like changing the text color to match the background, or applying a custom number format like "" (hides all numbers) to make the cell appear empty.

Or, you can put those cells on a different sheet and hide that sheet.

That's about all I can think of ...
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Hide cell contents in Calc Spreadsheets

Postby MSwhip » Fri Aug 17, 2012 12:34 am

Back from a long trip now.
Thank you acknak for the viable suggestions, they are good enough to solve my issue.
Apache OpenOffice 4.1.1 with Windows 7 Home 64-bit
User avatar
MSwhip
 
Posts: 17
Joined: Fri Apr 22, 2011 1:15 pm


Return to LibreOffice

Who is online

Users browsing this forum: No registered users and 2 guests