#value! in a formula that works

Docs
1

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:
https://www.swisstransfer.com/d/f5b8e80a-b4e7-4adc-9045-ac1ab4d99641

Where does this #value! error come from?

Thanks in advance for your help

1 Like
3

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)
    Script:
(function() {
    Api.asc_calculate(Asc.c_oAscCalculateType.All);
})();

image
image791×683 7.81 KB

Recalculate worksheet values

5

Hello Nikolas,

Thank you for your reply.

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

6

@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.
8

Hello @TheaterBarnabe :wave:

With new version of Desktop Editors the issue discussed in this topic will be fixed.
Update will be available in a couple of days. Please await for it and share your feedback afterwards.