https://bugs.documentfoundation.org/show_bug.cgi?id=99734
Bug ID: 99734
Summary: Average of external linked cells are incorrect
Product: LibreOffice
Version: 5.1.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 124918
--> https://bugs.documentfoundation.org/attachment.cgi?id=124918&action=edit
Screenshot of the Bug
Reproduction:
1. Open two files and save them
2. In file B add a few values with a few cells space between.
3. Copy all the cells
4. Insert into file A with [CTRL- SHIFT - V] a check "link" (don't know if its
correct in German it's "Verknüpfen")
5. Then use formula for average in both files over all cells, also the blank in
between
-> The average of the cells is not the same as it should be.
LibreOffice count the blank cells as cells that have the value '0' not as cells
that should be used for average.
--
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
