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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
