https://bugs.documentfoundation.org/show_bug.cgi?id=114991
Bug ID: 114991
Summary: Pivot tables where there is no data don't update the
table, leaving old and incorrect values
Product: LibreOffice
Version: 5.4.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have a pivot table in a calc document accessing a query in a base database
(HSQLDB). When the query returns data all is well. When the query returns no
data the pivot table does not clear the old data out. It used to return
"(empty)" in the first cell, and clear the data.
Steps to Reproduce:
1. Open both the pivotDatabase and the pivotcalc documents
2. In pivotDatabase edit Query1 and in the criterion set the value to 1 for F1
3. Refresh the pivot in pivotcalc
4. You should see one row with f1 = 1
5. Now edit Query1 to set the criterion for f1 to 11
6. Refresh the pivot in pivotcalc
Actual Results:
On step 6 I get an error message "Error creating the pivot table"
Expected Results:
On step 6 I would expect no error, and an (empty) word in A1.
Reproducible: Always
User Profile Reset: No
Additional Info:
By leaving old and incorrect data when the result should be an empty dataset,
other sheets that depend on getting correct or null data in the pivot are
fooled into thinking there is real data, when there is not.
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/62.0.3202.97 Safari/537.36 Vivaldi/1.94.1008.40
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
