[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #15 from David Lynch --- If it needs to be like this, could the workaround be put in the documentation please? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #14 from Eike Rathke --- Hard stuff. Though IMHO there is nothing wrong. In general, COUNTIF() and others for a string criterion follow the setting Tools -> Options -> Calc -> Calculate, General Calculations, either wildcards, regular expressions, or none. However, the first attempt is to convert the string criterion to number, ".0" => 0.0 and so on, and if successful the match will not be a regular expression match but a numeric match. Which when switching to a locale where the decimal separator is not dot makes it suddenly work. To force regex instead of numeric use some expression that can not be "misread" as numeric, for example ".[0]" or ".\0" or "(?i).0" (for case insensitive match of the entire expression, which the default is anyway). There's not much we can do about this "numeric first" behaviour, it is expected. And yes, in the different locales context it is awkward. Blame Excel. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #13 from m.a.riosv --- Looks it works fine only with languages having comma as decimal separator. Maybe is there something else affecting the issue, I can't believe it wasn't reported. There is also a bug https://bugs.documentfoundation.org/show_bug.cgi?id=93510, about 'Regular expressions do not works when enabled automatically find columns and rows labels', but changed that option doesn't affect this one. Hi @Eike can you take a look, seems critical for the affected people, SUMIF and SUMIFS are also affected. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #12 from David Lynch --- Confirmed. If I set my locale to Spanish(Spain), the answers are correct. Version: 6.3.2.2 (x64) Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: es-ES (en_GB); UI-Language: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 Oliver Brinzing changed: What|Removed |Added Version|6.3.2.2 release |Inherited From OOo --- Comment #11 from Oliver Brinzing --- already reproducible with: Version 3.6.7.2 (Build ID: e183d5b) and AOO 4.1.5 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 Oliver Brinzing changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #10 from Oliver Brinzing --- (In reply to m.a.riosv from comment #9) > Well I'm not able to figure out what can be, no changes in calculation or > formula options for calc makes any difference. It's the "Locale setting" (Menu "Tools/Options.../Language Settings/Languages") with: Version: 6.4.0.0.alpha1+ (x64) Build ID: 885ae558d34dd76955c727b90eb9ae52ce85df7f CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; Locale: en-US (de_DE); UI-Language: en-US Calc: i have wrong results too... -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 m.a.riosv changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #9 from m.a.riosv --- Well I'm not able to figure out what can be, no changes in calculation or formula options for calc makes any difference. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #8 from David Lynch --- This makes no diffrence I always have wrong results: no thread 50 0 =COUNTIF(A1,".0") wrong 50 =REGEX(A1,".0") right 0 1 =COUNTIF(A2,".0") wrong #N/A=REGEX(A2,".0") right a0 0 =COUNTIF(A3,".0") wrong a0 =REGEX(A3,".0") right 57 0 =COUNTIF(A4,".7") wrong 57 =REGEX(A4,".7") right 57 0 =COUNTIF(A5,".7") wrong 57 =REGEX(A5,".7") right 7 0 =COUNTIF(A6,".7") right #N/A=REGEX(A6,".7") right a7 0 =COUNTIF(A7,".7") wrong a7 =REGEX(A7,".7") right 7a 1 =COUNTIF(A8,".a") right 7a =REGEX(A8,".a") right ab 1 =COUNTIF(A9,".b") right ab =REGEX(A9,".b") right 50 0 =COUNTIF(A10,"5.") wrong 50 =REGEX(A10,"5.") right 50 0 =COUNTIF(A11,"5.") wrong 50 =REGEX(A11,"5.") right a0 1 =COUNTIF(A12,"a.") right a0 =REGEX(A12,"a.") right threaded 50 0 =COUNTIF(A1,".0") wrong 50 =REGEX(A1,".0") right 0 1 =COUNTIF(A2,".0") wrong #N/A=REGEX(A2,".0") right a0 0 =COUNTIF(A3,".0") wrong a0 =REGEX(A3,".0") right 57 0 =COUNTIF(A4,".7") wrong 57 =REGEX(A4,".7") right 57 0 =COUNTIF(A5,".7") wrong 57 =REGEX(A5,".7") right 7 0 =COUNTIF(A6,".7") right #N/A=REGEX(A6,".7") right a7 0 =COUNTIF(A7,".7") wrong a7 =REGEX(A7,".7") right 7a 1 =COUNTIF(A8,".a") right 7a =REGEX(A8,".a") right ab 1 =COUNTIF(A9,".b") right ab =REGEX(A9,".b") right 50 0 =COUNTIF(A10,"5.") wrong 50 =REGEX(A10,"5.") right 50 0 =COUNTIF(A11,"5.") wrong 50 =REGEX(A11,"5.") right a0 1 =COUNTIF(A12,"a.") right a0 =REGEX(A12,"a.") right -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #7 from Oliver Brinzing --- (In reply to m.a.riosv from comment #6) > Please test playing with 'Calc: threaded' Menu/Tools/Options/LIbreOffice > calc/Calculate. this seems to make no difference, i have always correct results -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #6 from m.a.riosv --- Please test playing with 'Calc: threaded' Menu/Tools/Options/LIbreOffice calc/Calculate. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #5 from Oliver Brinzing --- with Version: 6.3.3.2 (x64) Build ID: a64200df03143b798afd1ec74a12ab50359878ed CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: i have following results: 50 1 =COUNTIF(A1;".0") wrong 50 =REGEX(A1;".0") right 0 0 =COUNTIF(A2;".0") wrong #N/A=REGEX(A2;".0") right a0 1 =COUNTIF(A3;".0") wrong a0 =REGEX(A3;".0") right 57 1 =COUNTIF(A4;".7") wrong 57 =REGEX(A4;".7") right 57 1 =COUNTIF(A5;".7") wrong 57 =REGEX(A5;".7") right 7 0 =COUNTIF(A6;".7") right #N/A=REGEX(A6;".7") right a7 1 =COUNTIF(A7;".7") wrong a7 =REGEX(A7;".7") right 7a 1 =COUNTIF(A8;".a") right 7a =REGEX(A8;".a") right ab 1 =COUNTIF(A9;".b") right ab =REGEX(A9;".b") right 50 1 =COUNTIF(A10;"5.") wrong 50 =REGEX(A10;"5.")right 50 1 =COUNTIF(A11;"5.") wrong 50 =REGEX(A11;"5.")right a0 1 =COUNTIF(A12;"a.") right a0 =REGEX(A12;"a.")right -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #4 from David Lynch --- Created attachment 155441 --> https://bugs.documentfoundation.org/attachment.cgi?id=155441=edit Screen shot showing bug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 --- Comment #3 from David Lynch --- Your results are indeed correct. I attach a screenshot of my results (in safe mode). I get the same results on another (Windows) computer. Version: 6.3.2.2 (x64) Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-GB (en_GB); UI-Language: en-US Calc: threaded I can't think of any more detail to give you. Let me know if you want more. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- Please detail at least some of supposed wrong values, COUNTIF does the same as REGEX for me. 50 1 =COUNTIF(A1;".0") wrong 50 =REGEX(A1;".0")right 0 0 =COUNTIF(A2;".0") wrong #N/A=REGEX(A2;".0")right a0 1 =COUNTIF(A3;".0") wrong a0 =REGEX(A3;".0")right 57 1 =COUNTIF(A4;".7") wrong 57 =REGEX(A4;".7")right 57 1 =COUNTIF(A5;".7") wrong 57 =REGEX(A5;".7")right 7 0 =COUNTIF(A6;".7") right #N/A=REGEX(A6;".7")right a7 1 =COUNTIF(A7;".7") wrong a7 =REGEX(A7;".7")right 7a 1 =COUNTIF(A8;".a") right 7a =REGEX(A8;".a")right ab 1 =COUNTIF(A9;".b") right ab =REGEX(A9;".b")right 50 1 =COUNTIF(A10;"5.") wrong 50 =REGEX(A10;"5.")right 50 1 =COUNTIF(A11;"5.") wrong 50 =REGEX(A11;"5.")right a0 1 =COUNTIF(A12;"a.") right a0 =REGEX(A12;"a.")right Version: 6.3.3.1 (x64) Build ID: f41f4c7f9507aeca13cb9df51f34d80e8ba30a99 CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: Version: 6.4.0.0.alpha0+ (x64) Build ID: 758516295e5f69393bd78bb4af6e7214d48ece0b CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 128503] Incorrect results from regular expresions from COUNTIF (but not from REGEX)
https://bugs.documentfoundation.org/show_bug.cgi?id=128503 David Lynch changed: What|Removed |Added CC||david_ly...@blueyonder.co.u ||k --- Comment #1 from David Lynch --- Created attachment 155426 --> https://bugs.documentfoundation.org/attachment.cgi?id=155426=edit Incorrect results from regular expresions from COUNTIF -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs