[Libreoffice-bugs] [Bug 131317] New: BUTTON WITH MACRO IN CALC HAS TO BE PUSHED TWICE TO DO ALL THE WORK.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=131317

            Bug ID: 131317
           Summary: BUTTON WITH MACRO IN CALC HAS TO BE PUSHED TWICE TO DO
                    ALL THE WORK.
           Product: LibreOffice
           Version: 6.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: romrodz77 at outlook.com

Description:
If I run a macro via a button, I have to press it 2 or more times to get all
the macro done. If you do it via the macro editor, it works flawlessly.
I have attached a .ods with an example.

It deletes the cell value on some columns and then pastes the value from the
"master" colum. The first time you press the button, it just deletes
everything. The second or third time, it normally finishes the work.

Steps to Reproduce:
1. Open the attachment
2. Push the button. Everything will be deleted as it should.
3. Push the button another time (or more). It pastes the numbers as it should
4. Repeat it via the macro editor. It works from the firs time.

Actual Results:
After pushing the button once, it deletes the values in the columns with a pink
cell above.
After the second or third time, you see that it pastes the value from the "DA"
column.

Expected Results:
After pushing the button 1, it should have deleted the values and restore them.

Running the macro via the macro editor works just fine.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
It may be related to this bug:
https://bugs.documentfoundation.org/show_bug.cgi?id=70883
The first line of the macro is the "workaround" suggested in this bug report.

Also, if you clic on a random cell after pushing the button you may have the
expected result from the first time.

Versión: 6.4.1.2 (x64)
Id. de compilación: 4d224e95b98b138af42a64d84056446d09082932
Subprocs. CPU: 8; SO: Windows 10.0 Build 18363; Repres. IU: GL; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: CL

-- 
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/20200312/6d8928cc/attachment-0001.htm>