Bug 168218 - Calc change formular teilergebnis on ope
Summary: Calc change formular teilergebnis on ope
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-09-01 06:11 UTC by Thomas Sommer
Modified: 2025-09-01 19:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Bug Teilergebnis (subtotal) (102.56 KB, image/jpeg)
2025-09-01 06:11 UTC, Thomas Sommer 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Sommer 2025-09-01 06:11:33 UTC 
Created attachment 202626 [details]
Bug Teilergebnis (subtotal)

opening a calc sheet, 
cells with the funktion subtotal (Teilergebnis) kills the default Range.

I create a formular with =TEILERGEBNIS(9;I7:I159) 

The last entry a the moment is in Cell I59
LibreOffice change the formular to : =TEILERGEBNIS(9;I7:I59)

Problem is that thee Sheet fills up with new entry and we habe at last an entry in i76 and so Clac will noch calculate the new entrys!

That is Bug with the Versions from 25.x and shoud be fix quickly!
Comment 1 Thomas Sommer 2025-09-01 08:05:35 UTC 
LibreOffice 24.8.7 works correkt.
LibreOffice 25.2.5 works correkt.
LibreOffice 25.8.1 not working
if File format ius Excel (xlsx)
ODT works correct!
Comment 2 m_a_riosv 2025-09-01 10:42:09 UTC 
Calc doesn't support dynamic arrays, see:

tdff#127808
Comment 3 Thomas Sommer 2025-09-01 11:18:59 UTC 
why does it works with ods Files but not with XLSX?
TThis is not a dynamic Array. it a formula!
Comment 4 m_a_riosv 2025-09-01 15:29:39 UTC 
It's a formula that must change the result vector, according to the changes on the input range and the criteria. That's a dynamic array.
Comment 5 Thomas Sommer 2025-09-01 16:27:37 UTC 
A BUG IS A BUG!

LibreOffice 24.8.7 works correct with taht in XLSX!
LibreOffice 25.8.1 doesn't!
Comment 6 Werner Tietz 2025-09-01 19:31:43 UTC 
Nobody can confirm by looking on a screenshot!

Please attach a .ods file