Set the operation of the sheet at the release

In the sheet of the published application, you can set it so that you can change the size of rows and columns , hide, filter, and fix window frame.
This setting is done by clicking the 'Sheet setting' from the ribbon menu, then on the "Publish' tab of the 'Sheet setting' dialog.
../../../_images/img_01.en210.png

Show row heading

  1. Check 'Show row heading'.
../../../_images/img_02.en194.png

When you show row heading, you can perform the following operations on the published sheet:

  • Copy row
  • Paste
  • Change row hight
../../../_images/img_03.en156.png
  1. If you want to hide and unhide rows, check "Allow row to 'Hide' and 'Unhide'".
../../../_images/img_04.en137.png

Tip

For a published sheet that allows input of all cells, you can operate 'Hide' and 'Unhide' without doing this setting.

Show column heading

  1. Check 'Show column heading'.
../../../_images/img_05.en122.png

When you show column heading, you can perform the following operations on the published sheet:

  • Copy column
  • Paste
  • Change column width
../../../_images/img_06.en97.png
  1. If you want to hide and unhide columns, check "Allow column to 'Hide' and 'Unhide'".
../../../_images/img_07.en90.png

Tip

For a published sheet that allows input of all cells, you can operate 'Hide' and 'Unhide' without doing this setting.

Allow filter operations

  1. Check "Allow 'Filter' and 'Filter Cancel'".
../../../_images/img_08.en84.png

You can select a cell on the published sheet, right-click and select the 'Filter' menu and perform filter operation as in the case of editing.

../../../_images/img_09.en73.png

Tip

For a published sheet that allows input of all cells, you can operate 'Filter' and 'Filter Cancel' without doing this setting.

Allow fixed window frame operations

  1. Check "Allow 'Fixed' and 'Fixed Cancel'".
../../../_images/img_10.en63.png

You can select a cell on the published sheet, right-click and select the 'Fixed' menu and perform fix window frame operation as in the case of editing.

../../../_images/img_11.en58.png

Tip

For a published sheet that allows input of all cells, you can operate 'Fixed' and 'Fixed Cancel' without doing this setting.

Related keywords

Header