Bug 172370 - SUBTOTAL function doesn't work well, just works as SUM function.
Summary: SUBTOTAL function doesn't work well, just works as SUM function.
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.7.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-06-06 09:43 UTC by tatchan
Modified: 2026-06-09 19:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
bag report in picture. (55.10 KB, image/png)
2026-06-06 09:48 UTC, tatchan 		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 tatchan 2026-06-06 09:43:40 UTC 
Description:
I want make summary of a row with SUBTOTAL function (SUBTOTAL(9, B349:V349)), but it calculates double the value.

I created the data with Excel at first, and I tried to add some new data with LibreOffice Calc.


Actual Results:
The calculation result must be "75,501,140", but it results "151,002,280"...
It works just as SUM function.

Expected Results:
SUBTOTAL function works just as SUBTOTAL function.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
I'd like to show you this bug by picture. Can't I send it?
Comment 1 tatchan 2026-06-06 09:48:03 UTC 
Created attachment 207374 [details]
bag report in picture.
Comment 2 raal 2026-06-06 21:47:51 UTC 
please attach the file.