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: 2022-05-12 14:23 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:

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