The spreadsheet alters the numerical value of cells

[Golffies]

This issue is unique.

• [X] I have used the search tool and did not find an issue describing my bug.

Operating System

macOS 10.12 or higher

Version information

7.5.1 (543)

Expected Behavior

• Numerical values are entered manually into a blank spreadsheet;
• The sum of these values is calculated at the bottom of the columns;
• The spreadsheet is saved locally in ODT or XLS format;
• The spreadsheet is reopened a few seconds later;
• The values entered in all columns remain the same as they were before the spreadsheet was closed;
• The sums at the bottom of all the columns remain the same.

Actual Behavior

• Numerical values are entered manually into a blank spreadsheet;
• The sum of these values is calculated at the bottom of the columns;
• The spreadsheet is saved locally in ODT or XLS format;
• The spreadsheet is reopened a few seconds later;
• The values entered in certain columns remain the same as they were before the spreadsheet was closed;
• The values entered in certain other columns are all decremented by 1, without user intervention;
• The sums at the bottom of all the columns remain the same; they correspond to the sums of the column values before closing and reopening the worksheet.

Reproduction Steps

• Create a blank spreadsheet in OnlyOffice;
• Enter data manually in columns;
• Apply the correct currency in accounting format to the relevant columns;
• Save the spreadsheet in ODT or XLS format;
• Reopen the spreadsheet.

Additional information

During the initial entry of values and choice of formats for the columns, I was warned that an error had occurred, and that I should save my work in progress using the 'download' option. I could no longer modify the cells in the spreadsheet. I couldn't find the "download" option, so it probably doesn't apply to the desktop version of OnlyOffice.

I opened another spreadsheet, copied and pasted the values from the first to the second spreadsheet, and closed the first spreadsheet that had generated the error.

[rsnegirev]

Hi, @Golffies, sorry for so long answer.

I can confirm this is the bug 66392.

Thank you for the report!

We'll text here when the problem will be fixed.

[Rita-Bubnova]

The issue is actual in DocumentServer.

[rsnegirev]

Hi @Golffies problem was fixed in this commit https://github.com/ONLYOFFICE/core/commit/46fc80f423cee0e1501fc8d650e2a14ceeaade3e

Fixes will be released in the next major version.

[Rita-Bubnova]

DocumentServer v8.1.1 is released so I close this issue. Feel free to comment or reopen it if you got further questions.