Bug 160875

Summary: Calc partially fails, requires computer restart
Product: LibreOffice Reporter: dbaker586
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO ---    
Severity: normal CC: stephane.guillou
Priority: medium    
Version: 7.5.7.1 release   
Hardware: ARM   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description dbaker586 2024-04-30 20:09:23 UTC
2023 Mac M2 mini, Sonoma 14.4.1
I tried to edit a graph in Calc, and the Format Axis box refused to allow me to change the number type.  Clicking on the format types did not respond.  Furthermore, About LibreOffice does not respond.  Restarting LibreOffice doesn't work.  I have to restart the computer.  
In the middle of my work.  
At least I was able to save it.
Comment 1 dbaker586 2024-05-15 16:32:11 UTC
I found the problem.  In the formatting dialog box, a feature that uses the Source Format was checked.  That's fine and useful, but not if it's mandatory.  When the box is checked, the rest of the dialog doesn't work.  
That's a bug.
When one changes the format from the source, that box should uncheck itself.
Comment 2 dbaker586 2024-05-15 16:45:15 UTC
I got so frustrated with this, that I bought MS Standard Office 2021 for a single individual, so I could use Excel.  I've found the graphing features in both LibreOffice and OpenOffice to be less flexible.  
Also, I tend to use a certain style of graph for technical pubs.  In all of the current spreadsheets, I have to go through a lot of manipulations to make the style consistent from graph to graph.  One way is to copy the graph and reset the data.  But in one or the other of LibreOffice or OpenOffice, I have found things disappearing from the plot.  
I really miss Borland Quattro Pro with the 123 GUI.
I got good and fast with that.  

-Other
1) I have found LibreOffice to run slower and slower as I put more figures into the document.  I used to write them in OpenOffice, then take them to LibreOffice to get them into DOCX.  
2) Libre, Open and MS all seem to have different inline special characters.  I can't transfer files from one to the other and have the mathematical expressions come out readable.  

Another reason I bought MS Office 2021.  Then compared to MS Office 2002, I found the MS Office GUI reworked to cut or cripple the things I depended upon, adding a lot junk I don't need, with all the Help files available only online.  

Not all changes are useful.
Comment 3 Stéphane Guillou (stragu) 2024-05-16 11:20:20 UTC
Thanks for the report.

About "calc partially fails, requires computer restart", is that only when opening the About dialog?
Version 7.5 is not maintained anymore. Please do test version 24.2 if you can, to see if the issue persists: https://www.libreoffice.org/download/download/

Regarding the other issues:

(In reply to dbaker586 from comment #1)
> In the formatting dialog box, a feature that uses the
> Source Format was checked.  That's fine and useful, but not if it's
> mandatory.  When the box is checked, the rest of the dialog doesn't work.  
> That's a bug.
> When one changes the format from the source, that box should uncheck itself.

(In reply to dbaker586 from comment #2)
> -Other
> 1) I have found LibreOffice to run slower and slower as I put more figures
> into the document.  I used to write them in OpenOffice, then take them to
> LibreOffice to get them into DOCX.  
> 2) Libre, Open and MS all seem to have different inline special characters. 
> I can't transfer files from one to the other and have the mathematical
> expressions come out readable.  

... we try to have one report per issue, so it is actionable and to make it more likely to have them fixed.
Please open new reports of those issues persist in the latest release.

Thank you!