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