https://bugs.documentfoundation.org/show_bug.cgi?id=133260
--- Comment #3 from zh_CN User Community Liaison <[email protected]> ---
(In reply to zh_CN User Community Liaison from comment #2)
> I can indeed get the desired 15501 result using Shift+Ctrl+Enter on 6.4.4,
> it didn't work on 6.2.8 though.
Actually, it's not the difference between 6.2.8 and 6.4.4 at all, but rather:
1. Make sure recalculation is done on load (Tools > Options > LibreOffice Calc
> Formula > Recalculaion on File Load > Excel 2007 or newer, set to "Always
recalculate";
2. Open the original sample file attachment 161113;
3. Click in Cell D17, it shows the wrong result 9812;
4. Press Shift+Ctrl+Enter to try to change it to an array input;
5. [Here is what's wrong] Nothing changes, D17 is still 9812, checking D17's
formula, no curly brackets so not an array. Pressing Ctrl+Shift+Enter in
formula bar without modifying the formula doesn't work either;
7. However, if one modifies the formula then press Shift+Ctrl+Enter, now it
works, D17 shows correct result and the fomular has outmost curly brackets.
But this is a minor issue and probably will be resolved along with the main
issue reported here.
--
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
