Item10539: RIGHT() has wrong result due to incorrect start cell

Priority: Normal
Current State: No Action Required
Released In: n/a
Target Release: n/a

Applies To: Extension
Component: SpreadSheetPlugin
Branches:

Reported By: WillNorris
Waiting For: Main.WillNorris
Last Change By: WillNorris

The $RIGHT() function uses the cell to the left instead of the right. Test case using %CALC{$SUM($RIGHT())}% in the middle row:

1	2	7 =>	3	4
5	6	15 =>	7	8

Expected middle row values: 7 and 15, respectively. (With bug it is 9 and 21, respectively.)

Here is a %CALC{$SUM($LEFT())}% function for comparison in the middle row:

1	2	<= 3	3	4
5	6	<= 11	7	8

Expected middle row values: 3 and 11, respectively.

nevermind, we already fixed this months and months ago...

-- WillNorris - 25 Mar 2011

Summary	RIGHT() has wrong result due to incorrect start cell
ReportedBy	WillNorris
Codebase
SVN Range
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Normal
CurrentState	No Action Required
WaitingFor	WillNorris
Checkins
TargetRelease	n/a
ReleasedIn	n/a

Topic revision: r1 - 25 Mar 2011, WillNorris

Quick Links

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement.