• 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.

Item6866: New CALCULATE variable using the register tag handler for variable evaluation with proper inside-out, left-to-right eval order

Item Form Data

AppliesTo: Component: Priority: CurrentState: WaitingFor: TargetRelease ReleasedIn
Extension SpreadSheetPlugin Enhancement Closed   patch 5.1.2

Edit Form Data

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


The SpreadSheetPlugin currently uses the commonTagsHandler to handle the CALC variable, not the registerTagHandler. This is needed because registered tags cannot access topic content surrounding the CALC, which is needed for spreadsheet calculations in tables. As a disadvantage, the CALC variable is evaluated after other variables, e.g. not inside-out & left-to-right like other variables that use the register tag handler.

This enhancement adds a new CALCULATE variable that uses the registerTagHandler. This ensures that the variable is evaluated inside-out & left-to-right like regular variables. As a disadvantage, the CALCULATE variable cannot handle functions that refer to table cells, such as $LEFT() or $T().

At a later point when the TWiki API for tag handlers supplies the text preceding and following the tag, the CALCULATE variable can be enhanced to support also functions that refer to table cells. At that time, the CALC variable can be deprecated.

-- TWiki:Main/PeterThoeny - 2012-04-05

This is now in SVN trunk and 5.1 branch.

-- TWiki:Main/PeterThoeny - 2012-04-05

Summary New CALCULATE variable using the register tag handler for variable evaluation with proper inside-out, left-to-right eval order
ReportedBy TWiki:Main.PeterThoeny
Codebase ~twiki4, 5.1.1
SVN Range TWiki-5.1.1-trunk, Tue, 03 Apr 2012, build 22774
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Closed

Checkins TWikirev:22780 TWikirev:22781 TWikirev:22782 TWikirev:22783 TWikirev:22784 TWikirev:22785 TWikirev:22786 TWikirev:22787 TWikirev:22788 TWikirev:22789
TargetRelease patch
ReleasedIn 5.1.2
Edit | Attach | Watch | Print version | History: r14 < r13 < r12 < r11 < r10 | Backlinks | Raw View |  Raw edit | More topic actions
Topic revision: r14 - 2012-10-07 - PeterThoeny
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback