Check documentation for the latest version of dhtmlxSuite Worksheet Settings DHTMLX Docs

Worksheet Settings

Spreadsheet allows you to make different worksheet settings. They are:

Setting number of rows

To set the number of rows, you should perform the following steps:

  • Click on the toolbar item Settings;
  • Enter the number of rows you wish to present in the spreadsheet in the field Rows number;
  • Click OK to save changes. If you don't want to save changes - click Cancel.

spreadsheet/setting_rows_number.png

Setting number of columns

To set the number of columns, you should perform the following steps:

  • Click on the toolbar item Settings;
  • Enter the number of columns you wish to present in the spreadsheet in the field Columns number;
  • Click OK to save changes. If you don't want to save changes - click Cancel.

spreadsheet/setting_columns_number.png

Showing/hiding rows' headings

To show/hide rows' headings, you should perform the following steps:

  • Click on the toolbar item Settings;
  • Check/uncheck the field Show row numbers;
  • Click OK to save changes. If you don't want to save changes - click Cancel.

spreadsheet/showing_rows_headers.png

Showing/hiding export buttons

To show/hide export buttons, you should perform the following steps:

  • Click on the toolbar item Settings;
  • Check/uncheck the field Show export buttons;
  • Click OK to save changes. If you don't want to save changes - click Cancel.

spreadsheet/showing_export_buttons.png

Modifying columns' width

To modify the width of some column, you should click on the right border of a column heading cell and set the desired width.

spreadsheet/modifying_column_width.png

Modifying columns' headings

To modify column's heading, you should double click on the appropriate heading and enter the desired text.

spreadsheet/modifying_column_header.png

Back to top