Losses after computer Crash

[geraldike]

We had a short power outage that crashed my computer. At the time I was using LO Calc. This has happened more often than it really needs to, but I’ve never had one of these occurrences disrupt LO before. This time, a lot of my settings were lost; for example, my keyboard definitions (ex. shift-alt-L to name an area). This would be survivable, probably, but I also discovered that all my macros are gone! I assume they are still there, somewhere, but they no longer show up. HELP! Is there a way to find them or otherwise get them back?

One point is that this is the first crash recovery where my computer felt the need to interrupt the rebooting with system updates which it had been bugging me with for a while. That had never happened at such a time before (i.e., following a crash). Could that have anything to do with why things when awry during this reboot? LO took super-long to open, as well (suggesting it was lucking for stuff it could no longer find).

I am using LO 7.4.0.3. Help!

[EarnestAl]

I always close everything and then allow Windows to update and reboot the first time I notice it. This is even when I have something urgent to do, I find it saves me far more time.

Don’t delete your user profile, change the name. You macros might still be there in basic folder but you will have to see. Have a look at LibreOffice user profile - The Document Foundation Wiki for details

[geraldike]

Thank you for your reference! I went to your suggested website and discovered where all the macros are hidden in the “basic” folder. To my unspeakable delight, the .xba files can be opened with NotePad, so it will just be a matter of copying them back into macros after copying them into another folder so they don’t disappear.

Thank you.

[jfn]

Mind you, while indeed the .xba files are actual (Basic) macro code, you also need two more files which describe/list the code and dialogs .xba files, namely dialog.xlc and script.xlc.
→ Without those two files, the .xba files are not listed in the UI.

Side note: It is important to backup the user profile on a regular basis.

[MikeNovember]

Hi,

I don’t see anything else than replacing your LO user profile by one that you have backed-up before the crash.
Without back-up, I am afraid there is no solution; your user profile is probably corrupted, you should delete it and launch LO, it will create a new one, without your settings, of course.

Regards,

MN

PS: you use LO 7.4.0.3, the 1st revision of the “fresh” branch; this branch has new features, but is less tested and may have lots of bugs. If you stay with this branch, install 7.4.2. If you want a more stable version of LO, use “still” branch, with 7.3.6.

[geraldike]

What’s the specific title of the user profile? File or folder? I’m sorry, I know nothing about the nuts and bolts of LO.

But now I have a new problem. I upgraded to the next version that was offered (7.4.2.3, up from 7.4.0.3). Now I can’t record macros!

When I go to customize, the icons for recording macros show up in the selection menus for the toolbar and dropdown menus, and the selection boxes are checked, meaning they should show up. But they don’t show up in the menu or the toolbar. The icons for the edit and play macros show up, but the icon for the record macro command no longer does, even though the boxes are checked for them to appear. This is getting very frustrating.

I don’t have a pre-crash backup.

[EarnestAl]

Please re read link I gave before on user profile.

I suggested renaming your user folder (make sure LibreOffice is closed first) as it seemed it was damaged and so you would have a backup, LibreOffice will create a new user folder on start up of it can’t find one

To record macros you first need to click Tools - Options - LibreOffice - Advanced and tick the box Enable macro recording

[geraldike]

OK, I tried everything that page suggested. I renamed the user profile file, let it built a new one, and started adding things back into the new one – starting with the macros. It didn’t work. Copying the config folder helped get back my toolbar configurations, etc., but not everything. I don’t know what else to do, I don’t know what I missed, I guess I’m just stuck with it. I can create a new macro library with new modules for my stuff and just copy the old ones into new macro files.Thanks for your help anyway.