Description: After filling out 4 cells, LibreOffice crashes when I highlight A1:B2 and try to create a pivot table. I wanted to try LibreOffice as an alternative to Excel. I entered some sample data and tried creating a pivot table, and was surprised when it crashed. I reduced my steps down to the minimal sequence required to reproduce the issue and am filing this report to see if I can help the development effort. Steps to Reproduce: 1.Create a new Calc document 2.For cell A1: enter 'name' 3.For cell A2: enter 'age' 4.for cell B1: enter 'bob' 5.for cell B2: enter '50' 6.highlight A1:B2 7.select menu entry Data/Pivot Table/Insert or Edit/Current Selection 8.drag 'name' to the Row field 9.click & hold on the salary field, then start to drag Actual Results: The application immediately crashes Expected Results: Expected that the pivot table would be created Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.4.2 (AARCH64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 16; OS: macOS 14.3.1; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
cannot reproduce with: ``` Version: 24.2.4.2 (AARCH64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Flatpak Calc: threaded ``` IMHO your minimal »Example« doesnt make any sense to me, which **salary**-field are you talking about? do you mean a DataStructure like: _________________ ____| A | B | 1 |Name | Age | 2 |Bob | 50 | _________________|
I'm sorry - I started with 3 columns ``` Name | age | salary bob | 50 | 24000 alice | 54 | 30000 ``` then was doing a pivot table with Name on the 'row' field.
anyway … Cannot reproduce a crash
Please attach a sample file, reduce the size as much as possible without private information.
Created attachment 194654 [details] sample file with data Attaching sample file with 2x2 data grid
Created attachment 194655 [details] Demonstration of issue Screen capture of the issue happening (in .mp4 format for size considerations)
Have uploaded a sample 2x2 Calc spreadsheet, as well as a video that demonstrates the issue that I'm experiencing. Another element which may be a factor - I've not saved a document yet with LibreOffice to my ~/Documents folder, I was only saving files to the /tmp folder. Not sure if that makes a difference, but I'm grasping at straws. I just experienced possibly a different symptom of the same problem - at the Pivot Table Layout window, I have two available fields "name", and "age". I dragged 'age' into the "column fields", and then attempted to drag "name" to the "row fields" - and LibreOffice became nonresponsive. Activity Monitor shows it consuming 99.6% of cpu, waited for 4 minutes, then had to kill the process. Sorry, I don't mean to be finding bugs!
No issue with Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Or Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: a2b6ce5d21b7f5c84ced8485f5af279f1bf8135f CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
I have this exact same problem. Every time I try to create a pivot table, Calc crashes in exactly the manor described in the original description. I am also using MacOS on ARM, so the problem might be limited to Macs.
I'mm sorry. I forgot: Version: 24.2.4.2 (AARCH64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 8; OS: macOS 14.5; UI render: Skia/Raster; VCL: osx Locale: en-CA (en_CA.UTF-8); UI: en-US Calc: threaded
Setting to NEW since more than one user reports the same problematic behavior.
If you would like to test whether a Dev version (which includes recent patches solving other crashes) would solve this problem too, please carefully read and follow the instructions posted at tdf#161461 comment 14 (do not forget to use the "xattr" command mentioned there). Please report the result of your test in tdf#161493.
I installed the build MacOSX-aarch64@tb92-TDF at https://dev-builds.libreoffice.org/daily/master/current.html and that seems to have solved the problem. I was able to create a pivot table without a crash. Version: 25.2.0.0.alpha0+ (AARCH64) / LibreOffice Community Build ID: c32128b35d177808df47ca98a91c2ef75e922c4a CPU threads: 8; OS: macOS 14.5; UI render: Skia/Metal; VCL: osx Locale: en-CA (en_CA.UTF-8); UI: en-US Calc: threaded
Based on comment 13, I am setting this report as dupe of tdf#161461. *** This bug has been marked as a duplicate of bug 161461 ***
Confirming that testing with the latest build from https://dev-builds.libreoffice.org/daily/master/current.html does not produce this same behaviour, a pivot table can be successfully created now. Thank you!
Update: the fix for this bug is now available for Mac App Store version of LibreOffice: https://apps.apple.com/app/libreoffice/id1630474372 If you bought LibreOffice in the Mac App Store, you can get the fix by opening the App Store application on your Mac and selecting the Store > Updates menu item. Unfortunately, the fix is not yet available in an official release from the LibreOffice website. But a new LibreOffice version is expected to be released sometime later this month (July 2024). I will post an update when the LibreOffice website has the new version.
Update: if you downloaded LibreOffice directly from the LibreOffice website, LibreOffice 24.2.5.1 (a pre-release that contains the fix) can be download from the folowing TDF website links: Mac Silicon: https://www.libreoffice.org/download/download-libreoffice/?type=mac-aarch64&version=24.2.5 Mac Intel: https://www.libreoffice.org/download/download-libreoffice/?type=mac-x86_64&version=24.2.5