Insert rows above not inheriting format of current row

LO 24.8 - I found this issue when cells were not being centered as in current row

It works for me with Cells formatted by Styles and with cells formatted by manually. LO 24.8.4.2 portable.

Centered_LO24_8_4_2.ods (22.7 KB)

No, the new row inherits the formatting of the row above, not the row below.
That is, inserting a row above, doesn’t inherit from the row your cursor is in

3 Likes

This is crazy so adding row above or below current row act the same? Whichever way you add rows, they should copy the format of the reference row. So, you are saying if row 10 has some headings and rows 11 and below have details to the headings and I want to add another detail ABOVE the top detail in row 11 that it is not logical to copy the format of row 11 to the new inserted row 11? If I wanted the heading format to be applied to a new row 11, I would select row 10 and add below.

Calc assumes that you insert new rows directly below existing rows.
If you want to insert new rows directly below a header row, insert a blank formatted row below the heading. You may hide that row.

Ah well, then Excel 2010 is crazy too. Sometimes people want the devil they know.

But see Bug 113687 - Wrong cell attributes assumed

1 Like