FlexPro Forum – Discuss Your Topic!

Avoiding errors messages in Cell tables

Home > Community > FPScript > Avoiding errors messages in Cell tables

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #12847
    HerveM1234HerveM1234
    Participant

    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

    #8507
    HerveM1234HerveM1234
    Participant

    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

    #9343
    Bernhard KantzBernhard Kantz
    Participant

    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.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.