• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use

Item7848 for generic doc work for TWiki-6.1.1. Use

Item7851 for doc work on extensions that are not part of a release. More... Close
• Anything you create or change in standard webs (Main, TWiki, Sandbox etc) will be automatically reverted on every SVN update.
• Does this site look broken?. Use the LitterTray web for test cases.

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

Item Form Data

AppliesTo:	Component:	Priority:	CurrentState:	WaitingFor:	TargetRelease	ReleasedIn
Extension	SpreadSheetPlugin	Normal	Closed		patch	5.0.2

Detail

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.

-- TWiki:Main/PeterThoeny - 2011-03-25

This is now in SVN trunk and 5.0 branch.

-- TWiki:Main.PeterThoeny - 2011-03-25

ItemTemplate
Summary	RIGHT() has wrong result due to incorrect start cell
ReportedBy	TWiki:Main.PeterThoeny
Codebase	5.0.1, ~twiki4
SVN Range	TWiki-5.0.1, Tue, 11 Jan 2011, build 20174
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Normal
CurrentState	Closed
WaitingFor
Checkins	TWikirev:20774 TWikirev:20775 TWikirev:20776 TWikirev:20777
TargetRelease	patch
ReleasedIn	5.0.2

Raw edit | More topic actions

Topic revision: r8 - 2011-05-07 - PeterThoeny

Account
- Log In

Edit
Attach

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

Item Form Data

Edit Form Data

Detail