Posted 3 July 2018, 8:12 pm EST
Hi,
In Spread V11, when we are trying to set dates for a cell which has culture specific cell format is not working in especially spanish culture.
Steps to reproduce:
- Please find the attachment and extract them
- Each file is set to a specific culture (German, French and Spanish)
- Run each of them and check the console for the output. Note that in spanish (es), the output is different and not culture specific.
What I am doing in each of these files is same code, which is as below:
c = sheet.getCell(0,0);
c.formatter(“dd/MM/yyyy”);
c.value(“12/1/2018”); //setting date in en-us date format 1st December 2018
console.log(c.text());
// in spanish alone we will see 12/1/2018, which mean 12th jan 2018
Thanks,
Viswanath