Item6003: Loss of data when including chart from another topic

Including a chart from another topic results in a curious (SpreadSheetPlugin-related?) effect, where a column of data is lost. Testcase:

Two topics, TopicOne and TopicTwo. TopicOne contains the following:

|   | A | B | Total |
| 1 | 7 | 9 | %CALC{$SUM(R$ROW():C1..R$ROW():C3)}% |
| 2 | 6 | 6 | %CALC{$SUM(R$ROW():C1..R$ROW():C3)}% |
| 3 | 4 | 2 | %CALC{$SUM(R$ROW():C1..R$ROW():C3)}% |
%CHART{ type="line" name="line3" data="R2:C2..R4:C7" legend="R1:C2..R1:C7" xaxis="R2:C1..R4:C1" yaxis="on" datalabel="on" }%

The data table and chart display as expected, with three lines on the chart.

TopicTwo contains the following:

%INCLUDE{"TopicOne"}%

The data table is displayed identically, and the chart is displayed correctly except the totals line is completely wrong.

-- TWiki:Main.CrawfordCurrie - 17 Sep 2008

I suspect that this might be fixed. IIRC there was an off-by-one issue in the Rn:Cn format found a long time ago in the SSP.

Setting to NeedsDeveloper.

-- Main.GeorgeClark - 25 Sep 2016 - 19:32

Commenting is disabled while not logged in