Libreoffice

Erratic behaviour, e.g. crashing on closing calc file

May be due to corrupted user profile.

• Close LibreOffice.
• Find user profile: in Windows at C:/Users/[username]/AppData/Roaming/LibreOffice/4/user
• Rename to e.g. user-old.
• Check whether LibreOffice now behaves.

2021-05-22

Entering angle sign and other miscellaneous unicode characters

Find unicode number for symbol, e.g. angle sign = 2222. Enter enter 2 2 2 2 . The converts the number immediately previous to the special character.

20/10/2020

Updating Java stops Base connecting

LibreOffice cannot connect to Java

• Tools / Options / Advanced
• Select the larest version of Java offered (may only be one)
• OK
• May need to close and restart LibreOffice (all bits ... Writer, Calc, etc.)

18/04/2020

Firebird database - restarting numbering in autoincrement field

Find highest number already assigned to autoincrement field, e.g. NN

ALTER TABLE "tablename" ALTER COLUMN "columnname" RESTART WITH NN

Removing blank lines in a Writer document

Ctrl-H to open search/replace window; enable Regular expressions; search for ^$; replace with blank

^ = start of line; $ = end of line. (13/01/2020)

Updated 2021-05-22