https://bugs.documentfoundation.org/show_bug.cgi?id=159608
Bug ID: 159608
Summary: PivotTables (and charts) behaving erratically
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ehar...@gmail.com
Description:
Okay, so I've been using LibreOffice for over a decade and I was a Microsoft
Excel User Expert (and trainer) before that. I've extensively tested this
issue, but I cannot figure out why it's happening. It has been happening
through several updates but only over the last year or so. Before that, these
workbooks I created and the related tables and charts worked fine for nearly 10
years. Here are the details.
I created a data table (named range on a separate sheet) and then I created a
PivotTable from the named range on another sheet (the report, if you will). In
addition to that, I created a graph that uses the PivotTable ranges as the Data
Ranges for the graph. Initially, everything looks great.
Issue #1: After saving the document, the Charts are completely messed up.
Issue #1.1 The data was appended to the Categories. Specifically, the
categories were dates and were all listed first with no graph data, then the
graph data was listed with blank categories. This happened to ALL the graphs in
the sheet in exactly the same way. So I went back into the Data Ranges for the
chart but they are all pointing to the correct data ranges with the correct
data in them. Clicking OK after checking changes nothing. FIX: Reselect the
exact same ranges and then click OK. Fixes the charts every time.
Issue #1.2: The Names of the Data Ranges are messed up. Specifically, the Names
are from several cells concatenated to each other. For example, if the Name was
supposed to be a person's name, say "Sam", the Name suddenly changes to "Sam
Jane Date". This all seems arbitrary, but looks like it is the data from
several adjacent cells. Again, checking the reference in Data Ranges shows that
the reference is pointing only to one cell and the correct cell. Nothing has
changed from when I originally input the reference. Again, clicking OK does
nothing but reselecting the same exact reference and then clicking OK does fix
the issue immediately.
Issue #2: The Filter on the PivotTable disappears. Specifically, whatever was
selected in the Filter remains as the data in the cell but the drop down list
goes away and the cell is just a normal cell. All the other drop down lists and
related functionality disappear as well: Data cannot be clicked, etc. All the
PivotTable formatting remains AND right clicking inside the table shows the
PivotTable menu. However, if you go back to Properties and try to recreate the
PivotTable, you get the warning that data exists and should you overwrite it?
Clicking YES will replace the PivotTable but now with a completely unusable
table (i.e., the PivotTable is now gone).
I cannot find the trigger for these errors. They have happened BEFORE I have
closed the document and AFTER saving the document. They have happened AFTER
reopening the document. I tried updating LibreOffice, closing the program
completely, rebooting, and then creating a brand new document and completely
recreating the document from scratch. After just a few minutes, the errors
happened again.
Steps to Reproduce:
1. Create a named range on a sheet with multiple columns of data
2. Create a PivotTable on a separate sheet referencing the named range
3. Create a Chart based on the PivotTable
4. I cannot figure out whether the PivotTable needs to be Filtered, mine is.
5. I cannot figure out what triggers the error. After working with the
workbook, adding additional sheets, saving, reopening, etc, the problems all
occur. Some occurred immediately after saving the document and before I had
even closed it.
Actual Results:
Already mentioned in the outline above
Expected Results:
Already mentioned in the outline above
Reproducible: Always
User Profile Reset: No
Additional Info:
Already mentioned in the outline above
--
You are receiving this mail because:
You are the assignee for the bug.
