https://bugs.documentfoundation.org/show_bug.cgi?id=163929
Bug ID: 163929
Summary: INSERT ROW ABOVE and INSERT COLUMN BEFORE result in
unintuitive (unexpected) formatting of newly added
row/column
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hi.
In Calc, if one selects, let's say, cell B2, and then issues INSERT ROW ABOVE
command, then the program adds an empty row before row #2 (row #3 contains the
orignal row #2 after insertion), HOWEVER unexpectedly for me and pretty much
for all of my coworkers, said new empty row always receives formatting copied
NOT from the original row #2, but from row #1.
Conversely, if B1 is selected and "insert row below" is issued the EXACT SAME
result happens (two seemingly different features function exactly the same).
This means, if you have any table containing formetted column headers in row
#1, and data formatted differently below, it is IMPOSSIBLE to insert an empty
row before row #1 and be formatted like data below (it is always formatted like
headers).
The INSERT COLUMN BEFORE has the same exact problem but in the other direction.
The issue doesn't concern Insert row below and Insert column after, which work
correctly.
AFAIK it's been always that way, but IMO this is very unintuitive and quite
frankly, really annoying, because what it also means, is that to add new row
above with formatting of the selected row, you have to go through extra steps
of:
1) inserting empty row above
2) copying entire original row to empty row
3) clear original (now copied) row for new data to enter
This introduces much risk of accidental data alteration and/or table
destruction.
And sure enough, many people I work with struggle to understand why you have to
do this, then they don't do this or fail to properly swap the content, and many
times they or some other poor soul then has to re-format the table again.
Therefor I strongly insist of adding an option in the settings to change
described current behavior of INSERT ROW ABOVE and INSERT COLUMN BEFORE to make
Calc copy the formatting from the selected row/column to the inserted empty
one.
In the attatched example there are 2 examples of tables where INSERT ROW ABOVE
and INSERT COLUMN BELOW has been applied and 2 results are presented for each
table: one that is currently working, and one which is IMO more intuitive and
not confusing.
Regards,
Steps to Reproduce:
1. Select row #1 and format background color as RED
2. Select row #2 and format background color as GREEN
3. Select row #2
4. Issue INSERT ROW BEFORE
Actual Results:
New empty row has RED background.
Expected Results:
New empty row has GREEN background.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Follow attatched example.
--
You are receiving this mail because:
You are the assignee for the bug.
