How do i ????

Posted by: aja on 8 September 2017, 1:38 pm EST

  • Posted 8 September 2017, 1:38 pm EST

    hi ~


    123456 ===> $123,456  :  fpspread1....cell type = CurrencyCellType;


    $123,456 ===> 123,456  :  fpspread1....cell type = ???


     how do i ?


     exam) FormatString = ???

  • Replied 8 September 2017, 1:38 pm EST

    What is it you are trying to do, exactly?  Where is this data coming from?  Have you tried using a GeneralCellType?
  • Replied 8 September 2017, 1:38 pm EST

    um...


     i want only "," 


    not "$"

  • Replied 8 September 2017, 1:38 pm EST

    Set the CellType to Currency and turn off the currency symbol...

    Dim c As New FarPoint.Win.Spread.CellType.CurrencyCellType
    c.DecimalPlaces = 0
    c.Separator = ","
    c.ShowSeparator = True
    c.ShowCurrencySymbol = False
    FpSpread1.ActiveSheet.Cells(0, 1).CellType = c
    FpSpread1.ActiveSheet.Cells(0, 1).Value = 123456

  • Replied 8 September 2017, 1:38 pm EST

    Yes, Yes, Yes


     Thanks ~~~

Need extra support?

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

Learn More

Forum Channels