sstlaurent

I did the same test again this morning (see image). This time, added a new column because your test Anto was done with a slash (/) instead of hyphen (-) like we use in French - the problem I reported is still there: YYYY-MM-DD is not recognize, gives a value minus 1 DD-MM-YYYY is ok YYYY/MM/DD is ok

I tried to recreate the problem but it seems to be ok now. Can't figure out what happened. Thank you for all advices.

thank you all. Replies to your comments: I've tried numerous imports with variations:: AFPUB with no accents, with different name save the data file xlsx with a different name Inverse column B with A (the problem is not the column but the date) put a different year-date Write real values in all column formated as 2023-01-01, OR put formulas like B=A+1, C=B+1, etc.) in all cases, I get minus 1 for the date written in YYYY-MM-DD in every column. I GET GOOD RESULTS if I use the format which is not our standard in French: DD-MM-YYYY. if I import the datas in CSV, the A value is EXACT in AFPUB but I don't find CSV option as interesting.

Using a XLSX file with 3 columns of dates. Same date each line but format is different like this: date courte date longue jour 2023-01-02 2 janvier 2023 lundi When using data merge in Publisher, the first column with value 2023-01-02 changes the value to the date minus one day 2023-01-01. The other columns are ok. I've tried a few scenarios, always this error. What is happening? Using Publisher 2.0.3 in French, Windows 10 in french. calendrier 2.xlsx bogue de fusion.pdf test données 3 - XLSX et CSV.afpub

Publisher 2.0.3 en français (sur Windows 10) - Dans la fenêtre «Table des matières», le fait de choisir le séparateur «Cadratin» fait planter (fermer) le logiciel à tout coup.

I had the same problem: any pdf file made from a scan with my HP Office Jet Pro 8600 was impossible to open in Windows APublisher 1.8.3. This bugged me a lot. Recently, Adobe didn't allow the activation of my old licence of Acrobat Pro on a new computer. I decided to switch an use APublisher for all my pdf needs. I found out that after saving my initial scan with a pdf extension, I can open it with the FREE Acrobat Reader and proceed to the Save As… operation in order to open it in APublisher for editing. This procedure suits my needs. A wishful thinking: if a pdf file already managed in APublisher could simply be «saved» instead of always having to export it whenever I modify it.