Item1374: Add New New $EMPTY(), $LEFTSTRING(), $RIGHTSTRING(), SUBSTRING(), $INSERTSTRING() functions to SpreadSheetPlugin

Priority:	CurrentState:	AppliesTo:	Component:	WaitingFor:
Enhancement	Closed	Extension	SpreadSheetPlugin

SpreadSheetPlugin in the (tm)wiki will soon be released with New New $EMPTY(), $LEFTSTRING(), $RIGHTSTRING(), SUBSTRING(), $INSERTSTRING() functions

We should add this to remove an excuse why you cannot upgrade to Foswiki

And besides they are useful features.

And the code is easy to port over - with an extra security audit naturally.

I will also raise a feature proposal

REF TWikibug:Item6222

-- KennethLavrsen - 26 Mar 2009

Code added assuming approval of SpreadSheetPluginFourNewFunctions

I implemented the new functions but changed the code to be compatible in normal cases but better behaving in the exception cases.

The code uses same eval format as rest of plugin.

This is to suppress code barfing when formulars have bad in-data.

The use of eval is safe as long as the string is within single quotes.

I wanted this update ready to compete with the other project and they release now.

-- KennethLavrsen - 29 Mar 2009