https://bugs.documentfoundation.org/show_bug.cgi?id=170113
Bug ID: 170113
Summary: AutoSum ignores calculated cells when determining
range in LibreOffice Calc
Product: LibreOffice
Version: 25.2.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In LibreOffice Calc, the Sigma (AutoSum) button is intended to quickly create
formulas based on selected cells.
However, its behavior is incorrect when the selection includes both calculated
cells and numeric cells.
For example:
Cell A3 contains a formula returning a number.
Cell A4 contains a numeric value.
I select cells A3 and A4 and press the Sigma button.
Resulting formula: SUM(A4:A4)
Expected formula: SUM(A3:A4)
The AutoSum function seems to ignore calculated cells when determining the
range, even though they are part of the selection.
Steps to Reproduce:
1. Enter two numeric values in cells A1 and A2.
2. In cell A3, create a formula that sums A1 and A2 (=A1+A2).
3. Enter a numeric value in cell A4.
4. Select cells A3 and A4.
5. Click the Sigma (AutoSum) button.
Actual Results:
SUM(A4:A4)
Expected Results:
SUM(A3:A4)
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.2.6.2 (X86_64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
