Issue 40366

Summary: EaseOfUse: Insert Row function is inconsistent
Product: Calc Reporter: colm.smyth
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, mh.hh
Version: 680m70   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description colm.smyth 2005-01-11 12:10:40 UTC
The Insert Row function is inconsistent and hard to use:
- it inserts a row above the current row
- it uses the formatting information from the above row
- it does not use the cell structure of the above row (no merged cells)

It would be easier to use if:
- it inserts the row above the current row
- it uses the formatting information from the *current* row
- it uses the cell structure of the current row (merging cells as appropriate)
Comment 1 oc 2005-01-12 15:15:03 UTC
Changing issuetype to enhancement and owner requirements
Comment 2 2007-06-26 03:40:53 UTC
*** Issue 78085 has been marked as a duplicate of this issue. ***
Comment 3 mhatheoo 2008-02-07 20:40:49 UTC
OOo 2.3.1  - This issue is still valid/unsolved

==> OC
Question please:
Why do you treat this as an request for enhencement?
It does not do what it is expected to do - so it is a defect, isn't it?

Comment 4 mhatheoo 2008-07-16 23:02:19 UTC
this issue is still an issue in 2.4.1 aswell as in 3.0Beta2

I treat progies doing unexpected things that need manual repair as buggy, the
issue-type needs to be set to "defect".

Just for the records:
Row-insert is like insert-row-above (content moves down) which means
"out-of-the-way-for-the-above" and duplicating the hard-formatted settings.
so practically it is an "insert-below" from the row above.

All wellknown other programms will use selections like "insert below/insert
above", and that choice is right - to my point of view.

However, the actual OO-behavior is wrong as you can see at another place:
Insert cell will move the content as request - and duplicate the hard-formatted
setting of the untouched cells above. By that you can break hard formatted
settings you had apllied for rows before the insert operations.  
Note: moving a cell is a moving - what might be usefull(logical) with rows is
senseless with single cells. And: cell-insert and row-insert should behave in an
equivalent manner.

So the best would be to enable the below/above dialog and duplicated the formats
from where one has started. that is foreseeable and reasonable.


Comment 5 datalance 2009-02-23 13:04:25 UTC
My example of this is that I have a sheet which is wholly 8pts font and has
borders separating certain columns for sectioning the data.
Insert a row and it inserts at 10 pts with no border and I have to change it
every time.
I want it to copy the formatting of the row it inserted above.