[Libreoffice-bugs] [Bug 109132] New: VBA Macro name in Cell are converted to lowercase and macro is unknow

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 109132
           Summary: VBA Macro name in Cell are converted to lowercase and
                    macro is unknow
           Product: LibreOffice
           Version: 5.2.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bernard.schleich at gmail.com

Created attachment 134646
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134646&action=edit
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

-- 
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/20170715/ce913a8b/attachment.html>