Edit Columns

The Edit Columns allows changing the layout of the fields listed in the Data Page. You can add, remove columns, format and change their orders.

Existing columns can be removed by pressing the trash icon.

You can also edit their existing columns’ labels by pressing the edit button.

While editing you will options to edit labels’ format.

This is the default setting of the column:

While editing you will see 4 options:

Do not use any formating: You can choose not to use any formatting while displaying data for this column, which will effect the displayed data and label in the data page.

Database: If this option is selected, displayed data format and column label will be pulled from the SpreadsheetWeb Hub’s database.

Control Properties: If this option is selected, displayed data format and column label will be pulled from the designer application.

Custom Settings: This option will let you change the label name and choose desired format.

You can choose to only display numbers in the data page or change its format to display in the datapage.

When you are done formatting the column, click on OK. The changes made will be applied to the applicaitons’ date page immediately.

You can add new columns to the data page from the Add a Column list. You can have a minimum of 5 and a maximum of 20 columns for each application.

The ‘Add a Column’ list will list you the existing named ranges in your application and by adding them to the data page, you can display important data to users.

Once you click on an option it will be added as a column immediately. ‘Total Premium’ column which is in the currency format.

By clicking on Edit button, you can change the column label and formatting.