https://bugs.documentfoundation.org/show_bug.cgi?id=164966
Bug ID: 164966
Summary: Adding the sum of the row and the sum of the column
will generate an incorrect formula
Product: LibreOffice
Version: 24.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
must select sum1 of rows ,sum2 of columns ,blank cell ,3 cells at the same
time,use Σ for sum3, then will bug
select d5, e5, and f5 at the same time, and then click the sum function Σ in
the menu bar.
we should get =sum(d5:e5), get 18,but f5 automatically generate =sum(e5:e5) ,
get 13
if type by hand =d5+e5 will get 18
get the sum1 of a row at d5
get the sum2 of a columns at e5
select 3 cell(d5, e5,f5 ) at the same time, click menu Σ to sum.
3 cells, the first cell is the sum of the row, the second cell is the sum of
the column, and the third cell is a blank cell
the result will be wrong. it will not include the first cell (sum1) in the
calculation.
the sum of each row plus the sum of each column always results in an incorrect
calculation, must use Σ for sum3
Adding the sum of the row and the sum of the column will generate an incorrect
formula
Steps to Reproduce:
1.get the sum1 of a row at d5
2.get the sum2 of a columns at e5
3.select d5, e5, and f5 at the same time, and then click the sum function Σ in
the menu bar.
we should get =sum(d5:e5), get 18,but f5 automatically generate =sum(e5:e5) ,
get 13
Actual Results:
but f5 automatically generate =sum(e5:e5) , get 13
Expected Results:
we should get =sum(d5:e5), get 18
Reproducible: Always
User Profile Reset: Yes
Additional Info:
In the past year, I have reproduced this bug in multiple versions of the
software and on 6 computers in different office locations. You deleted my last
submission record, I ask you to take it seriously this time.
The bug is confirmed to exist, maybe my English level is too poor, so I didn't
express it clearly enough.
--
You are receiving this mail because:
You are the assignee for the bug.
