Posted 9 May 2022, 4:55 am EST
This puts text in the cell
Dim textCell As New FarPoint.Win.Spread.CellType.TextCellType With {
.Multiline = False,
.WordWrap = False
}
FpSpread1.Sheets(cid).Cells(0, 0).Text = CStr(oreader2("sku").ToString)
FpSpread1.Sheets(cid).Cells(0, 0).CellType = textCell
the value of oreader2(“sku”) is “1121-1” but FPSpread shows this as “1/1/21 12:00:00 AM”
the value of oreader2(“sku”) is “7233-1” but FPSpread shows this as “1947841”
I am on v13.45.20203.0
I can not figure out why the text is being converted.
If I do this, It works, but has an extra characte, the “-”.
FpSpread1.Sheets(cid).Cells(0, 0).Text = "-" & CStr(oreader2("sku").ToString)
Any ideas?