RPE Excel Formulas
Does anyone know how to insert a literal function or formula into an Excel spreadsheet when exporting with RPE 6.0.5?
Something such as =if() or @Sum() etc.
When I put them in a text box they come out as text rather than functions/formulas.Accepted answer
Furmulas/functions in Excel are currently not supported by RPE. As a workaround, you can insert the literal function with some text (ex. "/=@") prefixed. After the document generation, open Excel output and replace "/=@" with "=" so that it will changed to a function. You can do this either manually or using a VBA macro.
Example: Use "/=@sum(4+4)" instead of "=sum(4+4)" and then replace "/=@" with "="