Bug 153238 - Unsupported VBA macro method keeps throwing error
Summary: Unsupported VBA macro method keeps throwing error
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
7.4.4.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency tree / graph
 
Reported: 2023-01-27 09:17 UTC by Paolo
Modified: 2023-05-21 10:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file (26.78 MB, application/vnd.ms-excel)
2023-03-24 14:50 UTC, Buovjaga 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Paolo 2023-01-27 09:17:29 UTC 
Hello,
I'd like to open the wonderful spreadsheet Imm made for us astrophotographers. Since the file is big (30 MB), I'll leave the link here:
- https://garyimm.com/compendium
You can find the download button at the bottom right.

As Imm wrote, this is a very complex spreadsheet and, as such, it may not really work with anything else than MS Office.

The issue I'm facing is that upon opening the document using calc, LO base also opens throwing warnings and errors. I have to pkill the process to quit it. The document never loads in Calc.


Tech info:
- openSUSE Tumbleweed (GNOME) on x86_64
- LO 7.4.4.2

Thanks a lot!
Comment 1 Buovjaga 2023-03-24 14:50:30 UTC 
Created attachment 186190 [details]
Example file
Comment 2 Buovjaga 2023-03-24 14:53:04 UTC 
It keeps throwing (VBA) macro errors:
BASIC syntax error.
Label $(ARG1) already defined.

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 676602a1a4e53e88d9f4664579497d534f6ae9c2
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded