Excuse me, I have some problems using .xls files on LibreOffice Calc. I tried opening the file and it worked but when I tried to save my work, it crashed. Is there any way to make it work?
It worked on Microsoft Excel on Windows 11. The file crashed the computer, but it worked passed 5 minutes and I could save my work.
For real, what are you using this one for? If I take the compression ratio into account (times 10), subtract meta data (minus a third) and consider the character encoding (two bytes per character) I still get around 5000000000 characters. That’s all numbers? You wouldn’t store binary content in there, would you?
Anyway, take a decent pc with at least twice the memory the file will need uncompressed. Kill all other applications. Open up your file and split it up. Make a separate file for each worksheet. If there are more than 100000 rows, split them in separate files too. Don’t embed any binary content.
And for god’s sake: use a different tool. That very much depends on what you are trying to do. What is it?
It is just numbers, but my boss wants it in excel because he can’t work another file :(