OnlyOffice Multi-Sheet Operation Anomalies and Data Migration Defects Report

Desktop editors
1

I encountered two minor bugs that may contribute to software improvements:

When multiple spreadsheets are open simultaneously:
If one sheet contains formulas across A10-H10 (e.g. “=10+SUM(A3:A9)…=10+SUM(H3:H9)”), after typing ‘0’ directly into A10 and pressing Enter, then clicking B10 before switching to any other sheet – the cursor position in the original sheet becomes unlocated. Subsequently pressing Tab triggers a bug where B10’s formula recalculates at the new cursor location in another sheet, overwriting existing content with its result.

With two or more spreadsheets open:
When moving/copying a worksheet using “(Move to end)” + “Create a copy” option to place it at the end of another workbook, the second-to-last sheet in the receiving workbook suffers data corruption. Most cells exhibit erratic behavior: some become blank while others display mixed content from the newly transferred sheet.

Note: These issues occur specifically with my current version “Community Edition 9.1.0.167 (x64 exe)”. They didn’t exist in either “Version 8.3.3.21 (x64 exe)” nor the recently tested “Business Edition 9.0.4.50 (x64 exe)”.

2

Hello @xn666

First of all, I’d kindly ask you to separate the issues in different topic. Let’s address the first issue in this topic, but for the second one please start a new topic to avoid parallel discussions.

I’ve created a sample data sheet and entered the formulas, then created second empty sheet > from that I tried to reproduce the issue according to the provided scenario, but after switching to another sheet the cursor gets new position, i.e. A1 in second empty sheet, and pressing Tab simply switches to B1.

Can you record a video demo? It seems I’ve missed some steps.