Bug 97134 - COPY SPREADSHEET WITH CHECKBOXES
Summary: COPY SPREADSHEET WITH CHECKBOXES
Status: RESOLVED DUPLICATE of bug 47662
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-14 12:52 UTC by Tebog
Modified: 2016-01-14 20:49 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Tebog 2016-01-14 12:52:00 UTC 
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.
Comment 1 Tebog 2016-01-14 12:55:29 UTC 
Mistake, sorry! 

In the copied cells the reference is:
'2015'C1
'2015'C2
'2015'C3
...
Comment 2 Tebog 2016-01-14 12:57:13 UTC 
'2015'.C1
'2015'.C2
'2015'.C3
...
Comment 3 raal 2016-01-14 20:49:19 UTC 
Hello,

Thank you for submitting the bug. The bug has previously been reported, so this bug will be added as a duplicate of it. You will automatically be CCed to updates made to the other bug.

*** This bug has been marked as a duplicate of bug 47662 ***