Question

. I am trying to use the SpreadSheetPlugin to do a mini inventory. What I need to do is just find out if a value is below a certain level. Something like:

• I have tried various syntax for getting this simple subtraction to work. None work when I try to use the value of the cells in the calculation (i.e., %CALC{"$EVAL($T(R2:C5)-$T(R2:C4))"}% ). I can use the %CALC{"$EVAL(3-5)"}% with no problem (I get -2 back). Any ideas?
• As a correllary (sp?), I'd like to set up something like an "If Qtyonhand < Min then Display 'Reorder' ". I don't see any way to do that yet. Anyone have any ideas?

Thanks. --- MIcah

• TWiki version: Sept-9
• Web server: Apache
• Server OS: Linux
• Web browser: Netscape 4.79
• Client OS: Win2k

-- MicahHoffman - 11 Feb 2002

Answer

You ran into a limitation of the current plugin, it cannot process more then one pair of parenthesis per nesting level. See SpreadSheetPluginDev for details. Let us know if you find a solution

Also, conditional text is not in yet, could be added.

-- PeterThoeny - 13 Feb 2002