Joachim_L Posted February 1, 2021 Share Posted February 1, 2021 Maybe this is already fixed? I have to confess, that I am a few betas behind. When I datamerge fields formatted like 31.01.66 they will be displayed as 31/01/66 after the merge. I tested (file attached) with 3 different formattings, but only the version with the dots "failed". PS: The .xlsx was made in LibreCalc. dates.xlsx ------ Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 32 GB RAM | Latest Retail and Beta versions of complete Affinity range installed Link to comment Share on other sites More sharing options...
Staff Gabe Posted February 4, 2021 Staff Share Posted February 4, 2021 Hi @Joachim_L You're either using an old beta, or you've uploaded the wrong file (or maybe actually both). The XLSX looks like this (no dots) and it merges correctly . : Joachim_L 1 Link to comment Share on other sites More sharing options...
Joachim_L Posted February 4, 2021 Author Share Posted February 4, 2021 So this seems to be a LibreOffice issue. Sorry for wasting your time. EDIT: Saving as CSV worked. ------ Windows 10 | i5-8500 CPU | Intel UHD 630 Graphics | 32 GB RAM | Latest Retail and Beta versions of complete Affinity range installed Link to comment Share on other sites More sharing options...
Staff Gabe Posted February 4, 2021 Staff Share Posted February 4, 2021 Looks like it, yeah. No probs Link to comment Share on other sites More sharing options...
Recommended Posts