Question

I have created a custom comment template that contains some logic using the Spreadsheet CALC variable.

When the custom comment renders on the page that references it, the CALC variable is not evaluated.

For example:

If I create a custom comment topic with the following definition in it

%TMPL:DEF{PROMPT:issueassign}%
%CALC{"$ABS(-12.5)"}% 
%TMPL:END%

%TMPL:DEF{OUTPUT:issueassign}%
%POS:BOTTOM%
*%DATE%* - Assigned User: - %WIKINAME%: <BR><BR>
%TMPL:END%

And reference this custom comment topic in another topic with this code

%COMMENT{type="issueassign"  templatetopic="CommentTemplate"}%

The page renders showing the CALC variable and not the evaluated ABS of -12.5... Renders something like this

%CALC{"$ABS(-12.5)"}%

This is obviously a simplified example... My question is how can I use Spreadsheet functions from within comment template topics ????

Environment

-- JeffLozier - 03 Apr 2008

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Not an answer, but I recall that I tried to use a CALC within a comment template and it did not get evaluated. The author of the CommentPlugin probably can give some insights.

-- PeterThoeny - 03 Apr 2008

Closing this question after more than 30 days of inactivity. Please feel free to reopen if needed.

-- PeterThoeny - 11 May 2008