Apache OpenOffice (AOO) Bugzilla – Issue 40366
EaseOfUse: Insert Row function is inconsistent
Last modified: 2013-08-07 15:12:27 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)
Changing issuetype to enhancement and owner requirements
*** Issue 78085 has been marked as a duplicate of this issue. ***
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
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
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.