SpreadSheetPlugin Development

This is the topic to discuss development of SpreadSheetPlugin

If you need support, go to Support.SpreadSheetPlugin where you can ask questions and find answers to previously asked questions. If you want to report a bug, or a feature request, go to Tasks.SpreadSheetPlugin where you can see already submitted issues and where you can submit a new bug report or feature request.

Active Items

Id	Summary	Priority	Current State	Creation Date	Last Edit
Item4798	TWiki variables such as CALC are not expanded inside formatted search if CALC is also used elsewhere on same line	Normal	Confirmed	11 Oct 2007 - 18:39	26 Nov 2007 - 01:12
Item809	CALC TIMEADD month is wrong	Enhancement	Confirmed	20 Jan 2009 - 01:26	07 Feb 2009 - 21:08
Item8693	Add PPSpreadsheetExamples to SSP documentation	Enhancement	Confirmed	10 Mar 2010 - 15:23	14 Mar 2011 - 00:08
Item464	SpreadSheetPlugin doesn't support ^ in tables	Enhancement	Confirmed	14 Dec 2008 - 15:00	04 Jan 2015 - 04:35
Item5978	WIBNIF: CALC knew about formfield values and could use them in calculations	Enhancement	Confirmed	02 Sep 2008 - 22:54	04 Jan 2015 - 04:36
Item13187	SpreadSheetPlugin needs error reporting	Enhancement	Confirmed	04 Jan 2015 - 05:19	04 Jan 2015 - 05:19
Item13658	HEXENCODE command in the SpreadSheetPlugin doesn't works with utf8 text	Low	Confirmed	01 Sep 2015 - 11:19	25 Sep 2016 - 15:19

Discussion

String Functions

Conspicuously absent from its list of string functions is something like substr() in Perl or PHP, or what MS Excel calls MID(): "returns a specific number of characters from a text string starting at the position you specify". Currently that takes two calls of $REPLACE().

I was also surprised to see that I can't $SET() a string with leading whitespace (e.g., '      23'), to create a columnar display in monospace font.

$SPLIT() would be nice to have too; or a Perl regexp with back-references, like the FilterPlugin's $EXTRACT but as an in-line function. E.g., (from TWiki:Blog.BlogEntry200810x8): "...the SpreadSheetPlugin is used to split the comma-separated predecessors into separate entries. But since its SUBSTITUTE can't handle commas, they first had to be TRANSLATEd into semi-colons. But in the end:

• • this: "| Node_x | Predecessor_1,Predecessor_2 |..."
  • becomes: "Predecessor_1 -> Node_x; Predecessor_2 -> Node_x"

-- SeanMorgan

The plugin has been extended with new features that addresses most of the needs above.

-- KennethLavrsen - 30 Mar 2009