TdxSpreadSheetTableViewOptions.RightToLeftLayout Property

Switches a specific worksheet’s layout between right-to-left and left-to-right modes.

Declaration

property RightToLeftLayout: TdxDefaultBoolean read; write; default bDefault;

Property Value

Type	Default
TdxDefaultBoolean	bDefault

Remarks

Set this property to bTrue to horizontally flip the worksheet’s content.

Options include:

Value	Description
bTrue	Enables the RTL mode for the worksheet.
bFalse	Enables LTR display mode for the worksheet.
bDefault	The control’s BiDiMode property value defines the worksheet’s display mode.

The spreadsheet workbooks support right-to-left layout setting for each worksheet.

Since v19.2, spreadsheet controls show worksheets with a right-to-left layout in the way they are designed to look. To restore the appearance that such documents had in previous versions, iterate through all sheets in the loaded document and assign bFalse to the RightToLeftLayout property as shown in the code snippet below:

Delphi

var
  I: Integer;
begin
  dxSpreadSheet1.LoadFromFile('C:\MyFile.xlsx');
  for I := 0 to dxSpreadSheet1.SheetCount - 1 do
  begin
    if dxSpreadSheet1.Sheets[I] is TdxSpreadSheetTableView then
      TdxSpreadSheetTableView(dxSpreadSheet1.Sheets[I]).Options.RightToLeftLayout := bFalse;
  end;
end;

C++

TdxSpreadSheetTableView *ATableView;
  dxSpreadSheet1->LoadFromFile("C:\\MyFile.xlsx");
for(int i  = 0; i < dxSpreadSheet1->SheetCount; i++)
{
  if(dxSpreadSheet1->Sheets[i]->InheritsFrom(__classid(TdxSpreadSheetTableView)))
  {
    ATableView = dynamic_cast<TdxSpreadSheetTableView*>(dxSpreadSheet1->Sheets[i]);
    ATableView->Options->RightToLeftLayout = bFalse;
  }
}

To identify if the RTL mode affects the worksheet, use the ActualRightToLeftLayout property.

Note

The ExpressPrintingSystem does not provide support for printing worksheets with enabled RTL mode. While a component printer is building a report from a worksheet, its Options.RightToLeftLayout property value temporarily changes to bFalse.

The default value of the RightToLeftLayout property is bDefault.