Bug 154764

Created attachment 186592 [details]
Zip file containing screenshot of iCloud Numbers, LibreOffice with the same spreadsheet and a copy of the .numbers file downloaded from iCloud

hi,

This is my first time submitting a bug report for LibreOffice, so first of all my most sincere apologies if I have submitted this to the wrong component.

I am on a Windows 11 PC running Windows 11 Pro 22H2 fully patched.
I am using LibreOffice:

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL threaded

I am writing this bug report because I received some Apple Numbers spreadsheet documents today that I wanted to open.

I attempted to open these with LibreOffice and I got what appears to be the formatting but none of the file contents.

Opening the files using iCloud shows me the content of them.

I then used iCloud to create a brand new Apple Numbers spreadsheet document, put some formatting and test text into it.
I downloaded the file as a Apple Numbers file and opened it in LibreOffice.
The formatting appeared but none of the text.

Looking at the numbers file in a text editor, it appeared that my text was in the file that I downloaded, but to be sure I created a new guid and added it as the text to one of the cells.

I redownloaded the numbers file from iCloud and opened in LibreOffice.
The formatting was there but none of the text.

Opening the numbers file in a text editor showed that it did contain the guid that I had created.

The text of the guid being: a09cd0ab-73fa-4e15-8d57-149ca4ba5271

My expectation is that opening a Apple Numbers spreadsheet document would show me the text in the cells as well as the formatting. Currently only the formatting is shown.

I have attached my test files and screenshots for reference.

Kindest Regards

Peter