Field help (AEXPFORCH)

The "Formula" column is used to define a formula for a column in the grid. This formula can be expressed using the + - * / ( and ) operators, as well as the max and min operators. It can also contain numbers with the . as decimal separator and field names.

This formula will replace the value present in the grid and it will be implemented in the Excel spreadsheet, thus making it possible to take dynamic modifications into account. Thus it will be possible to write the formula PRIXUHT*QTE*1.196 if the PRIXTTC column if PRIXUHT and QTE are 2 fields exported from the grid. Beware, there is no check of the formula validity. If said formula is not contained in the export, it will be ignored.