about cell borders...

Posted by: meidaolia on 8 September 2017, 2:01 pm EST

  • Posted 8 September 2017, 2:01 pm EST

    Hello,


    In Spread Designer,  line style in slanted dash dot, how to use code set a cell border with slanted dash dot line style?


    thx.

  • Replied 8 September 2017, 2:01 pm EST

    Hello,

    You may use the ComplexBorderSide Object to apply the desired Line Border Style.Below is the code snippet to get slanted dash dot border for a cell,

            Dim topborder As New FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.SlantedDashDot)
            Dim leftborder As New FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.SlantedDashDot)
            Dim rightborder As New FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.SlantedDashDot)
            Dim bottomborder As New FarPoint.Win.ComplexBorderSide(FarPoint.Win.ComplexBorderSideStyle.SlantedDashDot)
            Dim bord As New FarPoint.Win.ComplexBorder(leftborder, topborder, rightborder, bottomborder)
            FpSpread1.Sheets(0).Cells(1, 1).Border = bord

     I hope it will help you.

     Thanks,

     

  • Replied 8 September 2017, 2:01 pm EST

    It's useful,


    thanks a lot!

Need extra support?

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

Learn More

Forum Channels