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