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

    How can i keep the numeric cell format whe i add other format?

    Ex:

    I format the cell with currency format  $9000.00 but i need add  , separate  but keep the currency format

    THE QUESTION IS how can check if  the cell had format, for create the same format and add the separator and change the decimals

    Because in the font i did something similar

        Dim si As New FarPoint.Win.Spread.StyleInfo
                    Dim defFont As Font = FpSpread1.Sheets(0).Models.Style.GetCompositeInfo(0, 0, -1, si).Font

     But in this case i don't know!

     

     

  • Replied 8 September 2017, 2:00 pm EST

    Roberto,

    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:

            Dim t As New FarPoint.Win.Spread.CellType.NumberCellType
            FpSpread1.ActiveSheet.Cells(0, 0).CellType = t
            Dim t1 As FarPoint.Win.Spread.CellType.ICellType
            t1 = FpSpread1.ActiveSheet.GetCellType(0, 0)
            MsgBox(Convert.ToString(t1))

    Thanks

Need extra support?

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

Learn More

Forum Channels