Resizing of models with CSV import
To optimize resize time of models while importing CSV, you should add some parameters to your grids.
Grids with the same number of cells
To define that two grids have the same number of rows while resizing add a /ResizeRow or /Resize to the grid name.
To define that two grids have the same number of columns while resizing add a /ResizeColumn to the grid name.
Formulas referring to a resized grid
For formulas that might be extended or reduced while resizing, you must use add-in functions like MM_LASTROWCELL function or MM_LASTCOLUMNCELL function to refer to the last cell of the grid.
Resizing multiple grids with different size
If your grids are resized in different ways (with different row numbers), you can add a name after the /ResizeRow (/Resize) or /ResizeColumn flags in the grid name, following this example:
- /ResizeRow.NAME1 for the grids with size A.
- /ResizeRow.NAME2 for the grids with size B.
Resizing grids with MM_SETSIZE
You can resize your grids by using a Mind MM_SETSIZE function. It copies your specified formulas for a given number of rows and columns.