[Libreoffice-bugs] [Bug 114555] New: Calc does not give warning when opening file containing a sheet with more than 1024 columns

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114555
           Summary: Calc does not give warning when opening file
                    containing a sheet with more than 1024 columns
           Product: LibreOffice
           Version: 5.4.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kevin.c.paxman at gmail.com

Description:
Calc cannot handle sheets with more than 1024 columns. Some files opened by
calc will contain sheets with more than this (for example spreadsheets created
with Excel can have up to ~16,000 columns).

The current behaviour is to silently truncate the sheets at the 1024 column
mark (AMJ). This can lead to the user being unaware that the spreadsheet is
incomplete. If the user saves the file, these columns will be permanently lost.

I propose that a clear warning is given when a user opens a file with over 1024
columns informing them that not all columns are being displayed and that saving
the file will lead to loss of data.

Steps to Reproduce:
1. Open a file saved by Excel with a sheet with more than 1024 columns
2. Save the file


Actual Results:  
The large sheet is truncated after column 1024 (AMJ).
No warning of this is given.
The saved file is smaller and no longer contains these columns.

Expected Results:
A warning informs the user that truncation has occured.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/60.0.3112.90 Safari/537.36

-- 
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/20171219/b6b142a2/attachment.html>