Item1997: Spreadsheet Plugin $RIGHT() and $LEFT() are broken

SpreadSheetPlugin $RIGHT() function is supposed to return the range of cells to the right of the current cell. Unfortunately, it returns cells to the left as well.

Test of RIGHT:

Col 3 below contains the expression: %CALC{"$SUM($RIGHT())"}%

Col 1	Col 2	Col 3	Col 4	Col 5
1	2	12	4	8
16	32	192	64	128

The correct answers are 12 and 192.

Test of LEFT:

Col 3 below contains the expression: %CALC{"$SUM($LEFT())"}%

Col 1	Col 2	Col 3	Col 4	Col 5
1	2	3	4	8
16	32	48	64	128

The correct answers above, are 3 and 48.

Clearly, this is an important bug to fix as people assume the spreadsheet plugin will be bug free.

Suggestion

Enhance $RIGHT() and $LEFT() to accept a value which is the number of cells to the right or left to include. For example $LEFT(2) would include the two cells to the left and no more.

PATCH

See Item1998

NOTE: I've marked this no action required because despite the title, this item shows (as per test case for LEFT above) that LEFT is not broken. Only RIGHT is, so this is a duplicate of Item1998.

-- DarrylGreen - 08 Aug 2010