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: [email protected]
Reporter: [email protected]
CC: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
