Forum FlexPro – Discuss your topic!

Avoiding errors messages in Cell tables

Dieses Thema hat 2 Antworten sowie 2 Teilnehmer und wurde zuletzt vor vor 10 Jahren, 10 Monaten von HerveM1234 aktualisiert.

Viewing 3 posts - 1 through 3 (of 3 total)

Autor

Beiträge
Februar 19, 2014 um 5:35 pm Uhr #12847
HerveM1234
Teilnehmer
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
Februar 19, 2014 um 5:35 pm Uhr #8507
HerveM1234
Teilnehmer
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
Februar 20, 2014 um 8:47 am Uhr #9343
Bernhard Kantz
Teilnehmer
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.
Autor

Beiträge

Viewing 3 posts - 1 through 3 (of 3 total)

Du musst angemeldet sein, um auf dieses Thema antworten zu können.