This question about Not sure...: Answered

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

QuestionForm edit

Subject Not sure...
Extension SpreadSheetPlugin, RenderTableDataPlugin
Version Foswiki 1.1.3
Status Answered
Related Topics
Topic revision: r2 - 08 Jan 2012, GeorgeClark - This page was cached on 17 Jan 2018 - 05:10.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License