https://bugs.documentfoundation.org/show_bug.cgi?id=163293
Bug ID: 163293
Summary: formula result depends on location of the formula?
Product: LibreOffice
Version: 24.8.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Sorry for the title, I am not sure how to describe this in one sentence.
I found an unexpected behavior. The result of a formula changes according to
where that formula is located, even if the ranges are fixed.
Steps to Reproduce:
In the test file, there are 2 formulas in red, and 2 formulas in blue.
The only difference between them is their location.
Actual Results:
The results differ (see yellow painted cells).
Expected Results:
I would expect that identical references with exactly the same range give
exactly the same results.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
And what is this behavior anyway? If you write a formula like this =(A1:A10),
what is the expected result? The actual result is that Calc shows the number of
column A that is on the same row as the cell with the formula. Does this make
sense? Is it the intended behavior? I think it is very confusing.
Consider the formula '=SUM((A1:A9)/A10)' that someone may write by mistake of
whatever reason. I would argue that this is wrong and the correct way is
'=SUM(A1:A9)/A10'. However the former will yield a result if the formula cell
is located anywhere between rows 1 and 9. This is very confusing and unexpected
to my anyways. Also if you place that formula in row 10 o larger, you get
#VALUE. This is caused by the fact that '=(range)' results in copying the
number belonging to that range that is in the same row as the formula cell.
I find this very strange and I would argue is not a good practice. If this is
not a bug, is this really intended? or inherited for back-compatibility, etc.?
As I mentioned, I would expect that identical references with exactly the same
range give exactly the same results, no matter where the formula cell is
located.
___________
Version: 24.8.1.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 24; OS: Linux 6.8; UI render: default; VCL: qt5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:24.8.1-0ubuntu0.22.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
