Issue 40366

Summary:	EaseOfUse: Insert Row function is inconsistent
Product:	Calc	Reporter:	colm.smyth
Component:	formatting	Assignee:	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 paul.m.nz 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?

martin

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

Btw:
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.

Martin

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.