• Do not register here on develop.twiki.org, login with your twiki.org account.
• Use View topic Item7848 for generic doc work for TWiki-6.1.1. Use View topic 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

Edit Form Data

Reported By:
Applies To:
Current State:
Waiting For:
Target Release:
Released In:


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

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

Checkins TWikirev:20774 TWikirev:20775 TWikirev:20776 TWikirev:20777
TargetRelease patch
ReleasedIn 5.0.2
Edit | Attach | Watch | Print version | History: r8 < r7 < r6 < r5 < r4 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r8 - 2011-05-07 - PeterThoeny
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback