Item8237: Comma, newline and parenthesis supported using new tripple-quote syntax.

Priority: Normal
Current State: Closed
Released In: 2.0.0
Target Release: major
Applies To: Extension
Component: SpreadSheetPlugin
Reported By: HolgerHain
Waiting For:
Last Change By: GeorgeClark
%CALC% seems to have a problem with values that have a "," inside. I often use %CALC{$IF(condition,var1,var2)}% to filter the output of a %SEARCH%. If the condition is false and var1 contains a "," then the part after the "," of var1 is printed. Thats a big mess for tabels, because the numbers of rows is usually to low (just half of the output). Most of the time I try to use the function in with an output only of condition is wrong and var1="". That works if I want to have a simple decision "ouput or no output", but it´s a problem for "output1 or output2".

So there should be a feature that I can prevent var1 to be literaly put into the $IF()-function, so the "," is not interpreted by this function.

This problem my be related to Item411

-- HolgerHain - 12 Aug 2009

Indeed it does. Confirmed.

-- CrawfordCurrie - 08 Sep 2010

Fixed in 1.2. Strings with comma, newline and parenthesis should be triple-quoted with single quotes.

-- GeorgeClark - 04 Jan 2015

ItemTemplate edit

Summary Comma, newline and parenthesis supported using new tripple-quote syntax.
ReportedBy HolgerHain
Codebase 1.0.5
SVN Range Foswiki-1.0.0, Thu, 08 Jan 2009, build 1878
AppliesTo Extension
Component SpreadSheetPlugin
Priority Normal
CurrentState Closed
TargetRelease major
ReleasedIn 2.0.0
Topic revision: r7 - 05 Jul 2015, GeorgeClark - This page was cached on 13 Feb 2017 - 22:29.

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