https://bugs.freedesktop.org/show_bug.cgi?id=72474
pierre-yves samyn <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] | |et See Also| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=46119 Keywords| |regression Ever confirmed|0 |1 --- Comment #1 from pierre-yves samyn <[email protected]> --- 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 -- 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
