Bug 77722 - Excel file with VBA goes into an infinite error loop upon load
Summary: Excel file with VBA goes into an infinite error loop upon load
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: high major
Assignee: Not Assigned
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
Reported: 2014-04-21 09:23 UTC by ssrsh82
Modified: 2024-05-12 03:16 UTC (History)
0 users

See Also:
Crash report or crash signature:

Reference Excel file that shows the problem described (1.92 MB, application/vnd.ms-excel)
2014-04-21 09:23 UTC, ssrsh82
Excel file with the issue (3.22 MB, application/vnd.ms-excel)
2018-12-08 10:07 UTC, eisa01

Note You need to log in before you can comment on or make changes to this bug.
Description ssrsh82 2014-04-21 09:23:58 UTC
Created attachment 97678 [details]
Reference Excel file that shows the problem described


The attached Excel file is downloaded from http://acesdownload.nic.in/Documents/ACES-EFiling-ST3_Oct-Mar_2013_onwards_V1.1.xls.zip (see http://acesdownload.nic.in/ for similar utilities). When this file is opened using LibreOffice 4.2.2 it continuously displays an error and never closes. We are forced to kill the application via Task manager.

The OS is Windows 7 Professional 64-bit OS. This files opens normally in Microsoft Excel 2010.

We have recently migrated all our systems to Libre Office 4.2.2. Appreciate your addressing the Libre Office Spreadsheet issue that is being reported ASAP. This will ensure our confidence in relying on LibreOffice for our day to day usage.

Thank you,
Comment 1 Jorendc 2014-04-21 10:31:09 UTC
Reproducible, tested using Mac OSX 10.9 with LibreOffice Version:
Build ID: 619b4c40da9e85febbb08a3f7cf8aa8d10963fc1
TinderBox: MacOSX-x86@49-TDF, Branch:master, Time: 2014-04-18_00:07:53

Looks like there are some macros in it which cause this behavior?

This is not a blocker for sure (no data loss/crash etc). Following https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg this is major high (unable to open particular documents).

Kind regards,
Comment 2 Kohei Yoshida 2014-05-07 02:30:02 UTC
This Excel file is heavily armed with tons of VBA code.  Still, not good to start running VBA code before asking "do you want to enable macro" thing.
Comment 3 QA Administrators 2015-06-08 14:42:50 UTC Comment hidden (obsolete)
Comment 4 ssrsh82 2015-06-18 09:37:49 UTC
Hi QA Team,

As per the request from QA Administrators, this issue has been retested with LibreOffice Calc 4.4.3. The problem still exists. There is no change in the behavior, the problem persisted until the program is forcibly terminated in the TaskManager. The test was conducted on a desktop with Windows 7 Professional 64-bit OS.

Thank you,
Comment 5 QA Administrators 2016-09-20 10:26:00 UTC Comment hidden (obsolete)
Comment 6 eisa01 2018-12-08 10:06:26 UTC
Opens fine if I disable macros, so if that was an issue before as alluded to in comment  #2, that is fixed.

If I enable macros I get many Basic errors, which eventually cash the document to crash, Libreoffice itself doesn't crash.

Original link to attachment is dead, and the attached version is corrupted. Will reupload a version I found on Archive.org

Build ID: beae6c7a7f163daad0d4dea63a3d403af2745fd1
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-12-06_23:52:29
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 7 eisa01 2018-12-08 10:07:37 UTC
Created attachment 147379 [details]
Excel file with the issue
Comment 8 QA Administrators 2019-12-09 03:39:47 UTC Comment hidden (obsolete)
Comment 9 eisa01 2020-02-15 17:38:15 UTC
This is still present.

Basic complains about syntax errors. I'm not able to close the code editor window, if I try, it will just complain about the syntax errors again.

If I go back to the document file window I get into an infinite loop of syntax errors

Build ID: 0cb4f304abf6f8dd6b40eb800788d2fe80581813
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 10 johnks 2022-05-12 14:23:00 UTC
 download from https://www.gst.gov.in/download/gstr4/offline

unable to upload here as the file is too big

this excel file opens on the first sheet, throws bunch of errors and refuses to quit. i had to do multiple times alt-f4 and then i somehow got the quit dialog open.

the macros that are not implemented in calc make this file unusable to even open

Version: / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 11 QA Administrators 2024-05-12 03:16:16 UTC
Dear ssrsh82,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)

If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword

Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team