You are here: Foswiki>Tasks Web>Item810 (05 Jul 2015, GeorgeClark)Edit Attach

Item810: SpreadSheetPlugin doesn't allow breaking formulea over multiple lines

pencil
Priority: Enhancement
Current State: Closed
Released In: 2.0.0
Target Release: major
Applies To: Extension
Component: SpreadSheetPlugin
Branches:
Reported By: SvenDowideit
Waiting For:
Last Change By: GeorgeClark
so you can't replace
%CALC{"$SET(show_from_number, $MIN($TIMEADD($TIME($FORMATTIME($TIME(), $year-$month-1)),-1,month), $TIMEADD($TIME($FORMATTIME($TIME(%URLPARAM{showfrom}%), $year-$month-15)), 3, month)))"}%
with
%CALC{"$SET(
    show_from_number, 
    $MIN(
        $TIMEADD(
          $TIME(
            $FORMATTIME($TIME(), $year-$month-1)),
            -1,month
        ), 
        $TIMEADD(
          $TIME(
            $FORMATTIME($TIME(%URLPARAM{showfrom}%), 
            $year-$month-15)
          )
        , 3, month)
     )
)"}%

or something that would work easier for the writer (i don't know a good style, but atm, we prevent one

-- SvenDowideit - 20 Jan 2009

I think that this is fixed for 1.2, now that the %CALCULATE macro is implemented as a registered tag.

-- GeorgeClark - 04 Jan 2015

ItemTemplate edit

Summary SpreadSheetPlugin doesn't allow breaking formulea over multiple lines
ReportedBy SvenDowideit
Codebase 1.0.0
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component SpreadSheetPlugin
Priority Enhancement
CurrentState Closed
WaitingFor
Checkins
TargetRelease major
ReleasedIn 2.0.0
CheckinsOnBranches
trunkCheckins
masterCheckins
ItemBranchCheckins
Release01x01Checkins
Topic revision: r3 - 05 Jul 2015, GeorgeClark
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy