v13 issue with text entry

Posted by: craigreilly on 9 May 2022, 4:55 am EST

  • 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?
  • Marked as Answer

    Replied 9 May 2022, 5:44 am EST

    Well...
    1) I see somehow I ended up in the C1 forum instead of Spread forum.
    My apoligies.

    2) Using .value instead of .text fixed the issue.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels