[Solved] Conditional Formatting not updating

[wibblewobble]

G'day members of my favourite office software.

I'm having an issue with a conditional formatting function I'm using to highlight a cell based on the currect time.
It works fine when I first open the document but doesn't update unless I open the conditional formatting and view it.

AND(MOD(NOW();1)>=TIME(16;0;0);MOD(NOW();1)<TIME(16;30;0))

This is an example of the code I'm using which might be the issue if certain functions in it don't update?

I also have left on the auto calc in tools->cell contents

Any ideas?

*edit* I just read the help information on the NOW function and found out that it only recalculates everytime a cell is modified which is a pitty as I was after a timetable to run in the background which updated on it's own every 30 minutes. Perhaps there is still a way to achieve this?

[eremmel]

I can not imagine that this is an issue, but it is by design unless you want to spent a large number of CPU cycles on this. You might solve it by hand by forcing a re-calculation of the sheet. You might also be able to write a macro that triggers the recalculation, but I guess that this macro can not be written in AOO Basic for its execution is not in another thread (it blocks UI during execution). So you need to do something smart with Java or other API that supports multi-threading. But that brings you to the second issue, is AOO designed to work multi-threaded. Some parts may others not...

The only 'trick' I can think of, it to find a way to relate your conditional formatting to all cells involved in your sheet, so that the calculation is triggered each time you change something. This might e.g. happen when you add a dummy calculation like 'COUNTA(A1:ZZ300)*0' to your conditional formatting formula.

See next post...

P.S.
I vote for not calling this an [Issue] and removing the flame icon.

[Villeroy]

Edit, clear, delete, insert some cells. Any change updates the conditional formatting.