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 <FONT size=3>Parents   and change </FONT><FONT size=2>ColumnHeaders .text for  <FONT size=3>Child</FONT></FONT>


    <FONT size=3>how can i do that by code</FONT>


    <FONT size=3></FONT> 


    <img src="/emoticons/emotion-2.gif" alt="Big Smile" /><img src="/emoticons/emotion-52.gif" alt="Wilted Flower" />


    <FONT size=3></FONT> 

  • 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:

    <blockquote>

    <code>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)</code>

    </blockquote>

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

    <blockquote>

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

    </blockquote>

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

    <blockquote>

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

    </blockquote>

    Thanks

  • Replied 8 September 2017, 2:05 pm EST

    <BLOCKQUOTE><div><img src="/wp-content/uploads/CS_images/icon-quote.gif"> SureshD:</div><div>

    Hello,


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


    <BLOCKQUOTE>

    <CODE>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)</CODE>

    </BLOCKQUOTE>

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


    <BLOCKQUOTE>

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

    </BLOCKQUOTE>

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


    <BLOCKQUOTE>

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

    </BLOCKQUOTE>

    Thanks


    </div></BLOCKQUOTE>


    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