Created attachment 197237 [details] Example file from Excel 2016 In the attached file in the Subtotal dialog I have set the "Add subtotal to" setting to "Value 1" and "Value 2" columns and the "Use function" setting to "Max" When opened in Calc, these are not recognized by the Subtotals dialog. 1. Open attached file 2. On the "Below" sheet select the Data - Subtotals menu item -> On the "1st group" tab the "Calculate subtotals for" does not have "Value 1" and "Value 2" checked, and in the "Use function" does not have "Max" highlighted when I select "Value 1" and "Value 2" in the "Calculate subtotals for" box. Pressing OK in this setup results in losing the use of Subtotal feature on this sheet. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: dd41459378bca78a18f32e61bfac77aa48fabb8d CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default
Created attachment 197238 [details] The example file in Excel and Calc
I was not able to reproduce this. Version: 24.8.2.1 (AARCH64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Repro with file. Arch Linux 64-bit Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4805277b8d3e93ac652a5ed66d0ed101d64a78c3 CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 15 November 2024