[Libreoffice-bugs] [Bug 140475] New: Macro using Range processing failed to work after File Save

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 140475
           Summary: Macro using Range processing failed to work after File
                    Save
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: aist0298 at gmail.com

Description:
Calc can open an Excel xlsm file with Range macro, and work normally. However,
after Save locally, Close the file and re-Open in Calc, the macro does not
function any more.

Steps to Reproduce:
1.File Open the attached EXCEL file with Range processing macro and Enable
macro
2.Check the value of both the Cell A2 and the Cell B2 change when active cell
switching around A4,A5 and A6, which meaning the macro works normally. 
3.Save the file -> Close the file -> re-Open the file in Calc

Actual Results:
The macro in the saved file fails to work.

Expected Results:
the value of both the Cell A2 and the Cell B2 change when active cell switching
around A4,A5 and A6, as I open the Excel generated file the first time.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

-- 
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/20210217/7793bde8/attachment.htm>