Add ZIP64 support for huge files about largexlsx HOT 4 CLOSED

Hello @easysummer
thanks for reporting this issue!
I'm having a look and be back to you as soon as possible.

from largexlsx.

Hello @easysummer
looks like enabling the ZIP64 format is not enough to support your use case.
The SharpCompress library, used by LargeXlsx, appears to produce a ZIP file that is not compatible with Excel when enabling ZIP64. Excel complains about a corrupted file but it is able to repair it (LibreOffice, on the other hand, appears to have no support for ZIP64 altogether).
I will try to understand what Excel considers wrong about the generated file (looks like https://rzymek.github.io/post/excel-zip64/ may be a good start) and try to patch SharpCompress.
Thanks,
Salvo

from largexlsx.

Hello @easysummer
I've just opened a pull request to SharpCompress that solves the issue (adamhathcock/sharpcompress#601), letting us to enable ZIP64.
Hope it is considered for merge, so that a next version of LargeXlsx can take advantage of it.
Thanks,
Salvo

from largexlsx.

Hello @easysummer
I have just released version 1.3.0 of LargeXlsx, which lets you enable the ZIP64 compression.
Please see the updated documentation about constructing an XlsxWriter.

I have tested ZIP64 both on small files with Excel and LibreOffice with no problems, and on a file larger than 4 GiB uncompressed, which works fine in Excel but it is reported as corrupt in LibreOffice. I don't know the reason for the latter and further testing could be helpful.

Look forward to your feedback!
Thanks,
Salvo

from largexlsx.