Bug: Search and SpreadSheetPlugin Problem

There appears to be some issue with using functions from the SpreadSheetPlugin in a formatted search. I was trying to use a spreadsheet calculation on the row retrieved from the search, but don't seem to get it to work. Of course, there is no problem using spreadsheet functions in the last row of the search.

See the test case below...

Test case

Consider the following query (the nop are there to prevent premature interpretation)...

<form action="%SCRIPTURLPATH%/search%SCRIPTSUFFIX%/%INCLUDINGWEB%/">
 <input type="hidden" name="scope" value="True" /> 
 <input type="hidden" name="regex" value="on" />
 <input type="hidden" name="web" value="Main" /> 
 <input type="text" name="search" size="32" />
 <input type="submit" value="Search" /> <br> 
 <input type="hidden" name="header" value="|*Installation*|*Description*|*More*|" />
 <input type="hidden" name="format" value="|[<nop>[$web.$topic][$formfield(<nop>TWikiInstalledAt)]] | $formfield(<nop>TypeOfOrganization) | %CALC{"$T(R$ROW():C$COLUMN(-1))" }% |" />

Type Motorola;Corporate into the form below. You will see that the spreadsheet calculation returns nothing (at least, nothing visible).

Extra question... the query

|*Installation*|*Description*|*Computed*|
%SEARCH{ "Motorola;Corporate;Firewalled" scope="true" regex="on" web="Main" nototal="on" nosearch="on" format="|[[$web.$topic][$formfield(TWikiInstalledAt)]] |$formfield(TypeOfOrganization) | $percntCALC{\"$T(R$ROW():C$COLUMN(-1))\"}$percnt |" }%

appears to be the same as above, but produces even more unsuspected results...

Environment

-- ThomasWeigert - 06 May 2003

Follow up

On search with form & search script:

The search script is built for speed, e.g. it outputs search hit by search hit while the search is going on, so that the browser can start rendering the result quickly. That is why you do not see a correct evaluation of the formula. A formatted search that is embedded (a SEARCH) does render the result in memory, e.g. it is slower but supports regular formatting, as with CALC.

As a workaround you can create a topic that has a SEARCH with embedded URLPARAM. From your form you can call that topic. An example in action is TWikiInstallation.

On embedded SEARCH:

There are two bugs in your example. You need to "defuse" the CALC or it gets executed before the SEARCH, e.g. use $percnt instead of %, use \" or $quot instead of ". I fixed above example. Read the details in FormattedSearch.

No fix planned because of above reasons.

-- PeterThoeny - 07 May 2003

Fix record