Excel date format is not displayed correctly

Doconut Product Family
1

Hi,
When we look at an XLSX certain file that contains dates which are dd/MM/yyyy are
displayed as MM/dd/yyyy
Why is that and how can i influence this behavior.

image.png (14.9 KB)

2

@tomerh,

To better assist you and investigate the issue, could you please attach a sample file where this problem is occurring? This discrepancy may be attributed to regional settings or formatting preferences within the software you are using.

Thanks for your help.

3

out.zip (16.4 KB)

4

@tomerh,

The wrong date format is forced by the CultureInfo of the machine where the viewer is running.
You can change the culture using the config property “DocumentCulture”.

This is the result by using a culture that has “dd/MM/yyyy”.

1063×699 95.2 KB

5

@tomerh,

We are happy to inform you that we have released a new version of Doconut where a new property called CustomStyles has been implemented in the ExcelConfig where you can add custom styles to cells.

This is an example:

var config = new ExcelConfig
{
    CustomStyles = new ExcelConfig.CustomStyleCell
    {
        CustomStyleDateTime = "YOUR-VALUE" // e.g.: dd-MM-yyyy
    },
    DocumentCulture = "YOUR-VALUE", // e.g.: en-US
};

You can now download the latest version from our website and update your installation. Please note that there have been changes in Doconut, along with how you implement the viewer in your code, so we invite you to review the documentation on our website to see the changes.

https://doconut.com/documentation/

We appreciate your patience. Feel free to ask if you have more questions or encounter any problems.