spread Relations

Posted by: redahashem-fp on 8 September 2017, 2:05 pm EST

  • Posted 8 September 2017, 2:05 pm EST

    i uses spread Relations to show invoice head and invoice details no problim to show them but  but here in egypt we use arabic appliction interfaces so i want to change      ColumnHeaders .text for Parents   and change ColumnHeaders .text for  Child


    how can i do that by code


     


    Big SmileWilted Flower


     

  • Replied 8 September 2017, 2:05 pm EST

    Hello,

    For the Arabic language, you can turn the RightToLeft property of Spread to True. This can be done as follows:

    Dim appr As New FarPoint.Win.Spread.Appearance()
    appr.RightToLeft = True
    appr.VisualStyles = FarPoint.Win.VisualStyles.On
    Dim si As New FarPoint.Win.Spread.StyleInfo
    si.SetAppearance(appr)
    FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)

    And to change the column header in child sheet, you can use the ChildViewCreated event:

    e.SheetView.ColumnHeader.Cells(0, 0).Text = "I am Column1"

    and for the Parent sheet,you can use the form load event:

    FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "I am Column1"

    Thanks

  • Replied 8 September 2017, 2:05 pm EST

    SureshD:

    Hello,


    For the Arabic language, you can turn the RightToLeft property of Spread to True. This can be done as follows:



    Dim appr As New FarPoint.Win.Spread.Appearance()
    appr.RightToLeft = True
    appr.VisualStyles = FarPoint.Win.VisualStyles.On
    Dim si As New FarPoint.Win.Spread.StyleInfo
    si.SetAppearance(appr)
    FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si)


    And to change the column header in child sheet, you can use the ChildViewCreated event:



    e.SheetView.ColumnHeader.Cells(0, 0).Text = "I am Column1"


    and for the Parent sheet,you can use the form load event:



    FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "I am Column1"


    Thanks



    thank you so much it works good

Need extra support?

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

Learn More

Forum Channels