Bug 140541

Summary:	Apple Numbers spreadsheet mangled on loading
Product:	Document Liberation Project	Reporter:	Garry Knight <garryknight>
Component:	libetonyek	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	79045_79045, alonso, aron.budea, ilmari.lauhakangas
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=150495
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	124107
Attachments:	The Numbers spreadsheet that doesn't load properly The LibreOffice spreadsheet from which the Numbers file was originally converted new result

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?