Avoiding errors messages in Cell tables

SupportCommunity FPScript Avoiding errors messages in Cell tables

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12847
    HerveM1234HerveM1234
    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

    #8507
    HerveM1234HerveM1234
    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

    #9343
    Bernhard KantzBernhard Kantz
    Moderator

    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.

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.