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.
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.
Created attachment 169915 [details] The Numbers spreadsheet that doesn't load properly This is the Numbers file that won't load properly.
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.
Numbers version 10.3.9 (7029.9.8) was used to create the file that won't load properly.
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
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.
(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?
There is a new release libetonyek-0.1.13 from September 2025. According to https://git.libreoffice.org/libetonyek/+/3ea9be577029596fc071dcc05d02ec57c32fa7ec%5E%21 the bug described here was fixed with release 0.1.11 already.
Indeed, it looks good at first sight with recent LO versions, let's close the bug report. Osnola, thanks for fixing!
The bug that Numbers files show only the first 256 rows is still there in LO 25.8.4.2 on Linux. Could somebody check if libetonyek-0.1.11 or newer was really integrated into LO?
0.1.12 was added in late 2024: https://git.libreoffice.org/core/commit/0a1025adeb3608b06df751225a97d84e5be87d48 author Xisco Fauli <xiscofauli@libreoffice.org> Mon Nov 04 23:02:22 2024 +0100 committer Xisco Fauli <xiscofauli@libreoffice.org> Tue Nov 26 14:42:25 2024 +0100 "libetonyek: upgrade to 0.1.12" 0.1.13 was added in September 2025 both to master and 25.8 branches. You can check these by searching for "libetonyek upgrade" (without quotes) on https://gerrit.libreoffice.org/ . While I'm checking on Windows, I can see rows over 256 in the attached sample both in a recent build from master branch, and in a 25.8 build from 10 Dec.
(In reply to Aron Budea from comment #11) > While I'm checking on Windows, I can see rows over 256 in the attached > sample both in a recent build from master branch, and in a 25.8 build from > 10 Dec. Indeed, the "iPhone_Table 1" sheet in attachment 169915 [details] shows 621 rows, so I don't understand UWK's comment 10 Arch Linux 64-bit Version: 25.8.4.2 (X86_64) / LibreOffice Community Build ID: 580(Build:2) CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 25.8.4-1 Calc: CL threaded
Created attachment 205172 [details] Empty rows from 257
I have attached a screenshot (attachment 205172 [details]) of the opened file (attachment 169915 [details]). The last visible row in the sheets "Table 1_3", "Table 1_4" and "Table 1_10" is row 256. Couldn't find any "iPhone_Table 1" like mentioned in comment 12 in the file.
(In reply to UWK from comment #14) > I have attached a screenshot (attachment 205172 [details]) of the opened > file (attachment 169915 [details]). The last visible row in the sheets > "Table 1_3", "Table 1_4" and "Table 1_10" is row 256. > > Couldn't find any "iPhone_Table 1" like mentioned in comment 12 in the file. I tested with version 7.2 as it was the last mentioned here that showed the issue. It opens up just like in your screenshot (wrong names, lost rows), so it seems you are running on a Linux system that doesn't have a new enough libetonyek. Closing again.
No repro on Version: 25.8.4.2 (AARCH64) Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df CPU threads: 8; OS: macOS 26.2; UI render: Skia/Metal; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded so this is fixed on macOS as well.
Thank you for explanation. I am running Ubuntu 24.04 with the PPA https://ppa.launchpadcontent.net/libreoffice/ppa/ubuntu/ (https://launchpad.net/~libreoffice/+archive/ubuntu/ppa) On my system is libetonyek 0.1.10-5build1 installed. So it seems, the latest version of the library is missing in the PPA. I will send a message to the LibreOffice Packaging team.