Prepare a blank excel file and load it into spreadsheet
case 1:
1. set cell A1 edit text as 2013/12/24
2. format the cell with format string m/d/yyyy
3. expect result should display 24/12/2013 but was 2013/12/24
case 2:
1. download the attachment excel file which have 1 cell with value 2013/12/24 and format is yyyy/m/d
2. open them by spreadsheet
3. 2007 display correctly, but 2003 doesn't. It should be 2013/12/24 but was 12/24/2013
The testing locale is zh_tw
- is duplicated by
-
ZSS-276 data format is changed when reading and displaying a excel 2003 file
- Closed