Using Execl formula in NPrinting

[boopeshj]

Brief :

I have a table with multiple columns. This is just an example. I would like to dynamically display the number of characters in one of the column for all rows.

Example :

"Col1 Summary" is from table from Qlikview source.

Length : is what I am looking for as output.

I want NPrinting output Excel to have the formula mentioned in col B to have calculated until the end of rows in my table.

This formula should be in the excel so that it could calculate dynamically when users add text in Excel post the generation.

Editing after generation

  

Let me know if this possible.

Thanks in advance for your help.

[boopeshj · Accepted solution]

I was not unchecking/unselecting the expand range on the table properties. Which caused the value or formula to cell's to disappear.