https://bugs.documentfoundation.org/show_bug.cgi?id=152091
Bug ID: 152091
Summary: Addition of several groups of contiguous cells gives
"#Value!"
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
On pc Debian x86-64 with LO 7.4.2.3, I got "#Value!" when trying a formula
like:
=A1:A2+A5:A6+A9:A10
I must recognize I'm not sure if it's a bug or not. Perhaps it's the way it
should be.
Steps to Reproduce:
1. Retrieve attachment
2. See A13
Actual Results:
#Value!
Expected Results:
Either 210
or if we absolutely want to mimick Excel:
90
120
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.2.3 / LibreOffice Community
Build ID: 40(Build:3)
CPU threads: 12; OS: Linux 6.0; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Debian package version: 1:7.4.2-3
Calc: threaded
I could also reproduce this with master sources updated today.
--
You are receiving this mail because:
You are the assignee for the bug.
