https://bugs.documentfoundation.org/show_bug.cgi?id=97134
Bug ID: 97134
Summary: COPY SPREADSHEET WITH CHECKBOXES
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
THE SITUATION:
I have a sheet called "2015".
In row "A" are listed the month of the year ( A1 Jan; A2 Feb ...)
In row "B" are numbers that have to be summarized in the end ( B13 )
In row "C" there are checkboxes that are bound to the field they are in ( C1;
C2;..)
The sum in "B" depends on the checkboxes, whether they ar "on" or "off". (sumif
...)
THE PROBLEM:
If I copy the sheet and rename it to "2016" the checkboxes are still bound to
"2015" because in the "linked cell" there is not only "C1"; "C2"; ... to be
found, but "'2015'.C1";"'2016'.C1"; ... and so on.
That is quite uncomfortable because I have to correct every single checkbox.
Thank you for considering to change that behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
