Question

When including (from another page) a page with chart (ChartPlugin) that uses data from table with some spreadsheet expressions (SpreadSheetPlugin), I get always a blank chart (like all values equal to zerro). Expressions are defined using variables:

%CALC{"$SET(suma, $NOEXEC($ROUND($SUM(R$ROW(-11):C$COLUMN()...R$ROW(-1):C$COLUMN()),1)))"}%

The table row which makes the troubles looks like the following:

| *SUM* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* | *%CALC{"$EXEC($GET( suma ))"}%* |

When I change the chart definition to use row without spreadsheet expressions, everything works well. No error or warning message in apache/twiki logs.

Here is the whole included page code:

You can see the result in Sandbox/PetrKlikaSandbox.

When I tried to use the $ROUND(...) expressions directly (instead of calling $EXEC(...)), I've got graph with -11 values in the included chart. This leads to some parse error in the expressions probably.

Environment

-- PetrKlika - 21 Aug 2007

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

I suspeced a web="%WEB%" topic="%TOPIC%" in %CHART would do the trick, but not so. Not sure how to fix that.

-- PeterThoeny - 27 Aug 2007

Sorry, closing this after more than 30 days of inactivity. Please feel free to reopen the question.

-- PeterThoeny - 03 Oct 2007