https://bugs.freedesktop.org/show_bug.cgi?id=60345
Priority: medium
Bug ID: 60345
Assignee: [email protected]
Summary: sumif formula wildcard in text criteria fails to
match, returns 0 instead of total. Big error.
Severity: critical
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 74267
--> https://bugs.freedesktop.org/attachment.cgi?id=74267&action=edit
spreadsheet
this formula
=sumif(d1:d9999,"paypal*",e1:e9999)
should sum values in e when text in d begins paypal
but it doesn't. it fails to match.
(my expectation of behaviour is based on Excel)
Attached is a spreadsheet showing the problem. In LibreOffice 4.0 rc3 on both
Windows and Mac, the total on the sheet totals is 0.
When the spreadsheet is openened into Excel, the toal is 9120.9
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
