[Libreoffice-bugs] [Bug 135820] New: bad pivot table sheet relative reference auto-correction

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135820
           Summary: bad pivot table sheet relative reference
                    auto-correction
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jnqnfe at gmail.com

Description:
i tried removing the sheet name from source and destination references of a
pivot table to see if relative referencing was supported, and thus creating new
sheets by copying existing ones could be done without then having to edit the
pivot tables.

unlike with editing chart cell references, no red warning icon was displayed,
suggesting that relative references are supported. (bug?).

when i did this with a pivot table in the first sheet of the document: on
closing the dialog (with 'okay') and reopening it, the 'destination' reference
had been automatically modified to re-introduce the sheet name. the same had
also been done for 'source', except incorrectly referring to the second sheet
rather than the first (the sheet containing it) for some reason.

when i try the same with a pivot table on other sheets, upon clicking 'okay' in
the dialog, the pivot table gets moved to the first sheet, with 'destination'
always obviously changed to refer to the first sheet, and 'source' always
changed to refer to the second sheet.

Actual Results:


Expected Results:
either a red warning icon should be displayed with use of references lacking a
sheet name being blocked, or alternatively, it should be putting the sheet name
of the current sheet (containing the pivot table).


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.1.1.0+
Build ID: <buildversion>
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.utf8); UI: en-GB
Debian package version: 1:7.0.1_rc1-1
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200817/d5a1a264/attachment-0001.htm>