https://bugs.documentfoundation.org/show_bug.cgi?id=131296
Bug ID: 131296
Summary: Macro for copying data from protected cells and then
selecting a different sheet no longer works.
Product: LibreOffice
Version: 7.0.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: d.j.ba...@frontier.com
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
