This feature is working properly? CellRange.computeFunction (com.sun.star.sheet.GeneralFunction.COUNT) So Basic function that originally envisaged not only numbers, but also the string. - You really only counts numerical values. Back many years - but do not know what version of LO (about 4) calculated as a function of the workbook COUNTA. You really counts as ordinary COUNT from the workbook. It just does not take string. For example, in AOO 4.0.1 sentiments were also strings. - I'm not quite sure if this is a bug or intention. I know for sure that this is the cause of many failures of different extensions, functions and macros. I got it almost everywhere. Of course I can work around it, but this is not the solution for all older works worldwide.
Hello I confirm the bug on windows 7/64 & Version: 4.2.0.0.beta2 Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d According to http://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sheet.html#ad184d5bd9055f3b4fd57ce72c781758d com.sun.star.sheet.GeneralFunction.COUNT: all values, including non-numerical values, are counted. with COUNTNUMS: numerical values are counted. Actual result: only numerical values are counted with COUNT Steps to reproduce: 1. Open the attached ComputeFunctionCount.ods (some text and numbers in A1:A5 and COUNT-COUNTA formula in A7:A8) 2.Click on the buttons to launch the macros Expected result: same display as COUNT-COUNTA formula Actual result: same result with GeneralFunction.COUNTNUMS & GeneralFunction.COUNT Was ok with Version: 4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a The macros: Sub MyCount Dim f As Object, c As Object f = ThisComponent.sheets.getByIndex(0) c = f.getCellRangeByName("A1:A5") print c.computeFunction(com.sun.star.sheet.GeneralFunction.COUNT) End Sub Sub MyCountNums Dim f As Object, c As Object f = ThisComponent.sheets.getByIndex(0) c = f.getCellRangeByName("A1:A5") print c.computeFunction(com.sun.star.sheet.GeneralFunction.COUNTNUMS) End Sub Regards Pierre-Yves
Created attachment 90458 [details] ComputeFunctionCount.ods
Created attachment 90468 [details] PNG picture
Greetings. I'm sorry but for me it goes really wrong - send image- Peter
Hello Peter (In reply to comment #4) > I'm sorry but for me it goes really wrong - send image- My english is bad, I may have misspoken but I said: "I confirm the bug on windows 7/64 ... Actual result: only numerical values are counted with COUNT" So, it goes wrong for me too, this is why I confirmed. Regards Pierre-Yves
It's my fault. I do not speak English at all. I can only read a little bit. Should I just use Google translator. Thanks again and excuse Peter ______________________________________________________________ > Od: <bugzilla-daemon@freedesktop.org> > Komu: <neutr@atlas.cz> > Datum: 08.12.2013 17:35 > Předmět: [Bug 72474] It works correctly GeneralFunction.COUNT ? > Comment # 5 on bug 72474 from pierre-yves samynHello Peter(In reply to comment #4)> I'm sorry but for me it goes really wrong - send image-My english is bad, I may have misspoken but I said: "I confirm the bug on windows 7/64...Actual result: only numerical values are counted with COUNT"So, it goes wrong for me too, this is why I confirmed.RegardsPierre-YvesYou are receiving this mail because: * You reported the bug.
The bug is present in 4.2.0.0beta2, but I found it fixed in 4.2.0.2 and newer versions.