[Libreoffice-ux-advise] [Bug 135825] PIVOTTABLE: unintuitive referencing in copying sheets

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Apr 6 14:04:44 UTC 2021


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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #3 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
The source of the pivot table is $Sheet1.$A$1:$B$5 to deal with the fact that
it usually goes into another sheet. Destination is $Sheet1.$A$10 or so, and we
have to modify this on copy/move.

What I could imagine in case of pivot tables on the same sheet, is to drop this
part from the source and use just $A$1:$B$5. But for some reason changing this
on Sheet1 seems to be possible manually but does actually inserts Sheet1_2.

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


More information about the Libreoffice-ux-advise mailing list