Bug 100488 - FILEOPEN: Formula errors with XLSM
Summary: FILEOPEN: Formula errors with XLSM
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2016-06-20 05:35 UTC by Jeff D. Hanson
Modified: 2021-04-11 20:18 UTC (History)
1 user (show)

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


Attachments
Original spreadsheet (4.08 MB, application/zip)
2016-06-20 05:35 UTC, Jeff D. Hanson
Details
Spreadsheet with example data (5.10 MB, application/vnd.ms-excel.sheet.macroEnabled.12)
2016-06-20 05:36 UTC, Jeff D. Hanson
Details
PDF from Excel of example spreadsheet (1.13 MB, application/pdf)
2016-06-20 05:37 UTC, Jeff D. Hanson
Details
PDF from Calc of example spreadsheet (1.26 MB, application/pdf)
2016-06-20 05:38 UTC, Jeff D. Hanson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jeff D. Hanson 2016-06-20 05:35:39 UTC
Created attachment 125739 [details]
Original spreadsheet

Xubuntu 14.04.4 x86_64
LibreOffice 5.1.3.2 from libreoffice-ppa
Excel 2013 (15.0.4815.1000)

Source spreadsheet:
ForgedAnvil D&D 5E Character Generator v1.64 
http://www.enworld.org/forum/rpgdownloads.php?do=download&downloadid=1234

This is likely the most complicated spreadsheet you've ever seen.  It's basically an app implemented as a spreadsheet with macros.  It exhibits all the usual LO bugs with ridiculously slow loading times, cut-off text, horribly slow scrolling (Character Sheet III for example), and graphical problems like the occasional invisible cell.  These are mostly annoyances and are probably duplicates of existing bugs so I'm ignoring them.

A more significant problem is broken formulas.  Most any cell showing ### or #NAME? is an error.  It's not as common with the initial spreadsheet but adding character data causes more to be visible.

I'm attaching the original spreadsheet and a completed version with example data along with PDFs from Calc and Excel for comparison.
Comment 1 Jeff D. Hanson 2016-06-20 05:36:34 UTC
Created attachment 125740 [details]
Spreadsheet with example data
Comment 2 Jeff D. Hanson 2016-06-20 05:37:50 UTC
Created attachment 125741 [details]
PDF from Excel of example spreadsheet
Comment 3 Jeff D. Hanson 2016-06-20 05:38:44 UTC
Created attachment 125742 [details]
PDF from Calc of example spreadsheet
Comment 4 Jeff D. Hanson 2016-06-20 05:40:05 UTC
Excel is running on Win8.1 64-bit
Comment 5 Buovjaga 2016-06-25 19:00:40 UTC
Confirmed #NAME? in sheet Spellcasting, section Familiar.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: c13f60e7cd18df6b0ab70289f5b91ee01e4ae126
CPU Threads: 8; OS Version: Linux 4.6; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on June 18th 2016
Comment 6 QA Administrators 2017-09-01 11:20:11 UTC Comment hidden (obsolete)
Comment 7 Jeff D. Hanson 2017-10-06 07:41:09 UTC
Reproduced in:
Version: 5.4.1.2
Build ID: 1:5.4.1~rc2-0ubuntu0.16.04.1~lo0
Xubuntu 16.04.3 x86-64
Comment 8 QA Administrators 2018-10-07 03:05:22 UTC Comment hidden (obsolete)
Comment 9 Roman Kuznetsov 2019-03-24 13:11:57 UTC
Stil repro #NAME many errors and now in

Version: 6.3.0.0.alpha0+ (x64)
Build ID: 5a907fe76bc628629fddb5501727642468d38dae
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-22_00:18:04
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

I got a message:

Warning loading document 100488 Trinfural-DRD(M)2.xlsm:
The data could not be loaded completely because the maximum number of columns per sheet was exceeded.
The data could not be loaded completely because the maximum number of rows per sheet was exceeded.
Comment 10 QA Administrators 2021-03-24 05:55:00 UTC Comment hidden (obsolete)
Comment 11 Jeff D. Hanson 2021-04-11 20:17:24 UTC
Error message at load:

The data could not be loaded completely because the maximum number of columns per sheet was exceeded.
The data could not be loaded completely because the maximum number of rows per sheet was exceeded.

No change in behavior.
Comment 12 Jeff D. Hanson 2021-04-11 20:18:17 UTC
Tested with v6.2.8.2 on Xubuntu 16.04 x64