Problem
I was trying to evaluate excel formula in cell of ADFdi table component. My try was unsuccessfull, got formula rendered as a literal string in the cell.
Solution
Apparently when ADFdi plugin evaluates value expression of particular column, it needs to know what kind of output you expect in the cell. Is it a literal value, o some instructions to excel what value to provide (i.e. formula). Use “T” function to have it rendered as a real excel formula and evaluated by excel in its runtime, i.e.:
