I wanted to get some display string of a given date (with custom style)
I am able to observe that if I put 31/12/2017
and set the style to custom (dd-mm-yy) in Excel
The result in code:
The display string value is 01-Jan-2017
and the style (CultureCustom) is dd-MMM-yy
I would like to ask if this result intended?
below is the code i used:
Workbook wb = new Workbook(“test date format.xlsx”);
Worksheet ws = wb.Worksheets;
Style style = ws.Cells[0, 0].GetStyle();
//CultureCustom “dd-MMM-yyyy” string
//ws.Cells[0, 0].DisplayStringValue “01-Jan-2017” string
Please find the file I have used.