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
Created attachment 139082 [details] The database I mention in the report.
Created attachment 139083 [details] The calc sheet In mention
Just to be crystal clear, I'm running Version: 5.4.4.2 Build ID: 1:5.4.4~rc2-0ubuntu0.17.10.1~lo1 CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: en-GB (en_GB.UTF-8); Calc: group THis used not to happen. I'm not sure when the behavioiur changed, but sometime in the last 6 months or so (I found it in a sheet I use for tax calculations, so I don't access it frequently, but it needs to be correct).
For me doesn't crash with: Version: 5.4.4.2 (x64) Build ID: 2524958677847fb3bb44820e40380acbe820f960 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale: es-ES (es_ES); Calc: group but gives the 'Error creating the pivot table' It not should be, and doesn't happen with a source in the spreadsheet.
(In reply to m.a.riosv from comment #4) > For me doesn't crash with: > Version: 5.4.4.2 (x64) > Build ID: 2524958677847fb3bb44820e40380acbe820f960 > CPU threads: 4; OS: Windows 6.19; UI render: default; > Locale: es-ES (es_ES); Calc: group > > but gives the 'Error creating the pivot table' > > It not should be, and doesn't happen with a source in the spreadsheet. That's what I said - it doesn't crash, but gives the error message.
In 6.0.0.3 it's OK - it now returns "(empty)" as it should. This report can be closed.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This is fixed (as I said previously, but I don't like changing the status without confirmation). I'm now on version: Version: 6.1.4.2 Build ID: 1:6.1.4-0ubuntu0.18.10.1 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: x11; Locale: en-GB (en_GB.UTF-8); Calc: group threaded