RightToLeft On second sheet

RightToLeft On second sheet

Posted by: ysadvise on 1 April 2019, 7:11 am EST

• 

  ysadvise

  • Post Options:
  • Link
    Copy

  Posted 1 April 2019, 7:11 am 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 ?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 2 April 2019, 7:16 am EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  ysadvise

  • Post Options:
  • Link
    Copy

  Posted 3 April 2019, 5:17 am EST

  For windows

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 5 April 2019, 10:42 am EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 5 April 2019, 10:42 am EST

  Here is the attachment.
  
  SpreadWinRTLCheck.zip

• 

  ysadvise

  • Post Options:
  • Link
    Copy

  Posted 23 April 2019, 4:46 am 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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 24 April 2019, 8:41 am EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma