Free Support Forum - aspose.com

String VS Datetime error

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

Hi Walter,

It’s fixed in v2.7.4. Please download it at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip.