-
FlexPro
- Zoom sur FlexPro
- Fonctionnalités & Options
- Domaines d’application
- Tous les avantages
- Nouveau dans FlexPro 2021
- Testez FlexPro gratuitement
- FlexPro View OEM Freeware
- Conseils d’achat
- Login
- Langue
-
-
-
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produits
- News
- Support
- Société
- Emplois
- Contact
- Login
- Langue
-
-
-
- +49 6894 929600
- infoweisang.com
- Google Maps
Accueil > Community > FPScript > Avoiding errors messages in Cell tables > Reply To: Avoiding errors messages in Cell tables
February 20, 2014 at 8:47 am
#9343
![Bernhard Kantz](https://www.weisang.com/wp-content/uploads/2016/09/default_avatar.jpg)
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.