We relaunched the TWiki.org project with an expanded TWiki charter, and we invite you to participate! The TWiki.org Code of Conduct agreement took effect on 27 Oct 2008. We ask existing twiki.org users to opt-in. You need to opt-in to participate in the Blog, Codev, Plugins and TWiki webs. -- PeterThoeny - 27 Oct 2008
Tags:
create new tag
, view all tags

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:

Date User Count
1 Jan 02 Hans 24
1 Jan 02 Peter 30
1 Feb 02 Hans 33
1 Feb 02 Peter 12

I would like it to be displayed as

Date User Count
1 Jan 02 Hans 24
1 Jan 02 Peter 30
1 Jan 02 Total 54
1 Feb 02 Hans 33
1 Feb 02 Peter 12
1 Feb 02 Total 45

if sorted by date, and as

Date User Count
1 Jan 02 Hans 24
1 Feb 02 Hans 33
Total Hans 57
1 Jan 02 Peter 30
1 Feb 02 Peter 12
Total Peter 42

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

Topic revision: r2 - 31 Dec 2002 - 22:36:00 - PeterThoeny
Support.CountNonEmptyRowsinSpreadSheetPlugin moved from Support.CountNonEmptyRowsinSpreadSheeyPlugin on 31 Dec 2002 - 22:34 by PeterThoeny - put it back
 
TWIKI.NET
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback