RightToLeft On second sheet

Posted by: JackSun on 31 March 2019, 10:11 pm EST

  • Posted 31 March 2019, 10:11 pm EST

    I created a 2nd sheet by using fpSpread1.Sheets,Count = 2
    The grid property RightToLeft was set True

    On preview Sheets(0) displayed RTL and Sheet(1) displayed LTR
    What am i doing wrong ?
  • Replied 1 April 2019, 10:16 pm EST


    May I know if you are using the Spread for Windows Forms or Spread for ASP.NET?
    Since you have posted your query under Spread.Sheets, we are not sure which version of Spread you are using.

    Deepak Sharma
  • Replied 2 April 2019, 8:17 pm EST

    For windows
  • Replied 5 April 2019, 1:42 am EST


    I am not able to replicate this issue at my end. I used the following code:

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    FpSpread1.RightToLeft = RightToLeft.Yes
    FpSpread1.Sheets(0).Cells(0, 0).Text = "This is test sheet1"

    End Sub

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    FpSpread1.Sheets.Count = 2
    FpSpread1.Sheets(1).Cells(0, 0).Text = "This is test sheet2"

    End Sub

    When I click on button to add another sheet, it's content shows as per the sheet1 i.e. RightToLeft.

    Please refer to the attached sample application.

    Deepak Sharma
  • Replied 5 April 2019, 1:42 am EST

    Here is the attachment.
  • Replied 22 April 2019, 7:46 pm EST

    The problem is with this line

    My.Forms.PrintPreview12.FpSpread1.Sheets(0) = Me.TmpGrid.Sheets(1)
    I change sheets: assigned TmpGrid sheet 1 in the first form to sheet 0 in a second form

    When I use this - the grid is fine
    My.Forms.PrintPreview12.FpSpread1 = Me.TmpGrid

  • Replied 23 April 2019, 11:41 pm EST


    Could you please provide me more information on why do you want to assign the particular sheet from one to another form.
    After assigning the sheet to another Spread(FpSpread1) you can set :
    FpSpread1.RightToLeft = RightToLeft.Yes

    so it works for all sheets in FpSpread1.

    Deepak Sharma
Need extra support?

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

Learn More

Forum Channels