Bug 170375 - "Insert rows above" takes format from the row above, should use current row
Summary: "Insert rows above" takes format from the row above, should use current row
Status: RESOLVED DUPLICATE of bug 113687
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.8.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Add-Delete
  Show dependency treegraph
 
Reported: 2026-01-17 21:45 UTC by Eyal Rozenberg
Modified: 2026-01-19 08:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2026-01-17 21:45:17 UTC
Reproduction instructions:

1. Create a new spreadsheet
2. Select the entire first row and set its background color to Orange.
3. Select the entire second row and set its background color to Cyan.
4. Make a cell in the first row active.
5. Insert a row below (e.g. via the menus: Sheet > Insert Rows > Rows Below); note the background color of the inserted row.
6. Undo action (5.) (e.g. via the menus: Edit > Undo: Insert)
7. Make a cell in the second row active.
8. Insert a row above (e.g. via the menus: Sheet > Insert Rows > Rows Above); note the background color of the inserted row.

Expected results:
After step (5.), the inserted middle row is Orange;
After step (8.), the inserted middle row is Cyan.

Expected results:
After step (5.), the inserted middle row is Orange;
After step (8.), the inserted middle row is Orange.

it seems that, in the code, "Insert rows above" is implemented as: "Go one row up and insert row below". But that's not what the user wants: The user wants to replicate for format of the active row, not of the previous row.
Comment 1 m_a_riosv 2026-01-18 13:48:42 UTC

*** This bug has been marked as a duplicate of bug 113687 ***