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