Description: I have a .numbers file which appears to open in LibreOffice Calc but only shows a single row of data. I have spent some time debugging this and if I am correct it relates to a writerperfect library that's doing the heavy lifting. If I try to convert the file using numbers2ods on Ubuntu, every email address generates broken XML - I have opened a bug with Ubuntu here: https://bugs.launchpad.net/ubuntu/+source/writerperfect/+bug/1930270 Steps to Reproduce: 1. Create a spreadsheet in iWorks containing email addresses (with hyperlinks) 2. Open that spreadsheet in LibreOffice Calc Actual Results: Import stops at first cell containing email address. No indication of an error is provided. Expected Results: That the file would import in full Reproducible: Always User Profile Reset: No Additional Info: Tested on Windows and Ubuntu
To pre-empt the obvious question: I cannot upload the .numbers file I have as it contains confidential client data. I do not have access to an Apple system to create a file of my own.
(In reply to Mark Rogers from comment #1) > To pre-empt the obvious question: I cannot upload the .numbers file I have > as it contains confidential client data. I do not have access to an Apple > system to create a file of my own. So, how we can help you if we don't have a file with problem data? Status => NEEDINFO while we'll get an example for repro
I described what I believe to be the steps to reproduce in the original report. Workout access to any Apple products this isn't something I can create a sample file myself, though. If anyone has access to iWorks and wants to contact me I'll happily work with them to reproduce this and create a test file (although I think any file containing email addresses will demonstrate it).
Created attachment 173824 [details] Example file
LO opens fine my example Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 9c15dea0b2192d231b65175291a7655122c2e24c 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 We still need your example possibly, or you can just test my example in current dev version https://dev-builds.libreoffice.org/daily/master/MacOSX-x86_64@tb81-TDF/2021-07-24_05.46.17/LibreOfficeDev_7.3.0.0.alpha0_MacOS_x86-64.dmg
I can confirm that the sample you provide does NOT open correctly in 7.1.3.2 on Windows - it shows the first email address but nothing past that point (no errors given). (Thank you for creating a sample that can be publicly shared.) I'll update to 7.1.5 (and if necessary the latest 7.2 RC) and report back.
I can further confirm that 7.1.5.2 does NOT open the sample file correctly. However 7.2.0.1 DOES open the file, correctly showing all 5 email addresses (Tested on Windows 10 64-bit)
(In reply to Mark Rogers from comment #7) > I can further confirm that 7.1.5.2 does NOT open the sample file correctly. > > However 7.2.0.1 DOES open the file, correctly showing all 5 email addresses > > (Tested on Windows 10 64-bit) Excellent! Thank you for retesting. so, let's close this one as WFM