Bug 94783 - UK Health and Safety Executive tool-kits spreadsheet freeze when being opened.
Summary: UK Health and Safety Executive tool-kits spreadsheet freeze when being opened.
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-05 12:02 UTC by bignas_
Modified: 2020-11-12 18:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet analysis tool. (2.62 MB, application/vnd.ms-excel)
2015-11-02 16:19 UTC, bignas_
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bignas_ 2015-10-05 12:02:47 UTC
I have been trying to use the free to download and use HSE Management Standards spreadsheet downloadable from:
www.hse.gov.uk/stress/standards/pdfs/analysistool.xls
However I am unable to use LibreOffice as it only opens correctly in Microsoft Office - which I am trying to get away from without much success when such things happen.
The spreadsheet asks to run macros, when the positive (YES) response is taken then it returns an error "Basic syntax error". It then will only close if "XKILL" is used from a terminal.
I have waited several months to try again to use LibreOffice, and have upgraded several times to each new version  - but it has not made any difference.
Comment 1 Timur 2015-10-05 15:05:20 UTC
Can you please be specific on how you use this tool (minimal case), the expected and obtained result?
Comment 2 raal 2015-10-05 20:37:44 UTC
Hello,
Thank you for reporting the bug. Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. Please provide a clearer set of step-by-step instructions on how to reproduce the problem.
Comment 3 Julien Nabet 2015-11-01 21:20:54 UTC
I don't understand, there's no macro in the xls file.
Comment 4 bignas_ 2015-11-02 16:19:11 UTC
Created attachment 120207 [details]
Spreadsheet analysis tool.

Hi Julien.
I attach the spread sheet  which is creating the problems. If you open it, you need to select enable macros for it to work. It then opens an error dialog box which will only close if you use xkill. 

I am using Ubuntu 14.04 LTS with a Gnome desktop. The version of Libre Office is 5.0.3.2.

I hope this info helps you.

Regards
Comment 5 Julien Nabet 2015-11-02 20:33:38 UTC
With master sources updated yesterday, I had a bt quite similar to https://bugs.documentfoundation.org/attachment.cgi?id=119374
Dup?
Comment 6 Xisco Faulí 2016-09-11 19:53:26 UTC Comment hidden (obsolete)
Comment 7 Xisco Faulí 2016-10-10 11:11:58 UTC Comment hidden (obsolete)
Comment 8 emmapk1 2020-11-12 12:24:24 UTC
Thanks for troubleshooting health and safety toolkit issues. I always use natural products and maintain my health. I have recently visited a site that is selling cbd vape juice 1000mg
 https://buycbdonline.com/products/unicorn-cbd-vape-juice-juice-man-1000mg. Vape juice is specially manufactured for men. It helps to reduce stress and make them physically fit to enjoy the real moments of life. You can visit the site to order CBD products at discount.