[Libreoffice-bugs] [Bug 139786] New: VBA code modified while saving to .xls format - no longer works in Excel

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139786
           Summary: VBA code modified while saving to .xls format - no
                    longer works in Excel
           Product: LibreOffice
           Version: 5.0 all versions
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jluth at mail.com

Created attachment 169051
  --> https://bugs.documentfoundation.org/attachment.cgi?id=169051&action=edit
disable-vba-refactoring.oxt: a simple extension prevent VBA being changed by
LO. Sets VBA - UseExport to false.

If you round-trip attachment 109955 in 6.4, Excel will complain about the VBA
code on load.

This was working until LO 6.4 change by author  Serge Krot on 2020-06-09
10:34:32
commit  577dd32b1c4eb0a4cff574fbabca987cb52b831b
    tdf#106181 XLSX export: output form controls

    Prepared general algorithm to ouput form controls into XLSX.
    For now only CHECKBOX is supported with a possibility to
    link withem to any worksheet/cell.

To replicate:
1.) Go to Expert configuration under advanced settings and change Calc - Filter
- Import - VBA - UseExport to false.  (This prevents LO from making any changes
to the VBA code - which is essential to it still working in Excel.)
2.) Open attachment 109955 (ignore the macros) and save. A dialog box will
inform you that no changes were made to the VBA code.
3.) Open the round-tripped file in Microsoft Excel. In 6.3 it only warned once
about dangerous code. In 6.4 it warns twice - the second one about unreadable
content.

I personally tested with Excel 2010. I also round-tripped using LO 7.2 and the
problem still exists in master.

-- 
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/20210120/673d5ddd/attachment.htm>