https://bugs.documentfoundation.org/show_bug.cgi?id=95670
Bug ID: 95670
Summary: CALCULATING: some text functions doesn't work inside
SUMPRODUCT, they need the function introduced as
array.
Product: LibreOffice
Version: 5.1.0.0.alpha1
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: miguelange...@libreoffice.org
Created attachment 120380
--> https://bugs.documentfoundation.org/attachment.cgi?id=120380&action=edit
Sample file SUMPRODUCT bug
Attached a basic sample file.
Where LEFT() inside SUMPRODUCT() works only with SUMPRODUCT() forced as array
[Ctrl+Enter]
Happens the same with RIGHT(), MID(), T(), N() or DAY().
Seems no function works now inside SUMPRODUCT() without an explicit array.
Seems a very recent regression:
Win10x64
Works with:
Versión: 4.4.6.2 Id. de compilación: 008d5d0ddffba0b82de2a2c36a65b9cba0a6b328
TinderBox: Win-x86@51-TDF, Branch:libreoffice-4-4, Time: 2015-10-14_08:09:18
Version: 5.0.3.2 (x64) Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Version: 5.1.0.0.alpha1 (x64) Build ID:
0b48731919433e46e4fda7e5a5ca27c08c28b981
Fails with:
Version: 4.4.7.0.0+ Build ID: 61a7e6f039294103a1721ec95724d067cf205d0b
TinderBox: Win-x86@51-TDF, Branch:libreoffice-4-4, Time: 2015-11-03_20:33:02
Version: 5.0.4.0.0+ Build ID: a93c08e8eeb8386d02a015c63d161220d059a6bf-GL
TinderBox: Win-x86@62-merge-TDF, Branch:lo-5-0, Time: 2015-11-03_16:36:47
Version: 5.1.0.0.alpha1+ (x64) Build ID:
048d47d54d72babe49920ea5e8ff934fe0032125
TinderBox: Win-x86@42, Branch:master, Time: 2015-10-30_19:51:10
Version: 5.1.0.0.alpha1+ (x64) Build ID:
04783fd91832fa01a5b096f395edd7ad4f9c0f6b
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-11-07_21:35:01
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
