Description: This time I opened a new instance of LibreOffice Calc with the spreadsheet I wanted to work on. The problem is occurring on a single sheet of the file. I want to make an edit to a set of formulas that reference data the sheet. The data I want to change is a cell address from CQ## to CR## I select Find and Replace in the Edit menu and filled in the form as follows. Select the cells in the column I want to change Find CQ Match case Replace with CR Current selection only Diacritic-sensitive Select radio button Columns Search in Formulas Replace ** CRASH ** Steps to Reproduce: 1. Follow the steps in the description, I replicated this behavior three times and submitted 3 sets of data files related to the problem. 2. 3. Actual Results: When I click 'Replace' I get a failed message Expected Results: All the formulas in the selected cells with CQ in them anywhere should be changed to CR. Reproducible: Always User Profile Reset: No Additional Info: Change the data in the cells so the calculations would be updated
Please test with a clean profile Menu/Help/Restart in Safe Mode.
I have made the test with LibreOffice in Safe Mode. The problem I was having yesterday did not reappear. That is the good news. Before I started LibreOffice in Safe Mode I navigated to the folders and files in my profile and was amazed at the number of objects there are in the AppData\Roaming\LibreOffice directory tree. I was not sure how to 'back-up' this profile, so I did not back it up. Now, it appears that my profile is corrupt and needs attention but I do not know where to begin. At Safe Mode startup there was a dialog that opened with options and one was to recover the profile from 'Last known good' but where is that? I appreciate that this application is complex and hope that the development team considered lame users, like myself, doing such foolish things and have a way for me to get LibreOffice Calc working like it did befor. Thank you very much for the instructions for using safe mode. I hope you will be able to help me fix my profile so the operations stabilize.
https://wiki.documentfoundation.org/UserProfile#Expert_information
Thank you for the link. I used this document to do my initial checking/problem solving. For me, there is nothing new here. I have made a copy of the 'user' directory and all its folders and files into a new name folder. Based on the description in the document now I have to start LibreOffice in 'safe mode' again and start the process of changing things ( one item at a time I think ) and see if the change resolves the problem. My method of work would cause me to reverse an ineffective change before making the next change. I am not certain where to begin but will start by reading all the options on the 'safe mode' dialog and see where that leads me. Thanks again for your help. carl
You can try removing only the registrymodifications.xcu, at loading LibreOffice generates a new one clean, it makes easy to restore the situation.
Please tell me because I do not know if the registrymodifications.xcu file has always been in my profile and I am just now seeing it or? It seems like now, since I ran Libreoffice in 'safe mode', this file is in the %APPDATA%\libreoffice\4\user subdirectory. The date and time stamp are updated anytime I open one of the apps in libreoffice. The first 'change' I noticed after running libreoffice in 'safe mode' was that the default font in Writer changed from Liberation Sans to Liberation Serif. Now it seems that I can not get delete registrymodifications.xcu. Everytime I start a Libreoffice app this file is updated. Is there a web page you can refer me to that will describe this functionality to me so I don't bother your with this. Thanks again for your help. carl
Thanks for all your messages and help. This process does not work the way I thought it would and after searching the Internet for "How do I backup my profile in Libreoffice" the reference returns me to the place I began. I consider this issue closed. I have a lot of work to do, a couple of weeks of setting and testing the effect of the settings on my version of Libreoffice and I need to get started with it. I appreciate all the input. I have opened the .xcu file and am very intimidated by what I see. I made no changes but have no idea, without going through all the 600+ lines of code what any of it does. Back to the beginning. I will forget about working with Libreoffice for a few days while I attempt to recover and maybe even fix some settings that were a bother to me before. carl
https://wiki.documentfoundation.org/UserProfile registrymodifications.xcu is always there, if not it is redone with default values. Their corruption sometimes happen with upgrading. And yes it is no easy to analyze. It contains mainly the options in Menu/Tool/Options. You can attach the file, and then we must wait for someone that can analyze it.
Thanks again S.V. Riosv. I have started with the Getting Started 6.4 manual and am RTFM, like I probably should have done several years ago but never took the time. I have already learned some interesting things about LibreOffice from this exercise. I am now copying the entire %APPDATA%\libreoffice\4\user directory to a backup location when I make a change to the settings in LibreOffice. I hope this will make recovery easier in the future. This may not be a fool proof solution but at least it offers some level of recovery options I did not have before.
I believe that all of these settings are visible under advanced settings - so you can use the GUI to change the settings (if you can find them). Tools - Options - Advanced - Open Expert Configuration. That should be a little less intimidating - and also less error-prone than editing an XML file by hand. In any case, it sounds like the reported issue is resolved, so I'm closing it.