[Libreoffice-bugs] [Bug 131296] New: Macro for copying data from protected cells and then selecting a different sheet no longer works.

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: d.j.baran at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200311/fb7eac45/attachment.htm>