#value! in a formula that works

Hello everyone

I work in a theater, and we use Onlyoffice via our IT supplier.

I’ve created a spreadsheet for our technicians to indicate their working hours:

The problem is this:
the total hours for the period (cells in column F) are calculated correctly, but sometimes, when I reopen the file, the Total cell shows #value!
I then have to edit any cell in the calculation, press Enter and my total is recalculated correctly.

You can see a video of the problem here:

Where does this #value! error come from?

Thanks in advance for your help

1 Like

Hi, @TheaterBarnabe :handshake:

  1. We will investigate this behavior. I will get back to you once we have more information.
  2. You can press F9 to recalculate all cells in the table. (fast way)

  1. You can also use a macro that will automatically update values when the table is opened.
    Also, don’t forget to check the autostart option. (The fastest way)
(function() {

Recalculate worksheet values

Hello Nikolas,

Thank you for your reply.

Pressing F9 works, but the macro in autostart mode does not.

@TheaterBarnabe :wave:

  1. We’ve filed a bug for the behavior you described in the editor. (The working formula is displayed incorrectly when opening a file with French regional settings)
  1. Please remind me in about a week regarding this issue, we’ll try to dig deeper into why it’s not working.