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 - This page was cached on 30 Aug 2016 - 11:24.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License