In Hungary we refer to dates in "YYYY. mm. dd." format, but Planmaker has only "dd. mm. YYYY." style. The closest format is "YYYY-mm-dd" but I'd prefer "YYYY. mm. dd." style date when formatting a cell. Is it possible to add somehow such a custom cell format?

Yes, I know that but my problem is this: I have a spreadsheet that has cells formatted as "YYYY. mm. dd" date format. If I import this file into PlanMaker date fields are displayed in dd.mm.YYYY style. Not exactly what I wanted.

I tried to reformat date fields as YYYY-mm-dd and then import the spreadsheet into PlanMaker. This time PlanMaker displayed cell correctly in YYYY-mm-dd format.

I'd like to avoid reformatting date fields or incorrect order of date representation that's why I'd need YYYY. mm. dd as a date format not a custom format.

I'd like to avoid reformatting date fields or incorrect order of date representation that's why I'd need YYYY. mm. dd as a date format not a custom format.

I don't follow You here. Custom format does not differ from built-in-format or do You get any wrong output when using the custom format?

I try to explan it in another way. I've got an existing xls sheet where cells are formatted as date in "YYYY.mm.dd" format. I open the excel sheet using PlanMaker and the same cells are represented as date in "dd.mm.YYYY" format. (Note the order of the day, month, year is reversed!) I feel this is some kind of an incorrect way of using existing excel sheets.

If I want to have the cells displayed in PlanMaker in the correct order, that is as YYYY.mm.dd, I need to reformat the cells as custom type after opening it. I'd like to avoid it.

Last edited by Levente on Sun Nov 08, 2015 1:38 pm, edited 1 time in total.

XL-Dennis wrote:Thanks for clarifying it. What I suggest is to use a macro script to manage the date issue.

Thanks for the script. I know this date handling issue is not a big deal and could be solved with some workaround, but I thought it wouldn't be a big deal to modify the code of PlanMaker to make the workaround unneccessary.

We share a drive and the excel spreadsheet is and always has been correct. Now, I am using freeoffice and whenever I open this HUGE file with over1500 entries on 52 work sheets, it screws up the entire workbook. We cant be using a script everytime we want to edit it and save it.

Is this going to be fixed?

By the way, I changed the regional settings and PlanMaker STILL DOES IT!

We share a drive and the excel spreadsheet is and always has been correct. Now, I am using freeoffice and whenever I open this HUGE file with over1500 entries on 52 work sheets, it screws up the entire workbook. We cant be using a script everytime we want to edit it and save it.

Is this going to be fixed?

By the way, I changed the regional settings and PlanMaker STILL DOES IT!

Please provide a sample document that exhibits the observed behavior. I can then push this issue with the developers.