PlanMaker 2018 Excel Date format

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
Nanouk
Posts: 1
Joined: Tue Feb 12, 2019 1:09 pm

PlanMaker 2018 Excel Date format

Post by Nanouk » Tue Feb 12, 2019 1:15 pm

I have discovered that PlanMaker resets date format to DDMMYYYY from my default MMDDYYYY only after the spreadsheet has been saved by an Excel 2013 and > program. As long as it has not been saved, PlanMaker continues to display my reset US date format of MMDDYYYY.

It would appear that PM 2018 is reading something in the saved *.xslx file after Excel has touched it and reverting to its default Euro Date format DDMMYYYY.

Any ideas or work arounds?
Thanks,
Paul Nanouk

sven-l
SoftMaker Team
SoftMaker Team
Posts: 8123
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: PlanMaker 2018 Excel Date format

Post by sven-l » Fri Feb 15, 2019 10:00 am

It seems that this problem has not been solved yet. I asked the developers for a solution.
Sven Leßmann
SoftMaker Software GmbH

markp
Posts: 2
Joined: Wed May 29, 2019 6:52 pm

Re: PlanMaker 2018 Excel Date format

Post by markp » Wed May 29, 2019 6:59 pm

I just ran into the same issue; PlanMaker has gone through my spreadsheet and converted all of my MM/DD/YYYY dates to DD/MM/YYYY

I've also noticed ... the cell/format has defaulted to language=German even though my overall default is US/English ... and if I try to update the cell with US/English + MM/DD/YYYY formats => PlanMaker then wipes out my cell border settings ... *ARG* !!!!!!

markp
Posts: 2
Joined: Wed May 29, 2019 6:52 pm

Re: PlanMaker 2018 Excel Date format

Post by markp » Wed May 29, 2019 11:57 pm

I just ran into his issue with a spreadsheet I had been maintaining with Excel.

While PlanMaker is configured with English/US as the default language, PlanMaker opted to use a German language setting to modify my date formats from MM/DD/YYYY to DD/MM/YYYY.

Even worse ... when I reconfigured the cells to use English/US + MM/DD/YYYY ... PlanMaker then trashed my border settings for the cells in question; it appears that I have to go through and verify the settings for all cell options (format, border, shading, etc) even though I'm only modifying one setting (format in this case). WTF?!?!?!

And to compound the issues ... when I try to go back and reset the borders (now trashed by PlanMaker) ... PlanMaker isn't capable of reading/applying the correct border setting (eg, I pick solid line + 2pt and it generates solid line + 1pt; if I pick double underline it generates a combination of double underline + solid line + 1pt). *fricken* *fracken* @#$)(*@#%@ !!!!

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 248
Joined: Wed Jun 05, 2019 12:02 pm

Re: PlanMaker 2018 Excel Date format

Post by miguel-c » Thu Jun 06, 2019 8:07 pm

Hi, I reported this issue to developers and will let you know when there's a solution.

Post Reply

Return to “PlanMaker 2018 for Windows”