Avoiding errors messages in Cell tables

[HerveM1234]

Hi,

I’m filling a Cell Table using FPscript.
The cells content is :

%.0F{MK[0]}s 
%.0F{MK[1]}s
%.0F{MK[2]}s

Every things work perfect is MK exists, if not I have this message in the cell :

%.0F(Wrong value in index operation.

The index value used lies outside of the valid value range for the data set to be indexed.)s

instead of empty cell or N/A for example.
Is there a way to change this behaviour. If value does not exist I would like nothing in the cell.

Thanks in advance

[HerveM1234]

Hi,

I’m filling a Cell Table using FPscript.
The cells content is :

%.0F{MK[0]}s 
%.0F{MK[1]}s
%.0F{MK[2]}s

Every things work perfect is MK exists, if not I have this message in the cell :

%.0F(Wrong value in index operation.

The index value used lies outside of the valid value range for the data set to be indexed.)s

instead of empty cell or N/A for example.
Is there a way to change this behaviour. If value does not exist I would like nothing in the cell.

Thanks in advance

[Bernhard Kantz]

There are two possible solutions: Ensure the required size of the dataset, e.g. by creating it with the needed number of void entries and setting only the values computed. This leads to cell table contents like ? s.
Another solution is to back the original dataset by a fixed size string dataset holding the actual cell table entries. In the present case, the following FPScript fomula does the formatting and handles the non-existing data elements.

Dim sRes = "N/A" # 3	// "empty" cell

For Each Row i In sRes Do
	Try
		sRes = Format("%.0F s", MK)
	Catch ignore
	End
End

sRes

If named strMK one can change the cells content to
%%%
avoiding the error message since the genereted string dataset has the required length.

[Author]

Posts