Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

This is not an issue with your data but with Libre Office. I copied a fewer than 100 rows by 15 columns from an existing xls into a new sheet and the new sheet then contained 1,048,576 rows. This needs a ticket over at Libre Office as the solution suggested above may very well fall foul of the same issue again.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .