The following macro has been written by hanya - hanya is a developer - with a view to fixing the problem easily. It is likely that the code will be included with future releases of AOO in which case only Steps 6 onwards will be needed.
A major advantage of using the macro to repair AOO is that all of your settings are kept. If you choose instead to rebuild the profile yourself, you lose all your settings and you have to copy them back from the old profile.
These instructions are based on Windows 7. Windows 8 and Windows 10 should be almost identical. Apple Mac and Linux should be similar.
| Edit: The macro has been developed to work with Apache OpenOffice. |
Using the macro with LibreOffice
The macro has not been tested with LibreOffice but doing as below will allow you to back out any changes made by the macro.
1. Copy the User Profile - take a copy of C:\Users\xxxxxx\AppData\Roaming\OpenOffice\4\user. You may need to make hidden files visible to see it.
2. Follow the instructions in the article.
3. If anything goes wrong, replace the now changed C:\Users\xxxxxx\AppData\Roaming\OpenOffice\4\user with the one you copied earlier.
2. Use Windows Explorer and go to C:\Users\xxxxxx\AppData\Roaming\OpenOffice\4\user\Scripts (where xxxxxx is your username) and open the folder. right-click inside the folder > New > Folder ..., and create a new folder called python. Note: you must use all lower case letters for "python" or Writer will not see the file.
|Edit: If you are still using AOO 3.x - you should not be as there are security implications - I think the path is C:\Users\xxxxxx\AppData\Roaming\OpenOffice.org\4\user\Scripts OpenOffice.org|
4. Double click config_backend_cleaner.py.zip file to open it > right-click config_backend_cleaner.py > Copy. This takes a copy of the file.
5. Go back to C:\Users\xxxxxx\AppData\Roaming\OpenOffice\4\user\Scripts\python > right-click inside the folder > Paste. This pastes the file config_backend_cleaner.py into the folder ...\python.
6. Close OpenOffice.
7. If you run the quickstarter, close it as well. [Start > Control Panel > Performance Information and Tools > Advanced Tools > Open Task Manager > Processes > left click on Image name (to sort the processes in alphabetical order). Now right-click each soffice.exe and soffice.bin > click End Process - they will all disappear.]
8. Start OpenOffice
9. Go Tools > Macros > Organize Macros > Python > click the [+] by My Macros > click the [+] by config_backend_cleaner > click on cleanup > click Run
10. Close OpenOffice
11. Start OpenOffice
The problem should be fixed.
In the unlikely event that there was a problem with any of your dictionaries, they may need to be removed and reinstalled by Tools > Extension Manager if required. For more assistance see [Troubleshooting] Spell check in OpenOfficee and [Solved] No dictionary present in OpenOffice.
Why do these spell check errors occur?
See RoryOF's post below which says:
RoryOF wrote:While we cannot say for certain, it appears that this problem may often occur with over-hasty power off of your computer. We recommend using the formal computer shut down process, then waiting a few seconds after the "OK to power off" message before hitting the power switch or snapping a laptop lid shut. Wait for disk activity to finish - information is cached within the write buffers of the hard drives and it takes a few seconds for the drive to decide to write it. If you power off too hastily this information is not written and some or all of the OO housekeeping information is lost.
Edit: Be advised: over-hasty power off as outlined above may also cause damage or catastrophic loss to your document. The few extra seconds of waiting while disk activity ceases will, even cumulatively, be much less than the time needed to attempt to recover, or, more likely, to rewrite a damaged or lost document.