https://bugs.documentfoundation.org/show_bug.cgi?id=104888
Bug ID: 104888
Summary: Key combination of Ctrl + Shift + Enter after F2 on
the cell that I carelessly forgot to hold Ctrl and
Shift when I entered matrix related formula should be
treated as a modification to the formula on the cell.
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
STEPS TO REPRODUCE:
1. Set each cell of A1:B2 to the value specified below.
A1: 1
A2: 0
B1: 0
B2: 1
2. Select C1:D2 with cell cursor on C1
3.
type
=MMULT($A$1:$B$2,$A$1:$B$2)
and press Enter but FORGET TO HOLD SHIFT KEY AND CTRL KEY.
4. What you see on the sheet will be the value 1 only in C1 and nothing in
C2,D1 and D2.
* If you fail to forget about shift and ctrl key on step 3, you will also see
value 0 in C2 and D1 cell and 1 in D2. So, C1:D2 will make multiplication of an
identity matrix and itself.
5. Here you notice that you forgot to hold the keys. Select C1:D2 with cell
cursor on C1 again,and you press F2.
6. And then press Enter but DON'T forget to hold ctrl and shift key this time.
EXPECTED RESULT:
C1:D2 will be like what is indicated on * above.
ACTUAL RESULT:
Nothing changes.
ADDITIONAL INFORMATION:.
Cell tries to recalculate when its formula is modified (technically when
modified flag is set to true).
Alt, Ctrl, Shift, Arrow Keys, F2, Enter key on formula bar GENERALLY does not
change its contents, but the case I gave in the STR is one of the exceptions.
When you append something, namely "a", for example, to the formula and delete
it soon between step 5 and step 6, then modified flag is set to true, even
though the initial formula and the final formula are the same. In this case
C1:D2 will look as given in *.
FYI:
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#2279
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#3300
http://opengrok.libreoffice.org/xref/core/editeng/source/editeng/editeng.cxx?r=ee33745ced5ae12f9ae7735fac16a7298ccae474#2651
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#3428
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#3219
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#3245
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#2824
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#2835
http://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=8974b0fafb18f9dd3f2c0e175a3255b80e4c249e#2891
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
