<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 Macro name in Cell are converted to lowercase and macro is unknow"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109132">109132</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>VBA Macro name in Cell are converted to lowercase and macro is unknow
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</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>BASIC
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>bernard.schleich@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134646" name="attach_134646" title="Original MS Excel file with macros">attachment 134646</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134646&action=edit" title="Original MS Excel file with macros">[details]</a></span>
Original MS Excel file with macros
There are in fact 2 issues but very linked.
I have an Excel file (xlsm) that I open with Libre Office 4.3.7.2.
The file is opened correctly and the simple macro in it work correctly.
I save my work in ODS format because LibreOffice 4.3.7.2. can not save it in
XLSM format.
I have try later with version 5.2.7.2. and I have no problem to save my work
with macro in XSLM format.
The problem happens only when converting XLSM from ODS.
I continue to describe my problem ...
After saving my work in an ODS file, I reopen it and all the cells that
contains simple CUSTOM macro display a warning message daying that the name of
macro not exists !!!
In fact, in Original Excel the name is a mix of upper case and lower case and
is equal to "NrAlbums".
When loaded in LibreOffice the name is converted in "NRALBUMS" and the macro
continue to work correclty.
After saving the workbook in ODS file and open it again the name in cell's
formula is converted "nralbums" where all characters are converter to
lowercase. At this moment the macro is not more recognized.
This is the problem.
The first problem is that the orginal name in CELL is converted in UPPERCASE so
that original Microsoft macro name is not kept. The second problem is that when
LibreOffice load for a first time the new ODS file, the name is converted from
uppercase to lowercase.
The name in macro is always unchanged = "NrAblbums"
I hope that this can help you to improve LibreOffice!
This error is same that Bug ID 74656 but this bug is from 2015 and seems not to
be resolved.
I have explained why this error occurs and I hope that for this time it will be
possible to reproduce it on your development environment.
I have attached the original Excel XLSM file to you have the possiblity to test
what I have described.
Best regards</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>