https://bugs.documentfoundation.org/show_bug.cgi?id=154197
Stéphane Guillou (stragu) <stephane.guil...@libreoffice.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jl...@mail.com, | |stephane.guillou@libreoffic | |e.org Blocks| |103381 Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Keywords| |implementationError See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=11 | |8117 URL| |https://ask.libreoffice.org | |/t/counting-valid-or-missin | |g-cell-data-based-on-other- | |column/89239/4 --- Comment #1 from Stéphane Guillou (stragu) <stephane.guil...@libreoffice.org> --- I can see the issue in the attachment: Steps: 1. Right-click on existing pivot table > Properties... Result: nothing in "Column Fields" nor in "Data Fields". However, if you right-click > Refresh the pivot table, the values update and are calculated properly! If I recreate the pivot table in 7.3.7.2 with: 1. Select 3 columns 2. Data > Pivot table > Insert of edit... > OK 3. Drag "Continent" into "Row Fields" 4. Drag "Data2" into "Data Fields", double-click it to change to "count" 5. Click OK 6. Right-click on new pivot table > Properties... Result: the properties are still there, works as expected. Tested in: Version: 7.3.7.2 / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded So the issue is that pivot tables created in a version prior to the fix for bug 118117 result in *functioning* properties that are not displayed in the dialog in later versions. Justin, what do you think? Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=103381 [Bug 103381] [META] Pivot table (aka Data Pilot) bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.