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	11 Dec 2008 - 16:23
Item5977	Documentation needs example in SUM showing use in a form generated table.	Enhancement	New	02 Sep 2008 - 22:51	11 Dec 2008 - 16:23
Item5978	WIBNIF: CALC knew about formfield values and could use them in calculations	Enhancement	New	02 Sep 2008 - 22:54	11 Dec 2008 - 16:23
Item464	SpreadSheetPlugin doesn't support ^ in tables	Low	New	14 Dec 2008 - 15:00	14 Dec 2008 - 15:00
Item810	SpreadSheetPlugin doesn't allow breaking formulea over multiple lines	Enhancement	New	20 Jan 2009 - 02:48	20 Jan 2009 - 02:48
Item809	CALC TIMEADD month is wrong	Enhancement	Confirmed	20 Jan 2009 - 01:26	07 Feb 2009 - 21:08
Item1350	SpreadSheetPlugin's should accept strings in quotes and not see the quote as part of the string	Enhancement	Confirmed	22 Mar 2009 - 06:21	04 Jun 2009 - 00:27
Item8417	When using CALC in search, CALC in format will not be executed	Normal	Confirmed	24 Jan 2010 - 14:40	27 Jun 2010 - 07:10
Item9734	CALC's expansion behaviour should be more consistent with other macros when no table cells are addressed	Normal	Confirmed	21 Sep 2010 - 23:44	22 Sep 2010 - 05:27
Item8232	macros within ACTIONSEARCH	Normal	Confirmed	07 Aug 2009 - 06:36	24 Jan 2011 - 10:50
Item8237	comma and CALC	Normal	Confirmed	12 Aug 2009 - 07:41	13 Mar 2011 - 04:38
Item9343	Variation on TRIM to remove all spaces	Enhancement	New	16 Jul 2010 - 19:02	13 Mar 2011 - 04:39
Item8693	Add PPSpreadsheetExamples to SSP documentation	Enhancement	Confirmed	10 Mar 2010 - 15:23	14 Mar 2011 - 00:08
Item10907	Whitespace effecting delayed CALC in search results unexpectedly	Normal	Confirmed	21 Jun 2011 - 22:50	29 Jun 2011 - 01:25
Item11049	Specify table to be used in Spreadsheet CALC	Enhancement	New	17 Aug 2011 - 20:53	18 Aug 2011 - 01:45
Item11003	TIME* functions do not work properly with dates before 1970	Normal	New	27 Jul 2011 - 17:45	21 Nov 2011 - 10:09
Item1389	Semi Auto Test for SpreadSheetPlugin	Normal	Being Worked On	29 Mar 2009 - 23:08	12 Feb 2012 - 11:33

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