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...
Installation |
Description | Computed |
|---|---|---|
| Total: 3 | Corporate: 3 | Corporate: 3 |
| Motorola, Global Software Group | Corporate | Corporate |
| Motorola, Semiconductor Products UK | Corporate | Corporate |
| Motorola, Semiconductor Products US | Corporate | Corporate |
Environment
| TWiki version: | Athens, Beijing |
| TWiki plugins: | twiki.org |
| Server OS: | |
| Web server: | |
| Perl version: | |
| Client OS: | |
| Web Browser: |
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
Topic revision: r7 - 2003-05-08 - PeterThoeny
Site map
Blog web
Create New Topic
Index
Search
Advanced search
My topics of interest
Changes
Major changes only
All tags
Notifications
RSS Feed
Statistics
Preferences
Community 
Readme first
Developers News
How you can help
Community roles
#twiki IRC
Lima Release
Feature Proposals
Bugs Changes
Categories 
Account 
Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.Copyright © 1999-2026 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.