Garden-User Posted December 9, 2020 Posted December 9, 2020 Hello Guys, Since I´m using the Publisher Beta and the Data Merge Feature I found a little bug while playing with the Merge. This Bug is visible when you try to Link an Excel Sheed in Publisher and one or more Cells are Formatted as "Currency". The Number will not be Linked and the Field is blank. I assume that maybe Publisher has a Problem reading the Currency Symbol from Excel, because if I try to manually add the Currency Symbol, in my Case, € (EUR) it also don´t work. I had to use the ASCII Code: Alt + 0128 -> € to get the Symbol to appear. I hope this place is right for this Type of Bug. Best regards.
Staff Pauls Posted December 11, 2020 Staff Posted December 11, 2020 Hi, Could you provide a small sample file please and also confirm the Version of Excel and the locale that your machines uses Regards
AlainP Posted January 4, 2021 Posted January 4, 2021 My first suggestion.... don't post documents with real email addresses and real phone numbers ! Ask for a private link to upload your file or images. You should edit your post and delete those images. emmrecs01 1 -- Window 11 - 32 gb - Intel I7 - 8700 - NVIDIA GeForce GTX 1060 -- iPad Pro 2020 - 12,9 - 256 gb - Apple Pencil 2 -- iPad 9th gen 256 gb - Apple Pencil 1 -- Macbook Air 15" - Mac mini M2-Pro - 16 gb
Panchdara Posted January 5, 2021 Posted January 5, 2021 17 hours ago, AlainP said: My first suggestion.... don't post documents with real email addresses and real phone numbers ! Ask for a private link to upload your file or images. You should edit your post and delete those images. Agree... perhaps these are bogus identifiers, but should be obvious. I've "unseen" this now. Best
Garden-User Posted January 15, 2021 Author Posted January 15, 2021 Hello People, Sorry for the late reply. We had holidays. I have created a little Test File. Since I don´t need any real data I have simply used a table in Publisher and linked it to Excel with 3 "Datafields". The First Product "Produkt 1" has the Number formatted as "Currency". <-- Not Showing The Second Product "Produkt 2 has the Number formatted as "Default" <-- Shows the Number The Third Product "Produkt 3" has the Number formatted as Default but with a Formula in Excel itsel called "text()" that converts the Number to "0,00 €". <-- Shows the Number with the Currency Symbol. I have attached the files so maybe this will help sort out the error. We use Excel 2016 and the local is set to German / Germany. Affinity Excel.zip
Joachim_L Posted January 15, 2021 Posted January 15, 2021 @Garden-User Have you checked with the new beta 1.9.0.887? ------ Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 32 GB RAM | Latest Retail and Beta versions of complete Affinity range installed
Garden-User Posted January 15, 2021 Author Posted January 15, 2021 Just now, Joachim_L said: @Garden-User Have you checked with the new beta 1.9.0.887? Currently downloading and I will Check it. Thank you for pointing this out.
Garden-User Posted January 18, 2021 Author Posted January 18, 2021 On 1/15/2021 at 3:24 PM, Joachim_L said: @Garden-User Have you checked with the new beta 1.9.0.887? Hello, I have checked it with the 1.9.0.887 Version and the Problem is still there.
Recommended Posts