https://bugs.freedesktop.org/show_bug.cgi?id=86139
Bug ID: 86139
Summary: EDITING: Cannot insert/delete rows in a matrix of
cells (or right above it)
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
(Issue also exists in LibO 4.3.3.2)
Problem description:
Once you have created one or several matrices of cells in a spreadsheet, you
cannot add or delete rows anywhere between the first and the last row of any of
the matrices. You cannot even insert several rows at once right above a cell
matrix (as soon as the selection before the insertion makes you select some
rows of the matrix).
To perform the row insertion/deletion, you have to select every matrix of
cells, delete their contents (especially the matrix formulas), do the
insertion/deletion, and recreate the matrices from scratch (assuming you copied
the matrix formulas somewhere else before deleting them).
When the spreadsheet contains a matrix of several hundreds cells (or worse,
several such matrices), this is quite painful and user-unfriendly.
How to reproduce the issue, starting with an empty spreadsheet:
- Check step: select rows 2 to 4 and right-click on the row number column:
"Insert Rows Above" and "Deleted Selected Rows" are part of the pop-up menu
items. This is OK.
- Check step: select rows 3 to 6 and right-click on the row number column:
"Insert Rows Above" and "Deleted Selected Rows" are part of the pop-up menu
items. This is OK.
- Now, select cells B4 to B8.
- Type "=1+1" then Ctrl+Shift+Enter. Note that from now on, when current cell
is B4, B5, B6, B7 or B8, formula in formula bar is shown within curly brackets
("{=1+1}").
- Select rows 3 to 6 and right-click on the row number column: no more "Insert
Rows Above" and "Deleted Selected Rows" in the pop-up menu. This is not OK.
- Select rows 2 to 4 and right-click on the row number column: no more "Deleted
Selected Rows" in the pop-up menu. No more "Insert Rows Above" either, despite
the fact inserted rows would be outside the cell matrix anyway. This is not OK.
Note that changing the setting "Tools > Options > LibreOffice Calc > General >
Extend references when columns/rows are added" does not change anything here.
Expected result:
Row insertion/deletion should be possible within or right above a matrix of
cells.
Note that Microsoft Excel allows inserting/deleting rows in cell matrices, and
it properly extends formulas within them.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
