LibreOffice Calc just keeps on Crashing. I’m at my wits end here. I WANT to use LibreOffice, I PREFER LibreOffice, but what the actual F? I’m on Windows 10. I THOUGHT the reason LibreOffice crashed so much (specifically “CALC”, not Writer or other) is because of some sort of corrupt files or installations I had, either with Windows or with LibreOffice itself. I “Cleaned installed” Everything from scratch on my PC. I’m using the Portable Version. My Spreadsheets ARE big, they ARE Complex, I’m using Non-Letter Unicode Characters in my Spreadsheets, but they are almost ALL from Version 1.1 (from 1993). I use a lot of Conditional Formatting (in Red are Cells that have errors or that do not conform (“Errors” as in: it says we have 500 CPUs but I only counted 300), in Green are Validated information, etc.).
I HAVE A CLEAN INSTALL.
Does LibreOffice Work better on Linux? Does the “Installable Version” not crash so much??
Any help is appreciated.
Edit_1: Other information: I use AutoHotkey to Automate some LibreOffice Functions and Macros. I use about ~30~40 Custom Macros as well, but when LibreOffice Calc Crashes, I have not noticed it being when I use these Functions and Macros. I believe the crashes happen often (“often” as in: 50%~75% of the time perhaps?) when I come BACK to LibreOffice (working with some other Software, then coming back to LibreOffice), and perhaps 10%~25% of the Crashes happen when I’m in the process of Saving my Spreadsheet.
Edit_2: Side Note: I value LibreOffice greatly for it’s “Community Built” aspect; for it’s transparency and “Open Source” Aspects, and recently; for the possibility of each user to have “Data Privacy” (“my Files and my Data are my own”). Therefore, I am “Torn in Half” between: “Asking for help and Sharing my Data and my Files Online directly”; and the notion of Data Privacy and Data Security. I don’t know what the solution is. Any help or insights on this last part would be very appreciated as well.