You are here: Foswiki>Tasks Web>Item1072>SpreadSheetPlugin>Item5978 (04 Jan 2015, GeorgeClark)Edit Attach

Item5978: WIBNIF: CALC knew about formfield values and could use them in calculations

Priority: Enhancement
Current State: Confirmed
Released In: n/a
Target Release: n/a

Applies To: Extension
Component: SpreadSheetPlugin
Branches:

Reported By: TWiki:Main.MartinCleaver
Waiting For:
Last Change By: GeorgeClark

Here's my query:

 %SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $percntCALC{$SUM(R$ROW(0):C$COLUMN(-2)..R$ROW(0):C$COLUMN(-1))}$percnt  | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%

Would be much nicer to write:

%SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $percntCALC{$SUM($formfield(RevenueImpact) +$formfield(ReadershipImpact))}$percnt  | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%

%SEARCH{type="query" "RequirementsForm" excludetopic="NewRequirementTemplate" nosearch="on" format="| [[$topic][$formfield(Name)]] | $formfield(ReadershipImpact) | $formfield(RevenueImpact) | $CALC{$SUM($formfield(RevenueImpact) +$formfield(ReadershipImpact))}$$  | $formfield(BusinessPriority) | $formfield(ProgrammingComplexity) | $summary |" }%

[6:26pm] PeterThoeny__: $percntCALC{$SUM($formfield(RevenueImpact), $formfield(ReadershipImpact))}$percnt should be possible

http://koala.ilog.fr/twikiirc/bin/irclogger_log/twiki?date=2008-09-02,Tue

ItemTemplate edit

Summary	WIBNIF: CALC knew about formfield values and could use them in calculations
ReportedBy	TWiki:Main.MartinCleaver
Codebase
SVN Range	TWiki-5.0.0, Mon, 18 Aug 2008, build 17431
AppliesTo	Extension
Component	SpreadSheetPlugin
Priority	Enhancement
CurrentState	Confirmed
WaitingFor
Checkins
TargetRelease	n/a
ReleasedIn	n/a
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release01x01Checkins