SpreadSheetPlugin Development

This is the topic to discuss development of download SpreadSheetPlugin

help If you need support, go to Support.SpreadSheetPlugin where you can ask questions and find answers to previously asked questions. warning 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
Topic revision: r4 - 30 Mar 2009, KennethLavrsen
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy