I created an .xsls document using the Linux (fedora40) version of libreoffice calc 24.2.4.2
When I try to open on windows10 - 64 bits, same version of calc, the opening of the file stalls and never succeeds. There is no problem re-opening on Linux.
My obvious question is: “What do I need to change in order to use my Sheet with both Linux and Windows”?
Can you upload a sample file here?
If you create a simple spreadsheet, e.g. contains just 1+2=3, using Fedora in the same directory, can you open it from Windows? If you can, then it probably isn’t an anti virus or security setting.
In Windows, if you toggle OpenCL in Tools - Options - LibreOffice - OpenCL, can you open the spreadsheet?
The immediate problem is the data in Exemplare's U23:XFC23: deleting the columns would make it work on Windows, too. But it is indeed a bug, that on Windows, it iterates the columns for so long, compared to Linux (it will open on Windows eventually - but it takes minutes and gigabytes.)
Thanks for the answer! I overlooked that there were garbage data and have no idea how they have been created.
Is it possible to restrict the number of columns (and rows), that are usable in a sheet?
No, we don’t have such options. And we shouldn’t introduce options just to workaround bugs - what is needed here is to fix the bug on Windows.
Of course, you may hide columns … but that wouldn’t make them unavailable. You also can protect the sheet (and unprotect an area). But that would likely be too inconvenient.