Item1996: Spreadsheet Plugin $RIGHT() 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 2 below contains the expression: %CALC{"$SUM($RIGHT())"}%

Col 1	Col 2	Col 3	Col 4
1	6	2	4
8	48	16	32

The correct answers above, are 6 and 48 and not 7 and 56.

Test of LEFT:

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

Col 1	Col 2	Col 3	Col 4
1	2	4	4
8	16	32	32

The correct answers above, are 3 and 24 and not 7 and 56.

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.

Marked this as No Action (duplicate).....

-- DarrylGreen - 08 Aug 2010