https://bugs.freedesktop.org/show_bug.cgi?id=72196
--- Comment #2 from Sebastian Sauer <[email protected]> --- Some details how to reproduce (sry, don't have msexcel at hand atm to produce+attach xls/xlsx): Sheet: A B 1 test1 11 2 test2 22 Formula: =SUMIF(A1:A2, "test*", B1:B2) Result in OO/LO: 0 Expected as shown in Excel which only knows about the wildcard-mode: 33 Now change the formula in LO to (note that "*" becomes ".*"): =SUMIF(A1:A2, "test.*", B1:B2) and active the ODF regexp-mode in Tools=>Options=>LO Calc=>Calculation=>Enbable regular expressions in formulas. 33 is displayed. Problems: 1. regex vs wildcards where LO only supports regex. 2. when importing Excel xls/xlsx users need to manually change wildcards to regular expressions. 3. after done users need to manually enable regex in formulas in the options. 4. on export to xls/xlsx users need to manually change regex back to wildcards else Excel will produce different results cause it only supports wildcards and not regex. 5. Incompatible with any other ODF producer/consumer that supports HOST-USE-WILDCARDS. Many problems. Point 2 is a real deal-breaker cause it makes it impossible for Excel spreadsheet-producers to also cover LibreOffice (eg by runtime-determination in a sheet if it runs in LO and then use regex in formulas rather then wildcards) without user-interaction. Since there are no alternates to functionality like SUMIF+wildcards and since lot of basic formulas are affected lot of use-case scenarios cannot be done in a compatible way :-/ -- 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
