Description:
Hi.

In Calc, if one selects, let's say, cell B2, and then issues INSERT ROW ABOVE command, then the program adds an empty row before row #2 (row #3 contains the orignal row #2 after insertion), HOWEVER unexpectedly for me and pretty much for all of my coworkers, said new empty row always receives formatting copied NOT from the original row #2, but from row #1.

Conversely, if B1 is selected and "insert row below" is issued the EXACT SAME result happens (two seemingly different features function exactly the same).

This means, if you have any table containing formetted column headers in row #1, and data formatted differently below, it is IMPOSSIBLE to insert an empty row before row #1 and be formatted like data below (it is always formatted like headers).

The INSERT COLUMN BEFORE has the same exact problem but in the other direction.

The issue doesn't concern Insert row below and Insert column after, which work correctly.

AFAIK it's been always that way, but IMO this is very unintuitive and quite frankly, really annoying, because what it also means, is that to add new row above with formatting of the selected row, you have to go through extra steps of:
1) inserting empty row above
2) copying entire original row to empty row
3) clear original (now copied) row for new data to enter

This introduces much risk of accidental data alteration and/or table destruction.

And sure enough, many people I work with struggle to understand why you have to do this, then they don't do this or fail to properly swap the content, and many times they or some other poor soul then has to re-format the table again.

Therefor I strongly insist of adding an option in the settings to change described current behavior of INSERT ROW ABOVE and INSERT COLUMN BEFORE to make Calc copy the formatting from the selected row/column to the inserted empty one.

In the attatched example there are 2 examples of tables where INSERT ROW ABOVE and INSERT COLUMN BELOW has been applied and 2 results are presented for each table: one that is currently working, and one which is IMO more intuitive and not confusing.

Regards,


Steps to Reproduce:
1. Select row #1 and format background color as RED
2. Select row #2 and format background color as GREEN
3. Select row #2
4. Issue INSERT ROW BEFORE

Actual Results:
New empty row has RED background.

Expected Results:
New empty row has GREEN background.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Follow attatched example.