Item8053: FormQuery is not picking up the final row of a table.

The FormQueryPlugin in TWiki 4.2.4 fails to pick up the final row in a table that it is searching.

For example the following search:

%FORMQUERY{ name="query1" topic="TestTopic" extract="TestTable"}% %QUERYTOCALC{ query="query1" format="|$Name|" }% %SHOWCALC{"$LISTSORT($LIST($ABOVE()))"}%

of this table:

Name
B
A
C
D

produces:

A, B, C

but does not pick up the D

---

This is an issue specific to QUERYTOCALC, which I didn't write. As far as I can tell, the spreadsheet plugin data is populated correctly.

Found it at long last. The row counter was always coming up one short.

-- CrawfordCurrie - 07 Apr 2009