Bug 165216 - excel macro file refuses to open, constantly throws error if macros enabled
Summary: excel macro file refuses to open, constantly throws error if macros enabled
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-02-12 11:46 UTC by johnks
Modified: 2025-12-19 10:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
zip containing problematic file (7.82 MB, application/zip)
2025-02-12 11:46 UTC, johnks 		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 johnks 2025-02-12 11:46:30 UTC 
Description:
attached excel file that has macros. libreoffice calc has macros enabled and trusted locations for that folder where file is located.
the file throws endless errors before opening. in excel the file is opening correctly.
file is in zip format straight from governnment website

Steps to Reproduce:
1. set macros open to all, enable trusted locations of file so macros run
2. try to open file
3.

Actual Results:
file throws 
unexpected symbol:address
end/endif without if.
unexpected symbol: (.
expected: node.
unexpected symbol:,.
unexpected symbol: address
end/endif without if.

and errors in loop. the only way to get out is to kill task from task manager

Expected Results:
file should open, macros should work like they work in excel


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 17763); UI render: Skia/Raster; VCL: win
Locale: en-IN (en_IN); UI: en-US
Calc: CL threaded
Comment 1 johnks 2025-02-12 11:46:57 UTC 
Created attachment 199165 [details]
zip containing problematic file
Comment 3 Buovjaga 2025-10-26 17:52:29 UTC 
(In reply to m_a_riosv from comment #2)
> https://help.libreoffice.org/latest/en-US/text/sbasic/shared/
> compatibilitymode.html?DbPAR=BASIC#N0103

John: does this help?
Comment 4 johnks 2025-12-19 09:46:46 UTC 
(In reply to Buovjaga from comment #3)
> (In reply to m_a_riosv from comment #2)
> > https://help.libreoffice.org/latest/en-US/text/sbasic/shared/
> > compatibilitymode.html?DbPAR=BASIC#N0103
> 
> John: does this help?

nope. unable to open the file so compatibility mode cannot be added to the file. cannot be added anyway because the file is protected and should not be modified.
tested in >
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-IN (en_IN); UI: en-US
Calc: CL threaded
Comment 5 Buovjaga 2025-12-19 10:13:01 UTC 
(In reply to johnks from comment #4)
> (In reply to Buovjaga from comment #3)
> > (In reply to m_a_riosv from comment #2)
> > > https://help.libreoffice.org/latest/en-US/text/sbasic/shared/
> > > compatibilitymode.html?DbPAR=BASIC#N0103
> > 
> > John: does this help?
> 
> nope. unable to open the file so compatibility mode cannot be added to the
> file. cannot be added anyway because the file is protected and should not be
> modified.

Open the file with macros disabled and you can edit the macros.