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] test spreadsheet
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. Well done
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! http://cgit.freedesktop.org/libreoffice/core/commit/?id=7352c717a307c46f0f1825375597fbe44b816ba5 The fix will be in 3.5.