<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Macro for copying data from protected cells and then selecting a different sheet no longer works."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131296">131296</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Macro for copying data from protected cells and then selecting a different sheet no longer works.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>d.j.baran@frontier.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The macro copies specific data from protected cells in one sheet, and then
selects
a second sheet (changes focus) for pasting the data. This has worked well in
multiple earlier releases. In Alpha 7.0.0.0, the correct cells are not copied,
and the second sheet is not selected.
It seems the wrong cells are copied and then an attempt is made to past them
into the same sheet (not the one specified in the macro). This results in a
"Protected cells can not be modified." message.
Steps to Reproduce:
1.Open the attached file.
2.Click the "Insert Time" macro button.
3.Click the "Insert Time" button again.
4.Click the "End of Day" macro button.
Focus should jump to Sheet2 and insert zero time values (since less than a
minute accrued).
Actual Results:
Focus does not change to Sheet2.
Wrong cells were copied and then an attempt was made to paste them into Sheet1
(wrong sheet)
Expected Results:
Focus should jump to Sheet2 and insert zero time values (since less than a
minute accrued).
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: c63148ba139bd6b9ae7a0f9e24e51f29e5370963
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>