%CALC{"formula"}%
. It can be in any table cell, but also in text outside of a table.
"formula"
can be: %CALC{"2 + 2"}%
"R1:C1"
. I.e. "row 2, column 3" is "R2:C3"
"R1:C3...R1:C3"
"$ROW(offset)"
and "$COLUMN(offset)"
returns the current row and column number, with an optional offset. I.e. to list the number of rows excluding title ( first row) and summary (last row) write: %CALC{"$ROW(-2)"}%
%CALC{"$SUM( R2:C5...R$ROW(-1):C5 )"}%
%CALC{"$COUNTITEMS( R2:C2...R$ROW(-1):C2 )"}%
Anybody up to writing a plugin that does something like this?
-- PeterThoeny - 08 Mar 2001
Peter. Funny you should mention that. I've been playng with this a bit at home recently. However, I was planning to copy the approach you used for TWikiDraw.
1. I've got a couple of simple Java spreadsheet applets of the Internet 2. I'll take best features of thse 3. Alter so html and csv or similar uploaded to TWiki 4. Edits to be done using applet
However, not doing much, as focus is on items for TWikiReleaseSpring2001.
-- JohnTalintyre - 08 Mar 2001
We had a need at work for that, so I created a first version. I will upload the ZIP in a few days. Please follow up in the Plugins web, SpreadSheetPlugin and SpreadSheetPluginDev.
-- PeterThoeny - 14 Mar 2001