Useful settings for CELF

The CELF application allows you to set up filters and fixed frames, just like Excel.

This page shows you how to set up the useful features of CELF.

Open the sheet to be set

1.' Login ' to CELF and click the "Manage" button to open the management screen.

Tip

The "Manage" button appears when you are logged in as an administrator.

2.Double-click the app you want to set up.

3.Double-click on the sheet (screen) you want to configure. These settings are made for each sheet (screen).

Sheet settings

1. You can configure the number of rows and columns in this sheet (screen) and show/hide the borders between the matrices.

• Change the number of columns and rows to display on a sheet
• Change the decimal point and the digit separator
• Set the display of the sheet when publishing
• Set the operation of the sheet when publishing

2. This is a setting that hides the print and Excel output buttons in the Publish

• Set Hide Icons Printing Excel

Input limitation

1.You can limit the cells that users can enter.

• Allow Cell Input When Publishing

Frame Fixing Settings

1.You can set the app to display a fixed frame.

• Fix Window Frame

Setting to show/hide rows

1.You can set up to show or hide the lines.

• Unhide/Hide rows or columns
• Hide/Unhide rows or columns

Filter settings (screen)

1. Select the cell you want to apply a filter to, then right-click and select "Filter(L)".

2. To cancel the filter, select "Filter Cancel (L)".

Filter settings (action)

1. Drag and drop "Set filter range" in "Cells" tab.

2. Enter a range to filter.

3. You can cancel the filter by setting the "Cancel filter range" action.