We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Conditional Formatting & Formulae failing to respond in Calc document [closed]

asked 2019-08-27 05:33:39 +0200

appreciatethehelp gravatar image

updated 2020-09-21 23:21:31 +0200

Alex Kemp gravatar image

I made the attached document to experiment with logging time, however two issues have cropped up that I can't work out how to solve:

  1. The Conditional Formatting to make today's date "highlighted in pink" has stopped responding, and I can't work out why- I haven't touched it since it was working.

  2. The formulae to convert and display the digits in the red/orange/yellow "H/M/S" columns (for example in columns E and F) has stopped responding, again I have not touched it since it was working so I am unsure why this is happening also.

Any help with this would be excellent:

C:\fakepath\Time Log (life categories, libreoffice example) [26:08:19]).ods

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2019-08-27 08:24:34.677890

1 Answer

Sort by » oldest newest most voted

answered 2019-08-27 07:42:54 +0200

You have disabled automatic calculation in your spreadsheet: Data->Calculate->AutoCalculate.

edit flag offensive delete link more


That's it! Don't know how I managed to do that but thank you!

appreciatethehelp gravatar imageappreciatethehelp ( 2019-08-27 08:22:31 +0200 )edit

Question Tools

1 follower


Asked: 2019-08-27 05:33:39 +0200

Seen: 48 times

Last updated: Aug 27 '19