Question

1. Is there any way to have the SpreadSheetPlugin count rows (in a column) which are non-empty? I do not want to have sep. counts of individual items, but simply a total count of how many cells in that column/range are non-empty.
2. The SpreadSheetPlugin Topic talks of 'built-in' functions. Is there an easy way to add other functions to the plugin?
3. Is there a way to have the SpreadSheet Plugin 'insert' sub-total columns into a table based on the current sort-criterion whenever the content of that colum changes?

Example for #3:

if the table originally looks like this:

I would like it to be displayed as

if sorted by date, and as

if sorted by User.

• TWiki version: 01 Dec 2001
• Perl version: 5.6
• Web server & version:
• Server OS:
• Web browser & version:
• Client OS:

-- MathiasKoerber - 30 Dec 2002

Answer

1. There is no such function
2. You can easily add new functions to the Plugin, add them to sub doFunc in SpreadSheetPlugin. If you do, add a patch to the SpreadSheetPluginDev topic so that we can possibly roll it back into the distro.
3. You can construct formulas that refer to cells relative to the current position, use the $COLUMN() and $ROW() functions. It might be challenging to do what you want, I can't think of an easy way to do that.

-- PeterThoeny - 31 Dec 2002