Item8237: comma and CALC

Priority:	CurrentState:	AppliesTo:	Component:	WaitingFor:
Normal	Confirmed	Extension	SpreadSheetPlugin

%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