Problem with date

[GoogleCodeExporter]

Hi all,
first of all thank you for your good library, I've been using for only a 
few days the dll compiled on 2009-02-12 in a VB.net project running on 
winXP. I'm not a good programmer so maybe it's my fault and I'm missing 
some steps, but I experience a problem with date. My code get a date value 
from a DataView and put it in a cell, but when I open the xls file I find 
1 day added, i.e. february 25 instead of february 24, note that if I stop 
the code during debugging and read the cell value it is the right one.
No problems with other cells containing decimal or string values.
This is an extract of the code:
........
Dim MyDataView As DataView = New DataView MyDataset.Tables(MyTable))
dim MyWorksheet As Worksheet
....the dataview is rowfiltered.........
Dim MyDate As Date = MyDataView.Item(0).Item("date")
MyWorksheet.Cells(Riga, 0) = New Cell(MyDate, "DD\-MM\-YY")
...........

Another question: is it possible to change font color, backcolor, border 
or alignement in a cell?

Many thanks.

     Stefano

Original issue reported on code.google.com by stefraan...@gmail.com on 24 Feb 2009 at 12:43

[GoogleCodeExporter]

This bug is fixed by r37. Thanks.
Font color, backcolor, border or alignement in a cell are not supported.

Original comment by China.LiuJunFeng on 25 Feb 2009 at 3:56

• Changed state: Fixed

[GoogleCodeExporter]

Do you think font color, backcolor, border or alignement in a cell will be 
supported 
in the future? 
Thanks

Original comment by stefraan...@gmail.com on 25 Feb 2009 at 9:50