How can I allow a user to enter a value in a cell and use %CALC to control how that value is formatted for display?

Is it possible to use the SpreadSheetPlugin to control the display format used for a column of the spreadsheet, while allowing the users to enter the actual values in the cells of that column?

If so, how would I do it?

If it can't be done with the SpreadSheetPlugin, how else could I get an effect like $percntCALC{"$FORMAT(DOLLAR, 2, $T(R$ROW( ):C$COL( )))"}% for all the cells in one column and an effect like $percntCALC{"$FORMATTIME($TIME($T(R$ROW( ):C$COL( ))), $day-$mon-$year)"}% for all the cells in another column? Is there a different pligin that I should be using to accomplish this?

-- DavidRosenberg - 08 Jan 2012

One possibility - You might look at the RenderTableDataPlugin. The raw table data could be from a different topic, or hidden in HTML comments, or behind a Twisty.

-- GeorgeClark - 08 Jan 2012