https://bugs.documentfoundation.org/show_bug.cgi?id=102525
Bug ID: 102525
Summary: F4 breaks array formula
Product: LibreOffice
Version: 5.2.0.4 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: petrel.h...@gmail.com
Using the F4 shortcut to change absolute/relative referencing breaks array
formulae, at least for me with version 5.2.0.4, build id 1:5.2.0-2, installed
with apt-get on debian sid.
To reproduce:
1. Enter numbers 1,2,3,4 in cells A1:A4
2. Type '=IF(A27:A30>2,1,2)' and do ctrl-shift-enter in B1.
- this produces {2,2,1,1} in column B, as expected.
3. Select B1:B4 and hit F4.
Expected result: values don't change but $'s appear in the array formula.
Actual result: values change to Err:512, because the formula are (a) no longer
an array formula, but instead separate formulae, and (b) now read:
B1: ={=IF($A$27:$A$30>2,1,2)}
B2:B4: ={=IF(A$27:A$30>2,1,2)}
best, peter.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs