Jump to content
ConnectCreative

Placing Excel doc crashes Publisher

Recommended Posts

Very interesting. I created a stripped down version with just 2 cells, and it still crashes. Did you use any app to generate this? Or is all created from scratch in Excel? 

Share this post


Link to post
Share on other sites
1 minute ago, Gabe said:

Very interesting. I created a stripped down version with just 2 cells, and it still crashes. Did you use any app to generate this? Or is all created from scratch in Excel? 

Sorry I can't be certain as a client supplied. I can ask them tho and hopefully they'll fill me in. First time i've had a need to import Excel so never seen the issue before.

I also tried copy/paste in Excel into a new doc, resaved and tried again. Still crashed so there's definitely something in there that Publisher disagrees with!

Share this post


Link to post
Share on other sites

I opened it in LibreOffice and saved as xlsx after changing the fonts to Courier. No problem importing that file with the exception that all the numbers from Page and Price disappeared. I should say all the data ie the pound sign was gone too.

Edit: A closer look shows all the cells formatted/containing only numbers were cleared out. Page, Code (if it is numbers only) and List Price


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.6

Affinity Designer 1.8.4 | Affinity Photo 1.8.4 | Affinity Publisher 1.8.4 | Affinity Designer Beta 1.9.0.2 | Affinity Photo Beta 1.9.0.199 | Affinity Publisher Beta 1.9.0.742

Share this post


Link to post
Share on other sites

I tried it as well and is crashed immediately..  If you save it as an Open Office XML Spreadsheet (.xlsx) (saved via LibreOffice) it doesn't crash AP.  Page is empty and List Price is empty.  It is clearly an AP issue...

I was going to try the xlsx document saved as an ods document but for some inexplicable reason AP does not recognize od(x) documents...

Just like we did with Adobe, we also dumped Microsoft Office and moved to LibreOffice.

I hope the Affinity roadmap includes placing od(x) documents...


iMac (Retina 5K, 27-inch, 2017) Mac OS 10.15.5 | 4.2 GHz Quad Core Intel-Core i7 | 48 GB 2400 MHz DDR4 Ram | Radeon Pro 580 8 GB

Affinity Designer 1.8.4 | Affinity Photo 1.8.4 | Affinity Publisher 1.8.4 | Capture One 20 Pro | Fast Raw Viewer | NeoFinder

Share this post


Link to post
Share on other sites
13 hours ago, KC Honie said:

I tried it as well and is crashed immediately..  If you save it as an Open Office XML Spreadsheet (.xlsx) (saved via LibreOffice) it doesn't crash AP.  Page is empty and List Price is empty.  It is clearly an AP issue...

I was going to try the xlsx document saved as an ods document but for some inexplicable reason AP does not recognize od(x) documents...

Just like we did with Adobe, we also dumped Microsoft Office and moved to LibreOffice.

I hope the Affinity roadmap includes placing od(x) documents...

Thank you for trying the file, this is useful feeback.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

Please note the Annual Company Closure section in the Terms of Use. These are the Terms of Use you will be asked to agree to if you join the forum. | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.