Bug 115165 - no calculation with data=>subtotal
Summary: no calculation with data=>subtotal
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-23 09:34 UTC by Xavier Van Wijmeersch
Modified: 2018-01-25 09:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (100.80 KB, image/png)
2018-01-23 09:34 UTC, Xavier Van Wijmeersch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Xavier Van Wijmeersch 2018-01-23 09:34:56 UTC
Created attachment 139290 [details]
screenshot

following the description from bug 114720

1. Create a new spreadsheet in Calc
2. Enter number 1 to A1:A8
3. Select cell A9
4. Select menu Date-Subtotals
5. In dialogue Subtotals push OK

there is no result nor calculation; and also no crash

When selecting "calculation subtotals for" and press ok there is a strange behaviour and wrong total ???

Version: 5.4.5.0.0+
Build ID: 66ad52d05a11b87f921e782ffb6a9b49528fc194
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: 24702687433842a6e9e8a1070ead46c035192bf3
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Comment 1 raal 2018-01-24 19:58:08 UTC
(In reply to Xavier Van Wijmeersch from comment #0)
> Created attachment 139290 [details]
> screenshot
> 
> following the description from bug 114720
> 
> 1. Create a new spreadsheet in Calc
> 2. Enter number 1 to A1:A8
> 3. Select cell A9
> 4. Select menu Date-Subtotals
> 5. In dialogue Subtotals push OK
> 
> there is no result nor calculation; and also no crash

It's the same in LO 4.1 and OpenOffice. Not sure if it's a bug. At https://help.libreoffice.org/Calc/Subtotals is written "Calculates subtotals for the columns that you select", so you should select column in dialog?
> 
> When selecting "calculation subtotals for" and press ok there is a strange
> behaviour and wrong total ???

First row is heading, that's the reason why not counted.
Comment 2 Xavier Van Wijmeersch 2018-01-25 09:04:02 UTC
@raal

thanks, will search for info on the subject data=>subtotals
can be closed as WFM, and yes i will first search for info before reporting a bug

Best regards
Comment 3 Xisco Faulí 2018-01-25 09:19:46 UTC
(In reply to Xavier Van Wijmeersch from comment #2)
> @raal
> 
> thanks, will search for info on the subject data=>subtotals
> can be closed as WFM, and yes i will first search for info before reporting
> a bug
> 
> Best regards

Let's put it to WFM then. Ideally, the best would be to search for info first.
Anyway, you both are doing a great deal of good to the project :-)