Information about possible options for each configuration

Getting help Questions
1

Good,

I would like to know where to find in the documentation all the parameters that can have the configuration of a certain field.

For example, I want to know what parameters I can enter in the “columnSummary” field of the table. Right now I use all these parameters:

				var columnSummarySettings = [{
				destinationColumn: 2,
				destinationRow: 0,
				type: 'sum',
				forceNumeric: true,
				suppressDataTypeErrors: true,
				readOnly: true
			}];

			var tablaSettings = {
				data: oData,
				columns: columnSettings,
				formulas: true,
				cell: cellSettings,
				...
				columnSummary: columnSummarySettings
			};

But I need to know if I can enter a maximum quantity limit, so that when the cell is reached it is painted in red (formatted error).

Somebody could help me?

Thank you and greetings.

PD: Sorry for my bad english

2

Hi @carlos.duran.garcia

Here’s a complete list:

destinationRow: number *required
destinationColumn: number * required
type: string/predefined * required

reversedRowCoords: boolean *optional
roundFloat: number *optional
readOnly: boolean *optional
suppressDataTypeErrors: boolean *optional
forceNumeric: boolean *optional

In your list there’s no reversedRowCoords which is needed to reverse the coordinates typed in destinationRow it is helpfull when you want to have the summary row always at the end of the table (then you add the destinationRow: 0).

Also if you would like to road a value you can use roundFloat. It is helpfull when you (for example) count an average and want you have only max 2 decimal places.

When it comes to marking cell as red you can do it via validation method - beforeValidate..

3

Thank you very much,

But I’m not very clear how I can use the “beforeValidate” event, does it apply to the entire table, columns, or cells individually? Is there an example I can see?

Regards!

4

The beforeValidate hook runs only when you have a validator or a cell type with a validator defined in your spreadsheet.

It runs for a cell that has been changed. Here’s an example: http://jsfiddle.net/handsoncode/rfpxL4h5/ Open the console and check any cell in the table.

The values in the console are new value, row of changed cell, property or a column index for changed cell, source of a change presented as a predefined string.

Let me know if that’s clear or I should explain something more.