Bug 108016 - Calc: Insert Row Above should use format of selected row instead of previous row
Summary: Calc: Insert Row Above should use format of selected row instead of previous row
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 144007 (view as bug list)
Depends on:
Blocks: Calc-Styles Cell-Management
  Show dependency treegraph
 
Reported: 2017-05-23 06:01 UTC by Kevin
Modified: 2022-04-12 21:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
spreadsheet includes full steps, analysis, and everything necessary to repro report 108016 (17.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-23 06:02 UTC, Kevin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin 2017-05-23 06:01:31 UTC
Description:
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
2.
3.

Actual Results:  
Calc doesn't offer the flexibility to save time in formatting.

Expected Results:
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.


Reproducible: Always

User Profile Reset: No

Additional Info:
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
Comment 1 Kevin 2017-05-23 06:02:57 UTC
Created attachment 133465 [details]
spreadsheet includes full steps, analysis, and everything necessary to repro report 108016
Comment 2 V Stuart Foote 2017-05-23 06:51:32 UTC
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.
Comment 3 Kevin 2017-05-23 07:18:10 UTC
> 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.
Comment 4 Timur 2021-08-23 08:07:30 UTC
*** Bug 144007 has been marked as a duplicate of this bug. ***
Comment 5 Timur 2021-08-23 08:12:18 UTC
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".