Bug 86141 - EDITING (improvement): making matrix formula edition easier and more user-friendly
Summary: EDITING (improvement): making matrix formula edition easier and more user-fri...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-UX Cell-Formula
  Show dependency treegraph
 
Reported: 2014-11-11 09:25 UTC by Olivier DESCOUT
Modified: 2019-02-15 21:41 UTC (History)
1 user (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 Olivier DESCOUT 2014-11-11 09:25:05 UTC
Problem description: 
Once you have created a matrix of cells in a spreadsheet, you need to select precisely every cell of the matrix and only those (and you have to guess where the matrix starts and where it ends as there are no visible matrix delimiters) before being allowed to edit the matrix formula. This is a rather painful. Editing the matrix formula could be easier and more user-friendly than that.

How to reproduce the issue, starting with an empty spreadsheet:
- 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 (that is, any cell of the matrix we just created), formula in formula bar is shown within curly brackets ("{=1+1}").
- Go to any cell of the matrix (e.g. B7) and press F2. Calc only opens a pop-up box saying something like "Cannot modify a part of the matrix only".
- Select B5 to B8 and press F2. Calc only opens a pop-up box saying something like "Cannot modify a part of the matrix only".

Expected result:
When pressing F2 to edit the cell(s) in the matrix:
- either Calc would force selecting every cell in the matrix, then edit the matrix formula,
- or Calc would show up a Yes/No dialog box saying "Cannot modify a part of the matrix only. Do you want to edit the entire matrix?" if not all matrix cells are already selected, then, if yes, select every cell in the matrix and edit the matrix formula.
Comment 1 m.a.riosv 2014-11-11 22:07:17 UTC
Hi Olivier, thanks for reporting.

You can go to any cell of the matrix and use [Ctrl]+[/] to select the all matrix.

But you are right would be nice if [F2] could work with matrix like with no matrix.
Comment 2 Olivier DESCOUT 2014-11-11 22:20:58 UTC
Hi Mario,

I didn't know this shortcut, "Ctrl+keypad-slash". I have to admit it makes the matrix edition much easier and this request a nice-to-have-but-can-clearly-live-without! :-)