Hi, does one of you guys have this problem. Is there a way to get it to update automatically? Alternatively, is there an easier way to get it to update (compared to the described deleting and retyping method), preferably one that works on multiple cells at once. Cant open office documents in android App after update to NC 26 Support jakob1 March 22, 2023, 6:03pm 1. delete one character and retype it), and hit enter. Technically, the latest released version of LibreOffice is 7.0.3, but this version hasn’t been tested as long as version 6.4.7 has and is generally for early adopters. To update it I have to change something in the cell where I call on the macro (e.g. When I change the background colour of the indicated cell, the numerical value does not update.

The problem is that it does it only once. It detects the background colour of a indicated cell and returns a numerical value of that background colour. After the document has been recalculated, the display is refreshed. Free alternative for Office productivity tools: Apache OpenOffice - formerly known as - is an open-source office. I have used a macro I found on a forum online. Press Shift + Ctrl + F9 to recalculate all formulas in the document.

Update openoffice