[Libreoffice-bugs] [Bug 140541] New: Apple Numbers spreadsheet mangled on loading

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140541
           Summary: Apple Numbers spreadsheet mangled on loading
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: garryknight at gmail.com

Description:
I tried opening a Numbers spreadsheet in LibreOffice 7.1 for Mac and for
Windows and they both mangled the spreadsheet in the same way.

All of the font formatting was missing, the sheet names were missing from the
tabs, the second sheet (with 621 rows) was completely empty, the subsequent
ones were all truncated to 256 rows. Most of the sheets, of which there are
about 13, had 12 columns and all seemed intact apart from missing formatting.

The spreadsheet was originally created in LibreOffice for Windows and then
loaded into Numbers a couple of days ago, whereupon I changed all of the fonts
and reformatted some of the text. I also found that the cell background on all
cells that contained content had been set to a white background, so I went
through each sheet, changing all cell backgrounds to Default, then reformatting
just the column headers. I don't recall making any other changes. I then saved
the result as a standard Numbers (v10.3.9) spreadsheet, and this is the one
that gets mangled on loading into LibreOffice.

Thanks for any help or suggestions.

Steps to Reproduce:
1.Load Numbers file into LibreOffice.
2.
3.

Actual Results:
Spreadsheet loads with lots of mising contents, number of rows restricted to
256 or less, formatting lost, sheet names lost, one entire sheet empty.

Expected Results:
At least all of the content to be there, even if something needed to be
reformatted.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Loaded the entire contents of the spreadsheet, including text formatting and
sheet names.

-- 
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/20210219/94cf2b71/attachment.htm>