hiding rows & columns

asked 2017-07-30 21:31:03 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am aware of the procedure/method to hide unused rows & columns. But they always re-appear after saving & re-open my LO spreadsheet. Is there a way to lock out these unused rows & columns?

edit retag flag offensive close merge delete


What format do you use to store the spreadsheet? Isn't that a no-formatting text-only CSV by chance?

Mike Kaganski gravatar imageMike Kaganski ( 2017-07-30 22:04:27 +0200 )edit

Its being saved as an .xls file

BobMcP gravatar imageBobMcP ( 2017-07-30 22:37:11 +0200 )edit

Ok, then. I won't tell you using native ODF format; I just tested myself a simple file, and it worked for me with XLS. Please tell other relevant info: which LO version do you use, and which OS. We have to ask data from you by pieces, as if it's we tho are interested in help.

Mike Kaganski gravatar imageMike Kaganski ( 2017-07-30 22:43:21 +0200 )edit

Tnx Mike. I'm using LO with W10 ver 1703. You got it! It works when I save as .odf, but NOT if I save as .xls!

BobMcP gravatar imageBobMcP ( 2017-07-30 23:00:18 +0200 )edit

Very strange. It works for me with with XLS. I might only guess it's somehow file-specific (?): some nuance in file (a combination of data revealing a bug in LibreOffice; or a corruption in the data that manifests itself that way). Sorry, cannot assist more. You could still link a test file here, or file a bug at Bugzilla.

Mike Kaganski gravatar imageMike Kaganski ( 2017-07-30 23:09:24 +0200 )edit