Item1995: Spreadsheet Plugin $RIGHT() broken
Priority: Normal
Current State: Duplicate
Released In: n/a
Target Release: n/a
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.