in spreadsheets, adding row below frozen row will move the freeze (same for columns)

[janxkoci]

This issue is unique.

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

Operating System

Linux (DEB package)

Version information

7.4.0.163

Expected Behavior

Frozen rows should stay frozen where they are. Same for columns.

Actual Behavior

The frozen state of a row/column is propagated to the rows/columns being added below/next to them.

Reproduction Steps

1. Have some data in a spreadsheet. Consider adding some format (e.g. bold) to top row for extra visualisation of symptoms.
2. Put a cursor in cell B2.
3. In ribbon select View > Frozen Panes > Freeze panes (for example). You should get both first row and column frozen in place, so they don't move when you scroll.
4. Put cursor again in cell B2.
5. In ribbon select Home > Insert cells (icon on the right side) > Add whole row.
6. See the frozen state move while it shouldn't. If you added formatting in step 1 it will also propagate to the new row of cells.

Additional information

I believe this is an implementation issue, for two reasons:

1. Also other formatting follows this pattern and gets inherited by newly added rows/columns - font, background colour, bold and italics, cell borders, etc.
2. OnlyOffice allows only inserting cells above or to the left of current position, while some other office suites (I know of LO Calc in particular) allow the other two directions too.

Thinking in terms like "header rows" and "data rows" and "key column" (i.e. structure of many spreadsheets) I suspect it works as follows:

• LO Calc always copies the format from the row/column from which you start the insertion (which cell is selected), and it allows you to insert in any direction. So adding new "data rows" from existing "data rows" works naturally, and the same for new "header rows" (I'm not now 100% sure if this works properly with freezing, but other formatting works as expected).
• OnlyOffice on the other hand allows inserting only in one direction for rows and one for columns. It may not be always best to take the format/freezing from the starting row/column, which forces you to make a choice from where to copy the format. And you simply picked the wrong choice for many use cases, especially considering the kind of common thinking about spreadsheets as described above.

I suspect you may need to first allow adding rows/columns in all directions, before you can fix the issue here.

[janxkoci]

Fun fact - I discovered this while editing a table of samples for one project, with first row with header frozen in place. I wanted to add a new sample at the top above all others into the second row. Currently, there is no smooth way to add a new data row below the header. The inserted data row will inherit everything from the header row above (format, frozen state) instead of from the data row below.

[rsnegirev]

Hi @janxkoci

I can confirm, this is the bug 63532 in our internal issue tracker.

Also suggestion for improvement with inserting rows/ columns like in the LO Calc is another one issue 63533.

Thank you for the report.

[Rita-Bubnova]

The issue is actual in DocumentServer.