Item1995: 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.

Example:

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

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

The correct answer above, is 6 and 48 and not 7 and 56.

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.