We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there a way to prevent Calc from showing hidden rows and columns when copying sheets?

asked 2019-03-23 02:04:44 +0200

Jeff_S gravatar image

updated 2021-06-12 00:22:43 +0200

Alex Kemp gravatar image

MS Office convert here and overall very impressed with how far the LibreOffice suite has come. However one issue has us very frustrated at the moment.

We have a spreadsheet that contains a dozen hidden rows and a few hidden columns, with some behind-the-scenes formulas and values that we rarely need to see. We routinely create copies of the previous period's sheet within the same workbook and make changes to the copy. When we did this in Excel the hidden rows and columns stayed hidden. However, Calc shows all the hidden rows and columns in the newly pasted sheet, requiring us to go in and tediously re-hide each of them whenever we make a copy.

We have tried messing with the Paste Special options, but to no avail. Hoping there is a workaround we haven't noticed or thought of.

If not, modifying Calc's copy-paste code to maintain hidden rows and columns would be a nice thing for the developers to work on.


edit retag flag offensive close merge delete


As I understand you wanted to copy complete sheets.
I cannot confirm your claim. My LibO V retains the hiding of rows and columns when copying a sheet using the respective item from the context menu of a sheet's tab. And a LibO V I had preserved did it the same way when I just tried.
Are your documents always in ODF format .ods (as it should be)? Were they originally created by an alien (and probably hostile) software?

Lupp gravatar imageLupp ( 2019-03-26 01:03:10 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-03-26 20:56:59 +0200

Lupp gravatar image

Use the respective item Move/Copy from the context menu of a sheet's tab, and select the Copy mode.

edit flag offensive delete link more

answered 2019-03-23 10:09:56 +0200

m.a.riosv gravatar image

updated 2019-03-26 00:03:10 +0200

Use Copy only visible cells extension, it adds a toolbar button.

edited 2019-03-26

Seems hidden property for rows or columns it's not pasted. But assining a minimal size like 0,01 works copying columns or rows. Another way it's copying the sheet right-click move/copy or dragging the sheet with holding [Ctrl] key

edit flag offensive delete link more


We want to copy the hidden cells, too. They are essential for several under-the-hood functions of the spreadsheet and have to be there. We just want them to remain hidden.

Jeff_S gravatar imageJeff_S ( 2019-03-25 18:30:10 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-23 02:04:44 +0200

Seen: 471 times

Last updated: Mar 26 '19