<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - VBA code modified while saving to .xls format - no longer works in Excel"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139786">139786</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>VBA code modified while saving to .xls format - no longer works in Excel
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.0 all versions
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Writer
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jluth@mail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=169051" name="attach_169051" title="disable-vba-refactoring.oxt: a simple extension prevent VBA being changed by LO. Sets VBA - UseExport to false.">attachment 169051</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=169051&action=edit" title="disable-vba-refactoring.oxt: a simple extension prevent VBA being changed by LO. Sets VBA - UseExport to false.">[details]</a></span>
disable-vba-refactoring.oxt: a simple extension prevent VBA being changed by
LO. Sets VBA - UseExport to false.
If you round-trip <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=109955" name="attach_109955" title="running two copies of this will exit when you activate the macro-attached cells">attachment 109955</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=109955&action=edit" title="running two copies of this will exit when you activate the macro-attached cells">[details]</a></span> 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
<a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FILESAVE: Check boxes get lost when saving as .XLSX"
href="show_bug.cgi?id=106181">tdf#106181</a> 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 <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=109955" name="attach_109955" title="running two copies of this will exit when you activate the macro-attached cells">attachment 109955</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=109955&action=edit" title="running two copies of this will exit when you activate the macro-attached cells">[details]</a></span> (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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>