Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've pasted the data from an outer source into LibreOffice Calc. There are ~3000 legit rows and around a million empty after. This makes problems with vertical scrollbar because it is very small now and I can't scroll down or up because it's so sensitive.

I think I need to somehow delete those empty rows or hide them, but how?

share|improve this question
What's your external source and why can't you get just the 3000 good rows? –  Green Sep 6 '12 at 12:08
I did. I don't know where all the other empty rows came from. I think after applying a border for whole column instead of specific cells but I'm not sure. –  Primož Kralj Sep 6 '12 at 12:11
and now .. what is the external source? can you modify the output of that source? is working with .csv files an option (coz text-modifying tools work on text-only files) –  akira Sep 6 '12 at 12:16
Let's put it this way: I have an .ods file which contains all this info. The source of the original data is gone. I need to fix it within Calc, if possible? –  Primož Kralj Sep 6 '12 at 12:28

1 Answer 1

If your data permits it, you could paste the whole thing into a text editor like Notepad++. That should clean up your extra rows pretty easily or at least identify where the extra 997 000 rows are coming from. You may lose some column markers but that can be fixed after working out where the other rows come from.

share|improve this answer
Thanks for suggestion but my source is not available anymore. I want to fix this within Calc. –  Primož Kralj Sep 6 '12 at 12:28
If you save the data from Calc as a .csv, you can then open it in a text editor, follow Green's suggestion, then open it in Calc again and save it as an .ods. –  SaintWacko Sep 6 '12 at 12:46
That sounds good SaintWacko. Seconded. I'm frankly very surprised that Calc will even open 1M rows. Any non trivial amount of data per row could easily push the total table size into the tens or hundreds of megabytes. –  Green Sep 6 '12 at 13:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.