@Sheila : we'll need more information I'm afraid.

Please provide your hardware details, accessible via the 

Apple menu > About this Mac

Also please indicate whether you are accessing the file from Dropbox or whether the file is stored locally. From your description, it would appear that the file is stored in a Dropbox folder ?

Please also indicate what kind of spreadsheet file :
Excel 97
Excel 2003
Excel 2010 or later
LO Calc

Does the spreadsheet file or any of the graphs reference external objects (other sheets, CSV, data sources) ?

Ideally, we would need a minimalist spreadsheet which reproduces the problem (even if just on your Mac) so that we can test independently, otherwise we will be just guessing as to how the sheet is made up and might not be able to reproduce in the same test conditions.

Also, you mention that the Mac reboots. Generally, a crash of this kind is probably hardware related, to there should be a log stored in the system when this happens. These logs are generally available via the Console.app, but the files themselves are stored in the

/Library/Logs/CrashReporter or 
/Library/Logs/DiagnosticReports 

folders which are in the root directory of the volume on which the OS is installed.

Ideally, it would be useful to have the log at the moment the crash occurs and you can upload that/those files as an attachment to this bug report (Add an attachment link). If the files are too big, then try and zip them with the OSX provided compression utility.

Also please mention which version of LibreOffice you are using.

Created attachment 137104 [details]
This is a small test spreadsheet that has the same problem on my computer as my charity one thats causing the problem.

As requested in your email.

Created attachment 137105 [details]
3 files from /library/logs/diagnosticReports which happened when it crashed as I checked my test file would crash. It did.

These 3 files were generated when the computer restarted as I tried to make a chart in the test file. It then rebooted again half way through the reboot. I'm not sure which report you need so I've attached them all. I can't directly attach the file, because it won't let me see the Mactintosh HD in the attachment window for some reason. Hope this works.

Thanks.

Hi Alex, Thanks so much for having a look at it. Here’s some answers to your questions. Sorry if its a complicated one.
The Hardware is as follows: MacBook Pro 17-inch, early 2011. Processor 2.2 Ghz Intel Core i7, Memory 8 Gb 1333 Mhz DDR3 with an Intel HD graphics 3000 512 mB
My version of Libreoffice is 5.2.3.5
The file is stored in Dropbox and I have a copy on my computer and also another backup on a USB stick. They are all behaving in the same way on my machine.
I have been saving it as an Excel (97-2003) file so that our charities accountant can read it easily. It’s extension is   .xlsx if that is helpful
They all reference internal sheets - so it is one files with about 10 sheets inside it. The graphs reference things in their own sheets.
No problem. I will attach one called Test.xlsx which reproduces the problem on my machine but not the other computer.
Many thanks again. I hope you can help.

Sheila

Thanks Sheila, I'll test and report back here.

No crash with

Version: 6.0.0.0.alpha0+
Build ID: 0ad8447d3199e1c1d1f7d6ddabc9b4cded99c2d6
CPU threads: 4; OS: Mac OS X 10.13; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-10-19_07:06:36
Locale: fr-FR (fr_FR.UTF-8); Calc: group

Open XLSX file, click on Insert Chart button. Wizard opens, and I can insert a chart.

No repro with

ersion: 5.2.5.1
Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22
Threads CPU : 4; Version de l'OS :Mac OS X 10.13; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

No repro with :

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
Threads CPU : 4; Version de l'OS :Mac OS X 10.13; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

or

Version: 5.4.2.2
Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
Threads CPU : 4; OS : Mac OS X 10.13; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

My tests were all run on a locally stored version of the XLSX file provided.

@Sheila :

- currently my suggestions to try and resolve this are relatively limited :

- possible hardware incompatibility with the graphics drivers - by chance, is OpenGL activated in your LibreOffice user preferences ?

- the version you indicate in your response does not appear in the list of TDF released versions, so I'm assuming that either you have got that version number slightly wrong, or else you are using a version of LibreOffice provided by someone other than TDF, for example one of Collabora's versions (Vanilla or paid) obtained from the Apple Store - if that is the case, please mention that in your reply

- a LibreOffice user configuration folder problem. The LibreOffice user configuration folder can be found in: 

/Users/username/Library/Application Support/LibreOffice

By default, this directory is hidden. There are several different ways to get hidden files and folders to display :

Open the Finder
Go to your Macintosh HD folder (access this from Devices in the left column)
Hold down CMD-Shift-. (dot)
All the hidden files will become visible.



Open the Finder
Hold down the Alt (Option) and choose Go
You will see the ~/Library folder listed below the Home folder

Alternatively, you could do the following:
Open the Finder
Choose Go from the menu bar
Choose Go to Folder (or Shift-CMD-G)
Type ~/Library into the text box and press go

Alternatively:
Open Terminal
Type the following:  
defaults write com.apple.Finder AppleShowAllFiles true

then:
killall Finder


Starting LibreOffice in Safe Mode involves first starting LibreOffice normally, then LibreOffice menu Help > Restart in Safe Mode. If you don't have this entry, then you have a version of LibreOffice that is not up to date and/or not released by TDF.

Thanks again,

Here are my answers and what I've tried next.

OpenGL is deactivated.
You are correct. I was using LibreOffice Vanilla. I have now uninstalled that and installed version 5.4.2.2 It is still suffering with the same problem.

Assuming, therefore,  that it was probably a corrupted User profile, I first tried restarting LibreOffice in safe mode but it had the same problem.
Just in case I also changed the User profile to user-old to force it make a new one and that did not solve the problem either.

So.....have you any other ideas? My next step, unless you can think of something else to try, is to restore my Mac to factory settings and start again.

Thanks again for all your help on this!

Hi Again,

Just had a chat with Apple on their online technical support thing. They told me that the panic report was generated by a Kernel which they said is usually software related - there are other panic messages for hardware problems. They said since it only happens with this application and only for certain bits of it then its probably the software.

I've attached a copy of the latest panic report in case that helps at all.

Does this help with any other ideas? If not thats fine just let me know.

And thanks so much again!

Created attachment 137141 [details]
Here is the text copied out of the latest panic report that my MacBook generated. Hope it can shed some light....

This is the text from the panic report my computer generated after restarting

@Sheila : thanks for your feedback.

Irrespective of what Apple might say, it does seem like a hardware problem linked to your graphics chip, as indicated by the latest attachment.

There is a known, but as yet, undetermined root cause that appears to occur with LibreOffice Calc in particular, and which causes a crash which might be similar to what you are reporting.


It appears to be linked to LO code wanting to switch the graphics chip to run in a particular way. 


Some people have reported that they can work around this by starting LibreOffice from the terminal with the following command:

/Applications/LibreOffice/Content/MacOS/soffice

and then keeping the terminal app open until they have finished working with LibreOffice. However, this solution does not work for everyone.

Could you give this a try and report back ?  


Could you also please indicate what graphics chip hardware you have on your Mac and your output screen(s) and resolution(s) ?

@Sheila : sorry about the repeated request for graphics hardware information, I see that you have already provided it. Please ignore this and just try testing the alternative Terminal.app launch of LibreOffice.

@Sheila : you could also try using the following utility :

https://gfx.io/


to see whether that can give you any clues as to what might be going on.

Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-20180530