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

--- Comment #21 from Jim Avera <jim.av...@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@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to