[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 --- Comment #10 from ady --- Still repro with: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9a555d79b3b00793edf1d51a8a7c76b723cc436d CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Built: 2023-04-27 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 Eike Rathke changed: What|Removed |Added Attachment #177583|1 |0 is patch|| Attachment #177583|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 --- Comment #9 from ady --- (In reply to ady from comment #8) > (In reply to Eike Rathke from comment #7) > > What actually is the problem? In addition to the strange results from COUNTIF(), by copy+pasting the original random values from attachment 177583 from comment 2 as fixed values, then saving as new file and reloading, the correct results for countif() are shown, but not with recalculate hard. So, recalculate hard generates different countif() results than save+reload (not related to rand()). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 --- Comment #8 from ady --- (In reply to Eike Rathke from comment #7) > What actually is the problem? STR: 1. Open attachment 177583 from comment 2 2. [CTRL]+[SHIFT]+[F9] repeatedly until some numeric values in column D have their background color changed according to their conditional format. Step 2 might take several tries, but it will happen eventually. The BG color in column D shows repeating values, which in theory would only happen when there are repeating values in column A too, but it is clearly not always the case in attachment 177583. Thus, it would hint at some problem in COUNTIF(). I tried replicating the same situation with column A being integers (instead of [0...1], and it was clearly less likely to happen. So, is this because natural accuracy issues? IDK. (FWIW, bug 151958, also related to COUNTIF() doesn't seem to be related to accuracy.) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 Eike Rathke changed: What|Removed |Added CC||er...@redhat.com --- Comment #7 from Eike Rathke --- What actually is the problem? Loading (and recalculating) attachment 177728 has the correct result 4. Version: 7.5.4.0.0+ (X86_64) / LibreOffice Community Build ID: 748c1400a4408ad875d72044bb635524cfeddf4d CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Calc: threaded Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 8a9936e2f8a30cc24279f4a749984f15bd2aaec8 CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: en-CA (en_CA.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 --- Comment #6 from ady --- Repro in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5cd9de202765e243e41416802f3e4486b8a96f16 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded Built on 2023-04-21 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||1958 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 BogdanB changed: What|Removed |Added Blocks||108253 CC||buzea.bog...@libreoffice.or ||g Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108253 [Bug 108253] [META] Calc cell formula bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 GDH changed: What|Removed |Added CC||georges.der-hagopian@outloo ||k.com --- Comment #5 from GDH --- Created attachment 177731 --> https://bugs.documentfoundation.org/attachment.cgi?id=177731=edit Libre Office Clalc Bug NB.SI() New testing with the last version of Libre Office The test result is unchanged -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 raal changed: What|Removed |Added Keywords|regression | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 --- Comment #4 from raal --- Created attachment 177728 --> https://bugs.documentfoundation.org/attachment.cgi?id=177728=edit test file test file created in excel with fixed values. The problem disappears after reload the file. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 raal changed: What|Removed |Added Ever confirmed|0 |1 Keywords||regression Status|UNCONFIRMED |NEW --- Comment #3 from raal --- I can confirm with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: bd5492275d31f59b1d269205018d1487af52426f CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo but not with Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146790] Problème avec la fonction NB.SI() COUNTIF()
https://bugs.documentfoundation.org/show_bug.cgi?id=146790 raal changed: What|Removed |Added Summary|Problème avec la fonction |Problème avec la fonction |NB.SI() |NB.SI() COUNTIF() CC||r...@post.cz -- You are receiving this mail because: You are the assignee for the bug.