Page 1 of 1

Large spreadsheet does not open in OpenOffice

PostPosted: Fri Nov 13, 2015 6:12 pm
by ammorei
Good afternoon!

I have a spreadsheet in '.xlsx', with a size around 150Mb and containing +/- 400000 lines.
I tried to open it in OpenOffice and the program is with a gray screen with the progress bar, just arriving at a point that the bar does not advance and the program simply crashes.

Is there any way to open this worksheet in OpenOffice.
Libre Version: 4.1.2

Thank you!

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Fri Nov 13, 2015 8:11 pm
by Zizi64
If I understood exactly?

Have vou tried to open the file with

Apache OpenOffice (which version?)
LibreOffice 4.1.2
LibreOffice 5.0.3.2 (the version in your signature)
 Edit: Edited 


All of distributions and versions was crashed?

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Fri Nov 13, 2015 8:31 pm
by ammorei
Excuse.

Was trying to open the Libre 5.0.3.2 and now I'm trying to open in OpenOffice 4.1.2 and in both programs is problem.
Processing and spreadsheet is then locks the program.

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Fri Nov 13, 2015 9:40 pm
by jrkrideau
There was a recent posting about a similar problem about a week ago https://forum.openoffice.org/en/forum/v ... =9&t=80206 but the problem was the file would not open in AOO but would in LibreOffice so you might get it to open in AOO.

Where did the .docx file come from---I'm wondering if there may have been a glitch in transferring it. If you can what about trying to open the file in Excel just to check that it is not seriously corrupted?

Another approach, if Excel is not handy, might be to see if it opens in Gnumeric. I am coming to think of Gnumeric as the Swiss knife or Leatherman tool for opening wonky spreadsheet files.

 Edit: Depending on where it came from it might not even be a .docx file but just have a .docx suffix. A lot of reporting programs tend to do this because Excel seems to be specifically engineered to open that kind of file and AOO Calc is not. I'd suggest trying to open the file with text editor. If it is a text file just change the name from file.docx to file.txt and Calc should be able to open it from within Calc. 

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Fri Nov 13, 2015 11:10 pm
by RusselB
Noting as how you are referring to a spreadsheet, I recalled a similar problem with large spreadsheets (200,000+ rows), which was caused by the Auto-Height Adjustment routine taking so long that the system was frozen.
I did get an extension (thought it was actually a macro, but my files show it as an extension) that resolved the problem.

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Sat Nov 14, 2015 1:46 am
by jrkrideau
I have the feeling that that may have been the problem with the earlier spreadsheet as well. It took approximately 10 minutes to adjusting row heights and then crashed with no error message.

Re: Large spreadsheet does not open in OpenOffice

PostPosted: Thu Mar 26, 2020 7:50 pm
by John_Ha