Allow Cell Input When Publish

Allow All Cell Input

  1. Click 'Input Limitation' button from ribbon menu, then 'Input Limitation' dialog is opened.
../../../_images/img_01.en187.png
  1. Uncheck from 'Disable user input to sheet after this CELF application is published', and then click 'OK' button.
../../../_images/img_02.en171.png

Tip

  • In case creating the new sheet, 'Disable user input to sheet after this CELF application is published' is checked.
  • Even if 'Disable user input to sheet after this CELF application is published' is checked, you can input into the cell with the input format (list, check button, date).
  1. Save the sheet.

Permit to input partly

  1. Click 'Input Limitation' button from ribbon menu, then 'Input Limitation' dialog is opened.
../../../_images/img_01.en187.png
  1. Check 'Disable user input to sheet after this CELF application is published'.
../../../_images/img_03.en139.png
  1. Designate 'Cells that are enabled for input', then click 'OK'.
../../../_images/img_04.en123.png

Tip

In 'Cells that are enabled for input', you can designate the multi-cell and cell range.

Attention

Don’t designate the cell with the input format (list, check button, date). Otherwise user can edit the formulated cell (like '=LIST()').

  1. Save the sheet.

Allow formatting

  1. Click 'Input Limitation' button from ribbon menu, then 'Input Limitation' dialog is opened.
../../../_images/img_01.en187.png
  1. Check 'Disable user input to sheet after this CELF application is published'.
../../../_images/img_03.en139.png
  1. Designate 'Cells that are enabled for input' and 'Cells that are enabled for editing styled text', then click ‘OK’.
../../../_images/img_05.en110.png
  1. Save the sheet.
When you run the app, you will be able to change the format only within the range specified in 'Cells that are enabled for editing styled text'.
Select cell or character and right-click to open the Format Cells dialog and change the format.
../../../_images/img_06.en88.png

Attention

Specify the 'Cells that are enabled for editing styled text' within the range specified in 'Cells that are enabled for input'. If you specify a value outside the range of 'Cells that are enabled for input', you cannot set the format.

See also

For information on how to change the character formatting of a cell, see Change the Format of some Characters in a Cell.