[Bug 162417] PIVOTTABLE: Warning does not show range when overwriting destination range contents

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=162417

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|needsUXEval                 |
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|libreoffice-ux-advise at lists |erack at redhat.com,
                   |.freedesktop.org            |heiko.tietze at documentfounda
                   |                            |tion.org

--- Comment #28 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
We discussed the topic in the design meeting.

The issue boils down to whether new data should be added as hidden when a
filter is applied to PT. Some users may expect the Excel workflow, some the
opposite and current LibreOffice way (which by the way is more safe as one may
forget to update the filter).

Side note: The same function is effective for autofilter, but in this case
users should see that adding new data are really accepted. In fact both Excel
and LibreOffice do show data but add the new value as disabled item to the AF.

Regardless this inconsistency we suggest to add an option "[x] Enable new items
in autofilter", defaulting to on, at the PT filter widget. The option needs to
be stored with the document, which might be difficult to implement.

And it's very unclear why PT should become overwritten at all and we suggest to
just inform the user about the insufficient space (again a safety measure).
This should be done with an advanced option to confirm, meaning to get the
current behavior again.

Adding Eike as Calc expert to review the considerations.

-- 
You are receiving this mail because:
You are on the CC list for the bug.