[Libreoffice-bugs] [Bug 123863] Sumproduct delivers wrong result from calculated external data

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to m.a.riosv from comment #4)
> I did with the file attached by the reporter.
> Changing sheet name 'Stückliste' by 'Stuckliste' (ü -> u) and doing a hard
> recalc and works for me.

hard recalc worked for me without changing the sheetname as follows:

- open "BUG SumProduct.ods"
- do *not* press [Enable Content]
- Ctrl+Shift+F9 (hard recalc)
- cell C1 is 8

but *not* if i press [Enable Content]
- open "BUG SumProduct.ods"
- press [Enable Content]
- Ctrl+Shift+F9 (hard recalc)
- rename sheet to 'Stuckliste'
- Ctrl+Shift+F9 (hard recalc)
- cell C1 is 0

-- 
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/20190308/35a3b8be/attachment.html>