GatoL0c0
-
Posts
4 -
Joined
-
Last visited
-
Date from Data Merge varies CSV vs XLS
GatoL0c0 replied to GatoL0c0's topic in V2 Bugs found on Windows
Discovered another issue with the XLSX. It does not display the time correctly unless I use a CSV.
-
Date from Data Merge varies CSV vs XLS
GatoL0c0 replied to GatoL0c0's topic in V2 Bugs found on Windows
Unfortunately deleting and relinking the sample or the original XLSX did not help. I also tried refreshing but still only the CSV file will show the correct date. -
Date from Data Merge varies CSV vs XLS
GatoL0c0 replied to GatoL0c0's topic in V2 Bugs found on Windows
Here are the sample files. I have redacted some information due to privacy reasons. Sample Excel_ 2023-24.csv Sample Excel_ 2023-24.xlsx Sample.afpub -
I've have this weird bug when doing a data merge in V2.2. If I try importing data from an XLS with a date, instead of displaying for example, 10/13/2023, it displays one day behind 10/12/2023. When I import the same file saved as a CSV, the data imports fine. I'm on PC Windows 10 22H2 with the full Affinity Suite 2.2. I have experienced this bug in all prior versions of Affinity. I'll continue to used CSV instead of XLS but it's strange that the data won't merge correctly unless I use a CSV.
