Openning big files in OpenOffice Spreadsheet

12/05/2008

When your files are too big, OpenOffice Spreadsheet will ignore anything after line 65536, my suggestion is, split it in other tabs:

marcelo@yogananda:~/Desktop$ wc -l foo-2008-04.csv
73538 foo-2008-04.csv
marcelo@yogananda:~/Desktop$ split foo-2008-04.csv -l 37000 foo
marcelo@yogananda:~/Desktop$ ls foo*
foo-2008-04.csv  fooaa  fooab
marcelo@yogananda:~/Desktop$ wc -l fooa*
  37000 fooaa
  36538 fooab
  73538 total

After this, Insert -> Sheet From File…