V13 issue with text entry

V13 issue with text entry

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

• 

  craigreilly

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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?

• 

  craigreilly

  • Post Options:
  • Link
    Copy

  Posted 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.