Ask Your Question
0

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

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

appreciatethehelp gravatar image

updated 2019-08-27 08:24:23 +0100

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
0

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

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

edit flag offensive delete link more

Comments

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

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

Question Tools

1 follower

Stats

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

Seen: 29 times

Last updated: Aug 27