[Libreoffice-bugs] [Bug 116274] Cannot open an excel workbook, "maximum number of columns per sheet" - in 64bit Calc on Windows for > 1024 columns (AMJ)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116274

sverre48 <sverre48 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |---
             Status|RESOLVED                    |REOPENED

--- Comment #57 from sverre48 <sverre48 at gmail.com> ---
This is certainly a unresolved problem that should be resolved by making
Libreoffice calc fully compatible with MS office w.r.t. handling valid .xlsx
formats. I've experienced it with a wide set of files - and every time I have
to roll back to som back up - by no means a satisfactory resolution to a
libreoffice calc problem. 

As this example reveals, I have a no of sheets and impossible to find where the
problem resides unless the product is able to the least tell the user where the
problem sheet resides and pinpoint e.g. too wide dimensions. This dimension
issue is something that seems to happen on the fly and is difficult to detect
and resolve. Is there a function to reduce  the size - by removing all blank
cells. I am not able to find that in MS excel 2010 and when I get open file
warnings in libreoffice calc, I cannot trust that information is lost - no
matter what you say. It is a libreoffice problem - nothing else - and
troublesome. Hence a way to resolve it could be issue a warning like
Dimensions of
named sheet contains too many columns

Do you want to reduce the size by removing blank columns outside data area. But
I still think Libreioffice calc should have the same limits as the industry
standard, .xlsx 

Thx again for pinpointing the problem sheet, Eike Rathke. You seem to be among
the ones who give helpful responses. Timurs comment is ridicoulus. What the
heck is the problem with using dropbox. Without dropbox, I would have lost a
lot of work due to this kind of libreoffice lack of compatibility issues with
MS office. A critical part of document sharing.

Cheers and pls find a solution - to resolve this. It has been known for a long
time and causes big strain for the user community.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190122/e5a3a0b6/attachment.html>