The root cause is that, unlike Excel, Calc always uses the formatting of the row above, regardless of whether you insert above or below and regardless of which row you apply that operation to.
I've typed the steps into the attached spreadsheet along with some formatted cells so you can do the steps yourself as you read them.
Steps to Reproduce:
1.see spreadsheet titled with the number of this report
Calc doesn't offer the flexibility to save time in formatting.
Calc should be as good or better than Excel in all cases. I've said this one every report I've entered, so you might wonder why I don't just use Excel. It's because for every time Calc fails to live up to Excel, it exceeds in at least two other instances.
User Profile Reset: No
I call this a bug because I believe the spec should be "do no harm - Calc must not be worse than Microsoft Excel" - if that's not the spec then this is of course an enhancement request. As always, I implore you to have someone who tests only formatting, not math functions. If you do this, you'll see how frustrating this aspect of the program is.
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36
Created attachment 133465 [details]
spreadsheet includes full steps, analysis, and everything necessary to repro report 108016
OK, a valid enhancement.
Believe though that as we implement additional conditional formatting and styles in Calc--formatting an inserted row/column by applied style--after insertion-- will achieve needed functionally.
> Believe though that as we implement additional conditional formatting and
> styles in Calc--formatting an inserted row/column by applied style--after
> insertion-- will achieve needed functionally.
Question: Will your conditional formatting work with cells that are defined as text rather than values? I've tried to use styles to apply a certain border/background pattern but it never works - the style UI doesn't allow me to ask it to, for example, ignore the font and size and only apply the border/background.
*** Bug 144007 has been marked as a duplicate of this bug. ***
This is not clearly reported as is bug 144007:
Insert Row Above should use format of selected row instead of previous row.
All talk about MSO is not useful, because MSO does the same as LO, inserts row above using format of previous row, except it lacks "insert row below".
*** Bug 154327 has been marked as a duplicate of this bug. ***