Hi,
I have an error when I generate an excel file from my datagrid column nr 2 contains ordernumbers like 2005-1-1,2005-1-2,…,2005-1-138, etc…
The problem is that when I export aspose thinks the first 31 are the day of a datetime format as you can see:
id |
order_nr |
order_date |
advance_fac_nr |
16 | 38368 | 04/01/2005 | EMIF/1/2005 |
17 | 38369 | 04/01/2005 | EMIF/2/2005 |
19 | 38371 | 04/01/2005 | EMIF/3/2005 |
20 | 38372 | 04/01/2005 | EMIF/4/2005 |
21 | 38373 | 04/01/2005 | EMIF/5/2005 |
22 | 38374 | 04/01/2005 | EMIF/6/2005 |
25 | 38377 | 04/01/2005 | EMIF/7/2005 |
26 | 38378 | 04/01/2005 | EMIF/8/2005 |
27 | 38379 | 04/01/2005 | EMIF/9/2005 |
28 | 38380 | 04/01/2005 | EMIF/10/2005 |
29 | 38381 | 04/01/2005 | EMIF/11/2005 |
30 | 38382 | 04/01/2005 | EMIF/12/2005 |
31 | 38383 | 04/01/2005 | EMIF/13/2005 |
32 | 2005-1-32 | 04/01/2005 | EMIF/14/2005 |
33 | 2005-1-33 | 04/01/2005 | EMIF/15/2005 |
34 | 2005-1-34 | 04/01/2005 | EMIF/16/2005 |
35 | 2005-1-35 | 04/01/2005 | EMIF/17/2005 |
36 | 2005-1-36 | 04/01/2005 | EMIF/18/2005 |
37 | 2005-1-37 | 04/01/2005 | EMIF/19/2005 |
38 | 2005-1-38 | 04/01/2005 | EMIF/20/2005 |
39 | 2005-1-39 | 04/01/2005 | EMIF/21/2005 |
40 | 2005-1-40 | 04/01/2005 | EMIF/22/2005 |
41 | 2005-1-41 | 04/01/2005 | EMIF/23/2005 |
What can I do so that the 2nd column values get printed as they should.
The problem only happens with the first 31.
Thx a lot,
Walter Van Hecke