https://bugs.documentfoundation.org/show_bug.cgi?id=159429
Bug ID: 159429
Summary: summing columns erronious behavior
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Computer HP ZBOOK 15G i7 16GB RAM, OS linux MINT 21.3, LO 7.6.4.1 (bug is in a
previous version too)
Spreadsheet with 2 columns of 20 rows used. Column A contains 1 .. 20, column
B contains 51 .. 70,
cell C1 contains 100.
I want to add the number in C1 to each engaged cell of A and B. I do this
column after column.
Procedure:
Select column A, right click in the field with letter A, choose copy.
Select column E, right click in the field with letter E, choose paste.
Select cell A1, type =, select E1, type +, select C1, go to the field in the
bar where the result is shown and place $ signs before C and 1. Hit Enter. The
correct result shows up in cell A1.
Select A1 and draw downwards with the mouse to A20. Now the correct sum of the
original numbers in column A and C1 shows up.
Select column B, right click in the field with letter B, choose copy.
Select column E, right click in the field with letter E, choose paste.
Now the new content of column A is summed with content the column E.
This is weird!
At the moment that column B is chosen the summing action in column A had to
stop.
--
You are receiving this mail because:
You are the assignee for the bug.
