so if you have a spreadsheet with a date thus
| 2011-01-03 |
Spreadsheetgear will convert it to
2011/01/03
2) Spreadsheetgear describes DD/MM/YYYY,MM/DD/YYYY and YYYY/MM/DD with "\/", but not
YYYY-MM-DD
therefore
excel format:DD/MM/YYYY sh/g format:dd\/mm\/yyyy - 01/01/2011
excel format:MM/DD/YYYY sh/g format:mm\/dd\/yyyy - 02/01/2011
excel format:YYYY-MM-DD sh/g format:yyyy/mm/dd - 2011/01/03
excel format:DD-MMM-YYYY sh/g format:dd/mmm/yyyy - 04/Jan/2011
excel format:YYYY/MM/DD sh/g format:yyyy\/mm\/dd - 2011/01/05
3) a date coming from a CSV with a value of 04-Jan-2011 will be converted to d-mmm-yy, 4-Jan-11
4) an excel file that has dates formatted as "Date" will be read by excel with the default culture. Therefore, if you open the file with your own custom culture - this will be the format of the "Date" cells.
Do you know how today Spreadsheetgear render dates?
ReplyDeleteWhen a format date in a cell it’s taken from the default system (*) signaled on excel formats, spreadsheetgear render date ok, but when y read from it (range.NumberFormat) to pass it to my abstraction layer it takes the format m/d/yyyy
It's that the default format on Spreadsheetgear when incapable of read format dates?