CALC - no way to display all rows

abcd · March 31, 2020, 3:22pm

Hello,

I am getting crazy to display all the current sheet rows. I tried everything: disabling all the filters, Menu/Data/Rows/Show. Exporting the sheet as csv gives me all the rows. Using Linux, LO 6.3.4.2.

Thanks

abcd · March 31, 2020, 3:28pm

Sorry, I forgot to say that selecting all the sheet (CRTL+A) and pasting it into a new sheets gives me all the rows.

Thanks

anon73440385 · March 31, 2020, 3:35pm

Did you try to manually set row heights (Format -> Row -> Show only works in case of row height is almost zero. There are row height values which make it visually hidden, but from an application perspective the have a very low row height and the Show function won’t unhide 'em).

abcd · March 31, 2020, 3:56pm

Thanks, it worked!

anon73440385 · March 31, 2020, 4:08pm

Fort the records (according to comment of OP):

Set the row height manually, since there are row height values which make it visually hidden, but from an application perspective the have a very low row height and the Show function won’t unhide 'em).

Select row before and after unvisible rows and use Format -> Rows -> Height... and set to some value making the rows visible (e.g. 0.20").

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.

Lupp · April 5, 2020, 11:47am

… Or Optimal Height... instead of a specific height.