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.

Reply via email to