[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133260

--- Comment #3 from zh_CN User Community Liaison <plateauwolf at qq.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200523/c5aa9078/attachment.htm>