Spreadsheet error: #####

Hey there,

Onlyoffice spreadsheets work sound, just one issue has been apppearing lately. When using a formula sometimes ##### comes out instead of expressing a value. No error code or whatsoever is mentioned so I’m expecting the used formulas are right, what can explain the #####? See the attached example.
Screenshot from 2023-12-18 15-24-42

Thanks in advance

Hey @Angie :handshake:
Most likely, there’s not enough space to display the value in the cell.
Try expanding the column.

If this is a problem or you believe that the behavior you described is incorrect, please provide a detailed description or a screen recording. :upside_down_face:

We’re always happy to have you on our forum!

Mind is blown!! Haha that turned out super easy to fix, but wouldn’t have gotten there on my own!

Thanks a lot!

:hugs:
We’re glad to welcome every new user to the forum. So, feel free to ask questions or respond to others just like you do!

Bonjour Nicolas, de mon côté je ne peux pas élargir les cellules. Ma souris clique automatiquement sur la cellule du dessous celle sur laquelle ma souris est. Je n’arrive donc pas à sélectionner les cases “A, B, C,…” Comment faire ? Merci :slight_smile:

Hi @CamB :wave:

Could you please provide the version of ONLYOFFICE Docs you are using? The issue you’re experiencing might be related to a known bug that has been fixed:
Change log 8.1.3
(Fixed bugs with cursor and interface objects positioning in Chromium browsers).

Also, please try setting your browser’s zoom to 100% to see if that resolves the issue.

Thank you!


Bonjour @CamB

Pouvez-vous indiquer la version d’ONLYOFFICE Docs que vous utilisez ? Il est possible que votre problème soit lié à un bug déjà corrigé :
Bug corrigé
(Erreurs de positionnement du curseur et des objets de l’interface dans les navigateurs basés sur Chromium).

Essayez également de régler l’échelle de votre navigateur à 100 % et voyez si cela résout le problème.

Merci !