Bug 140541 - Apple Numbers spreadsheet mangled on loading
Summary: Apple Numbers spreadsheet mangled on loading
Status: NEW
Alias: None
Product: Document Liberation Project
Classification: Unclassified
Component: libetonyek (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Apple-iWork
  Show dependency treegraph
 
Reported: 2021-02-19 16:59 UTC by Garry Knight
Modified: 2024-04-27 02:36 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
The Numbers spreadsheet that doesn't load properly (3.26 MB, application/vnd.apple.numbers)
2021-02-20 12:20 UTC, Garry Knight
Details
The LibreOffice spreadsheet from which the Numbers file was originally converted (1.04 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-02-20 12:22 UTC, Garry Knight
Details
new result (16.42 MB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-09 15:02 UTC, osnola
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Garry Knight 2021-02-19 16:59:28 UTC
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.
Comment 1 Buovjaga 2021-02-20 07:02:33 UTC
Can you attach the original Numbers spreadsheet? Which Numbers version was used to create it?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 2 Garry Knight 2021-02-20 12:20:48 UTC
Created attachment 169915 [details]
The Numbers spreadsheet that doesn't load properly

This is the Numbers file that won't load properly.
Comment 3 Garry Knight 2021-02-20 12:22:42 UTC
Created attachment 169916 [details]
The LibreOffice spreadsheet from which the Numbers file was originally converted

This is the LibreOffice spreadsheet that was originally used to create the Numbers spreadsheet. I loaded the .XLSX file into Numbers and changed the formatting, then saved it as a Numbers file. And it is that Numbers file that won't load properly.
Comment 4 Garry Knight 2021-02-20 12:23:37 UTC
Numbers version 10.3.9 (7029.9.8) was used to create the file that won't load properly.
Comment 5 Roman Kuznetsov 2021-03-14 11:49:26 UTC
confirm all described problems in

Version: 7.2.0.0.alpha0+ / LibreOffice Community
Build ID: 3faaad6d16881dbbd70e34dcb0445a3373f8ddad
CPU threads: 4; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded
Comment 6 osnola 2021-09-09 15:02:58 UTC
Created attachment 174929 [details]
new result

I have fixed many problems in the current libetonyek repository. I get the following result. 

Note: to get the same results, you can either recompile a version of libetonyek with the current code, or wait for a release of libetonyek and its integration in LibreOffice.
Comment 7 Roman Kuznetsov 2021-09-11 17:22:01 UTC
(In reply to osnola from comment #6)
> Created attachment 174929 [details]
> new result
> 
> I have fixed many problems in the current libetonyek repository. I get the
> following result. 
> 
> Note: to get the same results, you can either recompile a version of
> libetonyek with the current code, or wait for a release of libetonyek and
> its integration in LibreOffice.

When will you plan to release a new version of libetonyek library?