Grid Alignment

Default Alignment: When you create a new grid control (for input or output), the default alignment for the entire grid is set to left. However, this can be changed easily. Accessing the Designer Interface: Open the grid’s designer interface. Scroll down to the...

Form-based Input Grids

Formula based input grids differ from inline grids in how data is entered into the table. To change the input grid type, select the input grid in the user interface designer, and select Form-based from the Type of Input Method property. Form-based option will display...

Column Widths

By default, the system will determine the width of each column in an input grid dynamically based on its contents. You can control the size of the columns manually for each column by going into that column from the grid menu in the user interface designer. The Column...

Hide/Disable Rows

Grid controls in SpreadsheetWEB are managed on a column by column basis, and because of this, you need a separate “helper” column to manipulate individual rows. The helper column must consist of Boolean fields with a TRUE or FALSE outcome. They can be static, or set...

Hide Columns

You can set the visibility of individual columns in an input grid by selecting that column in the grid options in the user interface designer, and selecting an option from the Visible in the Grid property. Always and Never options can be used to permanently show or...

Formatting – Metadata

When Use Metadata Formatting option is enabled, any column-based formatting will be replaced with the formatting information coming from your workbook. This works on the cell level, meaning that you can set a different formatting for every individual cell. When this...

Text Masks

You can format the values displayed in input grid columns using the masks feature. Please note that this property will only be available if the Use Metadata Formatting option is disabled, otherwise all formatting will be controlled by the workbook metadata. You can...

Copy and Paste

When copying data from clipboard into an input grid, simply click on the cell where you want the first piece of the data to be placed, and then press the “Ctrl + V” keys. The data will be copied starting from the target cell. The system will also show you...

Pagination

When enabled, the pagination property will split the rows of an input grid into multiple pages. This can help improve load speed of a web application, especially if you store large data in the input grid controls. Another benefit of enabling pagination is for better...

Responsive

An input grid with the responsive property enabled will collapse the columns when the contents of any of the input cells exceed the visible area. In this case, you can click the green plus buttons to expand individual rows to display the data. When this property is...