The datapilot module don't works as expected when open an excel spreadsheet with a pivot table: when try to filter using the first record on a column (is not relevant which column or the sorting method) is possible to exclude that record but not to select it again.
If is clicked the "select all" then it works again.
As workaround I've find that flagging "Identify categories" make it works as expected, but when I save the spreadsheet in xls format I lost that setting.
I've found this problem on almost 3 different spreadshets in xls format, and is full reproducible both on Linux and on Windows.
I can't attach a copy of one of the file due to relevant and private datas on them
Created attachment 45270 [details]
ercolinux: Can you please try with the 3.4 beta if it still appears broken there? Thank you!
In 3.4 beta the datapilot works perfectly.
Closing as fixed in 3.4.
In 3.4 beta3 I've again the some problem (up to beta 2 it works).
It seems to be solved in 3.4.1
I'm glad to have finally fixed this!
The fix will be in 3.5.