Transit From The Sheet To Other Sheet

You can operate each 3 sheets by using the sheet operation action.

  • Change the sheet
  • Open the new window and sheet.
  • Close the sheet

You need to create the destination sheet to transit in advance

Change the sheet

  1. Open 'Action set setting'.
  2. Drag 'Switch to sheet of application' action from 'Sheet' tab, then set in the edit area.
../../../../_images/img_01.en54.png
  1. Click 'Select Sheet' button.
../../../../_images/img_02.en52.png
  1. The 'Select Sheet' dialog box will open. Click the button to the right of the 'App' field.
../../../../_images/img_03.en41.png

Tip

If you want to navigate to the current app’s sheet, skip clicking the button in the 'App' field and proceed to Step 6.

  1. In the 'Select App' dialog box, select the app you want to open and click the 'OK' button.
../../../../_images/img_12.en12.png

Attention

If multiple apps share the same name, executing this action may navigate to a sheet in an unintended app.
To specify the destination app, check the 'Set in the folder hierarchy' box and click the 'OK' button.
The folder path is automatically set in the 'Specify the app’s folder hierarchy' action, allowing you to narrow down the destination apps.
However, even if this method is used, if apps with the same name exist within the same folder, it may still navigate to a sheet in an unintended app.
../../../../_images/img_13.en9.png
  1. Choose the destination sheet to switch to in 'Select sheet' dialog, then click 'OK' button.
../../../../_images/img_14.en8.png
  1. At the transition, to set a value in the cell of the transition destination sheet, specify the cell address and value to set by pressing the '+' button.
../../../../_images/img_04.en39.png

Tip

You can set the multi-parameter (value set to the destination sheet) by pressing '+' button and can delete the parameter by clicking 'Recycle Bin' button.

Attention

If a name is specified for the parameter "cell", it works by referring to the name defined in the destination sheet.
Prior to version 3.3.2, it worked by referencing the name defined on the current sheet.
To have the same behavior as in version 3.3.2 and earlier, turn ON "Use the name of the current sheet in sheet manipulation action cells" in the "Sheet Settings" dialog.
  1. Click 'OK' button.

Open the new window and sheet.

  1. Open 'Action set setting'.
  2. Drag 'Show sheet of application in new window' action from 'Sheet' tab, then set in the edit area.
../../../../_images/img_05.en34.png
  1. Click 'Select Sheet' button.
../../../../_images/img_06.en26.png
  1. The 'Select Sheet' dialog box will open. Click the button to the right of the 'App' field.
../../../../_images/img_03.en41.png

Tip

If you want to open the current app’s sheet in a new window, skip clicking the button in the 'App' field and proceed to Step 6.

  1. In 'Sheet Selection', choose the new sheet to open, then click 'OK' button.
../../../../_images/img_12.en12.png

Attention

If multiple apps share the same name, executing this action may navigate to a sheet in an unintended app.
To specify the destination app, check the 'Set in the folder hierarchy' box and click the 'OK' button.
The folder path is automatically set in the 'Specify the app’s folder hierarchy' action, allowing you to narrow down the destination apps.
However, even if this method is used, if apps with the same name exist within the same folder, it may still navigate to a sheet in an unintended app.
../../../../_images/img_13.en9.png
  1. In 'Sheet Selection', choose the new sheet to open, then click 'OK' button.
../../../../_images/img_14.en8.png
  1. Check 'Limit operation to active window' if you do not want to operate the parent window while the new window is open.
../../../../_images/img_07.en25.png

Attention

If this option is checked, subsequent actions of this action will not be performed until the new window is closed.

Tip

By default, new windows are displayed in fixed-size windows.If you want to be able to change the window size, check 'Allow window size change'

../../../../_images/img_11.en13.png
  1. To set a value in a cell of an opened sheet when opening in a new window, specify the cell address and value to set by pressing the '+' button.
../../../../_images/img_08.en22.png

Tip

You can set the multi-parameter (value set to the destination sheet) by pressing '+' button and can delete the parameter by clicking 'Recycle Bin' button.

Attention

If a name is specified for the parameter "cell", it works by referring to the name defined in the newly opened sheet.
Prior to version 3.3.2, it worked by referencing the name defined on the current sheet.
To have the same behavior as in version 3.3.2 and earlier, turn ON "Use the name of the current sheet in sheet manipulation action cells" in the "Sheet Settings" dialog.
  1. Click 'OK' button.

Close the sheet

  1. Open 'Action set setting' dialog to close the sheet.

Note

You can’t close another sheet.

  1. Drag 'Close sheet' action from 'Sheet' tab, then set in the edit area.
../../../../_images/img_09.en17.png
  1. If the closing sheet is opened by the action set, you can set the value in the current sheet and cell to the original sheet and cell by pressing '+' button.
../../../../_images/img_10.en15.png

Tip

You can set the multi-parameter (value sets to the caller sheet) by pressing '+' button and can delete the parameter by clicking 'Recycle Bin' button.

Attention

If a name is specified for the parameter "cell", it works by referring to the name defined in the calling sheet.
Prior to version 3.3.2, it worked by referencing the name defined on the current sheet.
To have the same behavior as in version 3.3.2 and earlier, turn ON "Use the name of the current sheet in sheet manipulation action cells" in the "Sheet Settings" dialog.
  1. Click 'OK' button.