It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×11,924
×1,036
×64
×1

question asked: Feb 13 '19, 1:45 p.m.
question was seen: 1,779 times
last updated: Feb 14 '19, 8:07 a.m.

Related questions

FAQ - How this Forum works

RPE Excel Formulas

0
Don Cooper (16●2●11) | asked Feb 13 '19, 1:45 p.m.

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

0
permanent link
Subramanya Prasad Pilar (4.6k●1●6) | answered Feb 14 '19, 3:50 a.m.
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 "="
Don Cooper selected this answer as the correct answer
Comments
Don Cooper commented Feb 14 '19, 8:07 a.m.
Okay thanks Subra.

RPE produces a non-macro enabled format, xlsx, without the ability to save it as xlsm, I tried.

So the user would have to save the file as xls, then open it and save it as xlsm, then run the macro.

Believe it or not this is too much for some users to bear. :D

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.