Murfee Posted October 13, 2020 Share Posted October 13, 2020 Data merge was a very short lived testĀ š« Mojave with the latest Numbers 10.1, file exported as .xlsxĀ and crashes Publisher as soon as it is selected in the Data Merge Manager Link to comment Share on other sites More sharing options...
Staff Jon P Posted October 13, 2020 Staff Share Posted October 13, 2020 @MurfeeĀ Can you attach the xlsx file? Thanks Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
Seneca Posted October 13, 2020 Share Posted October 13, 2020 19 minutes ago, Murfee said: Data merge was a very short lived test I have just tested it and it works for me. I had to reset Publisher to make it actually start on my computer. Regards Murfee 1 2017 27ā iMac 4.2 GHz Quad-Core Intel Core i7 ā¢ Radeon Pr 580 8GB ā¢ 64GB ā¢ Ventura 13.6.4. iPad Pro (10.5-inch) ā¢ 256GB ā¢ Version 16.4 Link to comment Share on other sites More sharing options...
Murfee Posted October 13, 2020 Author Share Posted October 13, 2020 21 minutes ago, Jon P said: @MurfeeĀ Can you attach the xlsx file? Thanks Hi John, I can't upload the original xslx that I tried...too confidentialĀ š I have attached a very simple one, this doesn't crash Publisher but the first column with the Months doesn't pull through, it just shows 0000. The original file I tried was full of formulas that might have got confused during the export to Excel... not the best file to test withĀ š Simple Testing 2 Data Merge for Publisher 1.9.xlsx Ā Link to comment Share on other sites More sharing options...
Staff Jon P Posted October 13, 2020 Staff Share Posted October 13, 2020 I'll look into that month missing, but I'm keen to reproduce this crash (even if it has formulas or things we don't support, we should never just crash!) If you use this link to upload the file it will remain confidential and only used internally for testing. Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
Murfee Posted October 13, 2020 Author Share Posted October 13, 2020 3 minutes ago, Jon P said: I'll look into that month missing, but I'm keen to reproduce this crash (even if it has formulas or things we don't support, we should never just crash!) If you use this link to upload the file it will remain confidential and only used internally for testing. Uploaded, thanks Link to comment Share on other sites More sharing options...
Murfee Posted October 13, 2020 Author Share Posted October 13, 2020 Is there a reason that the Mac version can not import Numbers or Pages documents?Ā Link to comment Share on other sites More sharing options...
fde101 Posted October 13, 2020 Share Posted October 13, 2020 1 hour ago, Murfee said: Is there a reason that the Mac version can not import Numbers or Pages documents?Ā Yes, those areĀ proprietary file formats which are not publicly documented and change from release to release so they would be a moving target of reverse-engineering that is not likely worth Serif's time to unravel. Murfee 1 Link to comment Share on other sites More sharing options...
Murfee Posted October 13, 2020 Author Share Posted October 13, 2020 Thanks @fde101, I was just hoping life would be easier if I have formulas that don't export to Excel properly Link to comment Share on other sites More sharing options...
Staff Jon P Posted October 14, 2020 Staff Share Posted October 14, 2020 Thanks for the file, I've logged that crash, seems to be caused by the EDATE formula. If I remove those it's fine Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
Staff Jon P Posted October 14, 2020 Staff Share Posted October 14, 2020 Quote Ā have attached a very simple one, this doesn't crash Publisher but the first column with the Months doesn't pull through, it just shows 0000. It's because we don't understand the date formatting used, you get similar behavior if you place it - I'll pass this on Murfee 1 Serif Europe Ltd. - www.serif.com Link to comment Share on other sites More sharing options...
Murfee Posted October 14, 2020 Author Share Posted October 14, 2020 6 hours ago, Jon P said: Thanks for the file, I've logged that crash, seems to be caused by the EDATE formula. If I remove those it's fine Thanks Jon, I have been using CSV exported from Numbers and it is working well, I just need to remember to replace the original file when I update anything and all is good. The translation to Excel can be difficult sometimes due to the difference in functions, it should just replace a formula with values but it doesn't always. Old Bruce 1 Link to comment Share on other sites More sharing options...
Recommended Posts