Item8232: Macros within ACTIONSEARCH not possible due to SpreadSheetPlugin processing order.

I tried to format the output of an actionsearch. I both tried the %IF% and the %CALC% macro to display text in a custom color, like it is possible for the formated output of a normal search.

-- HolgerHain - 07 Aug 2009

I tracked down the real problem. All variables such as $who and $due ... are not accesible to i.e. %CALC%. So a formula such as %CALC{$SET(my_var,$who)$GET(my_var)}% will work properly, but any other operation such as $FIND or $IF does not work. -- Sorry, that was my fault. I forgot to use "$percnt" instead of "%" (to figure out any problems with the %CALC%-syntax).

But anyway there must be some problem with getting the variables with %CALC%. To get actions that are orphaned (there is who="") it is not possible to use a regex that searches for an empty string, so the idea was to use %CALC% to format the output. But the test

 format="$percntCALC{$SET( my_var , $who )}$percnt $percntCALC{$SEARCH( Main , $GET( my_var ) )}$percnt"

it just get ")" as output.

I get basically the same with an $IF searching for a specific $due-value (as reported some days ago) to change the text-color.

-- HolgerHain - 11 Aug 2009

This is an old problem with CALC, because of the way it works out of sequence with everything else. Not an actiontracker problem. Re-assigning to the SpreadSheetPlugin.

-- CrawfordCurrie - 24 Jan 2011

I suspect that this is fixed by addition of the %CALCULATE macro, which is processes as a regular registered tag.

-- GeorgeClark - 04 Jan 2015

Commenting is disabled while not logged in