Spreadsheet relative cell referencing

• TWiki version: twiki20010803
• Spreadsheet version: 1.0
• Web server: Apache
• Server OS: Solaris 5.7

I am trying the Spreadsheet-Plugin but I have problems with relative cell referencing. I have a small table and I like to multiply the previous cell with a constant value. When I'm using absolute cell referencing (e.g. % CALC{"$EVAL($T(R1:C2) * 8)"} % ) it is working as expected but % CALC{"$EVAL($T(R$ROW(0):C$COL(-1)) * 8)"} % shows *main::8.

Example:

Debug output:

SpreadSheetPlugin::doFunc: ROW( 0):C$COL(-1 ) start
SpreadSheetPlugin::doFunc: ROW( 0):C$COL(-1 ) returns: 2
SpreadSheetPlugin::getTableRange( R2..R2 ) <-- ???
SpreadSheetPlugin::doFunc: T( R2 ) returns: 
SpreadSheetPlugin::doFunc: EVAL( *8 ) returns: *main::8
SpreadSheetPlugin::doFunc: MAIN( *main::8 ) returns: *main::8

-- BeatJucker - 27 Aug 2001

Answer

There is a documented limitation of the current spreadsheet implementation where you cannot have more then one function per nesting; $T(R$ROW(0):C$COL(-1)) contains two functions, so $ROW() picks up 0):C$COL(-1 as it's parameter, which is incorrect.

This limitation needs to be fixed. If anyone knows how to solve that problem let me know in SpreadSheetPluginDev.

-- PeterThoeny - 28 Aug 2001