[Libreoffice-bugs] [Bug 136404] New: Writer table function COUNT gives different result than in Word

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136404

            Bug ID: 136404
           Summary: Writer table function COUNT gives different result
                    than in Word
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Writer
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org
            Blocks: 103100

Created attachment 165029
  --> https://bugs.documentfoundation.org/attachment.cgi?id=165029&action=edit
Example file from Word with COUNT table function

Recently the COUNT table function was added to Writer.
In Word this counts the number of numeric values in the table.
In Writer however it counts the number of non-empty cells.

Steps to reproduce:
    1. Open attached file in Writer

Actual results:
Cell A1 contains number 3 instead of 2. Cell A2 contains 3 instead of 0.
Also happens if a new COUNT function is inserted from the Formula bar set to
count the B1:B3 range. If the cells are empty, COUNT still gives 3 instead of
0.

Expected results:
COUNT counts the numeric values in the range, so empty and text cells are not
counted.

LibreOffice details:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 4c20bb789c7536f63a6844a4cb4489a18cee53c7
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=103100
[Bug 103100] [META] Writer table bugs
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200902/c1b6fe15/attachment.htm>