https://bugs.documentfoundation.org/show_bug.cgi?id=102525
--- Comment #2 from petrelharp <petrel.h...@gmail.com> ---
Sorry, a mistake in step 2 in copying over the code. Where I say A27:A30 it
should be A1:A4. It should read:
"
To reproduce:
1. Enter numbers 1,2,3,4 in cells A1:A4
2. Type '=IF(A1:A4>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$1:$A$4>2,1,2)}
B2:B4: ={=IF(A$1:A$4>2,1,2)}
"
--
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