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: 325
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.

tothcsaba
Posts: 3
Joined: Tue Oct 01, 2019 10:54 am

Re: PlanMaker 2018 Excel Date format

Post by tothcsaba » Tue Oct 01, 2019 10:59 am

Hello,

The default format of date for hungarian is DD.MM.YYYY and can't possible to change.

When will be fix this BUG.

Thank You!
Attachments
Screenshot_22.png

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

Re: PlanMaker 2018 Excel Date format

Post by miguel-c » Tue Oct 01, 2019 4:24 pm

Hi, PlanMaker takes the date format from Windows. You can change Windows's date format on your Windows Control Panel, under Region.

tothcsaba
Posts: 3
Joined: Tue Oct 01, 2019 10:54 am

Re: PlanMaker 2018 Excel Date format

Post by tothcsaba » Mon Oct 07, 2019 4:31 pm

OK!
I did it, but nothing changes!

Thank You!
Attachments
Screenshot_29.png

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

Re: PlanMaker 2018 Excel Date format

Post by miguel-c » Tue Oct 08, 2019 12:51 pm

Please click on custom (Egyéni) and change NN.HH.ÉÉÉÉ;@ to ÉÉÉÉ. HH. NN.;@
Capture.PNG

tothcsaba
Posts: 3
Joined: Tue Oct 01, 2019 10:54 am

Re: PlanMaker 2018 Excel Date format

Post by tothcsaba » Tue Oct 08, 2019 1:04 pm

I know, this is the solution for the problem, but you said some posts before "PlanMaker takes the date format from Windows". So, maybe something wrong with the PlanMaker code.
It's just a remark for the future builds, maybe take eyes on it.

Thank You!

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

Re: PlanMaker 2018 Excel Date format

Post by miguel-c » Wed Oct 09, 2019 5:48 pm

I've just reported this issue to the developers. Thank you for your feedback!

Post Reply

Return to “PlanMaker 2018 for Windows”