How keep the numeric cell format when i add other format ?

Posted by: robertobonilla2007 on 8 September 2017, 2:00 pm EST

  • Posted 8 September 2017, 2:00 pm EST

    <p>How can i keep the numeric cell format whe i add other format? </p><p>Ex:</p><p>I format the cell with currency format  $9000.00 but i need add  <b><font size="5">,</font></b> separate  but keep the currency format</p><p>THE QUESTION IS how can check if  the cell had format, for create the same format and add the separator and change the decimals</p><p>Because in the font i did something similar</p><p>    Dim si As New FarPoint.Win.Spread.StyleInfo<br>                Dim defFont As Font = FpSpread1.Sheets(0).Models.Style.GetCompositeInfo(0, 0, -1, si).Font <br></p><p> But in this case i don't know!</p><p> </p><p> </p>
  • Replied 8 September 2017, 2:00 pm EST

    <p>Roberto,</p><p>Are you applying a cell type (e.g. number cell type) to a cell and then wants to determine the cell type of that specific cell type. If this is the case, you may use the GetType to get the desired information as follows:</p><blockquote><p>        Dim t As New FarPoint.Win.Spread.CellType.NumberCellType<br>        FpSpread1.ActiveSheet.Cells(0, 0).CellType = t<br>        Dim t1 As FarPoint.Win.Spread.CellType.ICellType<br>        t1 = FpSpread1.ActiveSheet.GetCellType(0, 0)<br>        MsgBox(Convert.ToString(t1))<br></p></blockquote><p>Thanks<br></p>
Need extra support?

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

Learn More

Forum Channels