I have price list in .xlsx format and it weighs 60mb. Calc wont open it.

asked 2018-02-28 07:33:38 +0100

Maxpain gravatar image

updated 2018-02-28 08:03:00 +0100

Kruno gravatar image

Hello. I have price list, on .xlsx format. It weighs 66 mb. I tried to open in "cacl", but its cant open. Gone more time (about 1-2 hours) , but no result. I cant got any error massage, only hangs app. I use latest version 6.0.1.1

This file open on Microsoft office no problem.

edit retag flag offensive close merge delete

Comments

Is it possible for you to try to export that xlsx as csv with that other spreadsheet program and then try to import to Calc. How many rows and columns that 66 MB translates to?

Kruno gravatar imageKruno ( 2018-02-28 07:59:20 +0100 )edit

Try Apache OpenOffice. In my experience, AOO is more stable with big files as compared to LO.

gabix gravatar imagegabix ( 2018-02-28 08:30:10 +0100 )edit

Its big documents, over 20 000 row and 5 columns We use only libreoffice, cose it's may use in commerce.

Maxpain gravatar imageMaxpain ( 2018-02-28 08:43:39 +0100 )edit

Apache OpenOffice has a similar license.

gabix gravatar imagegabix ( 2018-02-28 09:07:34 +0100 )edit

OpenOffice we dont use. We have only libreoffice.

Maxpain gravatar imageMaxpain ( 2018-02-28 09:41:14 +0100 )edit

So you keep using LibreOffice, but you will need to convert that file somewhere somehow. You just declined every suggestion we made. Maybe in a future you cold keep that data outside of office suite in some database and do logic with some programming, maybe PHP?

Kruno gravatar imageKruno ( 2018-02-28 11:43:11 +0100 )edit

With 20000rows and 5 columns it's not a so big amount of data, maybe there is a pictures for every article in the file, or maybe there are direct format on the whole file out of data cells, or conditional formats.

m.a.riosv gravatar imagem.a.riosv ( 2018-02-28 11:46:30 +0100 )edit

yes, there are pictures about 70% position. Is it reason ? developers can not fix this problem?

Maxpain gravatar imageMaxpain ( 2018-02-28 12:05:22 +0100 )edit

I don't understand why Apache OpenOffice is not an option. Well, one more suggestion: try odf-converter-integrator to convert the file to ODS.

gabix gravatar imagegabix ( 2018-02-28 12:24:54 +0100 )edit

"odf-converter-integrator" cant convert it, or dont work :( I late over 1 hour, but I cant get any results. I try other online coverter, no one shold convert this file.

I would like to fix Libreoffice, because we use SAP system (1C, Russia) and this programm generate same prices.

Maxpain gravatar imageMaxpain ( 2018-02-28 13:21:33 +0100 )edit