New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
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 11 Mar 2018 - 02:57.

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