How do i ????

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

  • Posted 8 September 2017, 1:38 pm EST

    <P>hi ~</P>
    <P>123456 ===> $123,456  :  fpspread1....cell type = CurrencyCellType;</P>
    <P>$123,456 ===> 123,456  :  fpspread1....cell type = ???</P>
    <P> how do i ?</P>
    <P> exam) FormatString = ???</P>
  • 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?<br>
  • Replied 8 September 2017, 1:38 pm EST

    <P>um...</P>
    <P> i want only ","  </P>
    <P>not "$"</P>
  • Replied 8 September 2017, 1:38 pm EST

    <p>Set the CellType to Currency and turn off the currency symbol...</p><p>Dim c As New FarPoint.Win.Spread.CellType.CurrencyCellType<br>c.DecimalPlaces = 0<br>c.Separator = ","<br>c.ShowSeparator = True<br>c.ShowCurrencySymbol = False<br>FpSpread1.ActiveSheet.Cells(0, 1).CellType = c<br>FpSpread1.ActiveSheet.Cells(0, 1).Value = 123456 <br></p>
  • Replied 8 September 2017, 1:38 pm EST

    <P>Yes, Yes, Yes</P>
    <P> Thanks ~~~</P>
Need extra support?

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

Learn More

Forum Channels