You are here: Foswiki>Tasks Web>Item1994 (05 Jan 2015, GeorgeClark)Edit Attach

Item1994: Spreadsheet Plugin $RIGHT() broken

pencil
Priority: Normal
Current State: No Action Required
Released In: n/a
Target Release: n/a
Applies To: Extension
Component: SpreadSheetPlugin
Branches:
Reported By: RaymondLutz
Waiting For:
Last Change By: GeorgeClark
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.

ItemTemplate edit

Summary Spreadsheet Plugin $RIGHT() broken
ReportedBy RaymondLutz
Codebase 1.0.6
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState No Action Required
WaitingFor
Checkins
TargetRelease n/a
ReleasedIn n/a
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release01x01Checkins
Topic revision: r2 - 05 Jan 2015, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy