[Libreoffice-bugs] [Bug 114251] Hang loading spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114251

--- Comment #21 from Jim Avera <jim.avera at gmail.com> ---
The #VALUE! errors are expected if macros are disabled, because most of the
formulas directly or indirectly call a user-defined function written in Basic.

If you can load the spreadsheet with macros disabled, please try with macros
ENABLED, to test formula re-evaluation and conditional formats.  

For a complete test (requires linux/unix):

  1. Download the attachment "tickers.csv" and 
         place it in $HOME/Jts/tickers.csv   

  2, Run soffice hang2.ods
      ENABLE macros when prompted 
      (if not prompted, go to tools->options->Security->Macro Security and
select "medium", click OK, then File->Reload)

  3. Click the yellow "Reload tickers.csv" button on any sheet

This WFM on LO 5.5 or earlier, but hangs when loading on the most recent master
build: 

Version: 6.1.0.0.alpha0+
Build ID: a9b202a6b7000e7af34f2a639ca207122a3968bf
CPU threads: 12; OS: Linux 4.13; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64 at 70-TDF, Branch:master, Time:
2017-12-26_23:09:36
Locale: en-US (en_US.UTF-8); Calc: group threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171227/89c65447/attachment.html>