| Summary: | Crash Creating a simple pivot table with 2x2 data fails | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Bill Mitchell <billybob.mitchell> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | aron.budea, billybob.mitchell, buzea.bogdan, miguelangelrv, robert.zuccherato |
| Priority: | medium | ||
| Version: | 24.2.4.2 release | ||
| Hardware: | ARM | ||
| OS: | macOS (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 103381, 133092 | ||
| Attachments: |
sample file with data
Demonstration of issue |
||
|
Description
Bill Mitchell
2024-06-10 13:51:11 UTC
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 |