Do you want to: Report a bug
Document Server version: 9.0.2.9
Type of installation of the Document Server: Docker
Server-OS: Ubuntu 22.04 LTS
Client-OS: Windows 10
Browser version: Firefox 140.0.4
Hey! I remember i already had a conversation about this problem years ago. Didn´t find it in the forum. So maybe it was via mail.
Negative times are not shown in xlsx.-files. Instead a unlimited amount of “#” are shown.
I saw this while using a work-time sheet. There i have the numbers of hours i have to work every day in the format HH:MM and the hours i actually worked. When i have to work 07:00 hours, but only worked 06:00 hours, it should show me -01:00 hour but instead i get unlimited “#”.
I just faked the problem in a new file for a screenshot. Here i want to calculate 08:00 hours minus 12:00 hours:
Maybe this can be fixed in the future?
Let me know if more information are needed!
Thanks a lot!
Hello @nilskamm,
Please provide an original file where the issue is reproduced for reference
Sorry! Didn´t thought it was necessary for such a little file.
Here is a file with the problem.
Negative Time Test.xlsx (8.1 KB)
Sorry for the delayed response. The display of this file is the same in other Editors such as MS Excel, WPS
That´s not true for me!
Here it is how it looks like in every other editor i tried, like LibreOffice Calc and MS Excel:
And here it is how it looks like in OnlyOffice:
Here the changed file with the second row:
Negative Time Test.xlsx (4.9 KB)
Hello, we are currently checking, please wait.
Also, please specify the version of MS Excel
I`m really sorry! I was pretty sure, that i saw it functional in MS Excel.
I let someone check it now with the Microsoft Excel 365 for MAC - Version: 16.99 (25071321) and you are right. It looks like in OnlyOffice.
So it only works in LibreOffice.
But it would be nice if it would work in OnlyOffice.
So more of a feature request than a bug report i guess?
We are still checking, I’ll get back to you as soon as I have news
We have a registered a bug, sorry for the inconvenience, we will notify as soon as a version with the fix is available
Hello, did it finally get fixed? It looks that I still have thge problem…
Thx!
Hello @Oliv
Unfortunately, we do not have any news on this issue. Sorry for the inconvenience.