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)
Version:
(earliest affected)
4.2.2.1 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2014-04-21 09:23 UTC by ssrsh82
Modified: 2020-02-15 17:38 UTC (History)
0 users

See Also:
Crash report or crash signature:


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

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

Hi,

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,
SS
Comment 1 Jorendc 2014-04-21 10:31:09 UTC
Reproducible, tested using Mac OSX 10.9 with LibreOffice Version: 4.3.0.0.alpha0+
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,
Joren
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,
SS
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

Version: 6.3.0.0.alpha0+
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

Version: 7.0.0.0.alpha0+
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