Description: I try to simply count the OK and KO in the attached file as pivot table. But when you start to create a pivot table the records are marked and then calc goes into an endless loop when trying to create the table. Steps to Reproduce: 1. Open the attached example 2. Try to create an pivot table 3. calc hangs Actual Results: calc does not create the pivot table and hangs Expected Results: Just take not more then some seconds to create an result Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
Created attachment 178062 [details] File with imported CSV data File has (only) 1137 data sets
I cannot confirm with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0b397d8ef0a2615e8e6202804ca2f6cb58436fa5 CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo
Can you confirm with Version: 7.1.8.1 ?
no problem on macOS in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 583185235389b55d6cfffac3067c0e1ccb2852b1 CPU threads: 4; OS: Mac OS X 10.16; UI render: Skia/Metal; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded nor in Version: 7.2.5.2 / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Mac OS X 12.1; UI render: default; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded Karsten, could you please install LibreOffice 7.2.5 and try retest your problem?
Installed Version: 7.3.0.3 / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Every try to open the example file ends in an crash: Application: soffice (soffice), signal: Illegal instruction [KCrash Handler] #4 0x00007fc31e4698de in ?? () from /opt/libreoffice7.3/program/../program/libsclo.so #5 0x00007fc31e46ca16 in ?? () from /opt/libreoffice7.3/program/../program/libsclo.so #6 0x00007fc353f66fe2 in ?? () from /lib64/ld-linux-x86-64.so.2 #7 0x00007fc353f670e9 in ?? () from /lib64/ld-linux-x86-64.so.2 #8 0x00007fc34f9282bd in _dl_catch_exception () from /lib/x86_64-linux-gnu/libc.so.6 #9 0x00007fc353f6b364 in ?? () from /lib64/ld-linux-x86-64.so.2 #10 0x00007fc34f928260 in _dl_catch_exception () from /lib/x86_64-linux-gnu/libc.so.6 #11 0x00007fc353f6a8fa in ?? () from /lib64/ld-linux-x86-64.so.2 #12 0x00007fc34e006258 in ?? () from /lib/x86_64-linux-gnu/libdl.so.2 #13 0x00007fc34f928260 in _dl_catch_exception () from /lib/x86_64-linux-gnu/libc.so.6 #14 0x00007fc34f92831f in _dl_catch_error () from /lib/x86_64-linux-gnu/libc.so.6 #15 0x00007fc34e006a65 in ?? () from /lib/x86_64-linux-gnu/libdl.so.2 #16 0x00007fc34e0062e4 in dlopen () from /lib/x86_64-linux-gnu/libdl.so.2 #17 0x00007fc34fa213cb in osl_loadModule () from /opt/libreoffice7.3/program/libuno_sal.so.3 #18 0x00007fc34bb462a4 in ?? () from /opt/libreoffice7.3/program/libuno_cppuhelpergcc3.so.3 #19 0x00007fc34bb5d5d7 in ?? () from /opt/libreoffice7.3/program/libuno_cppuhelpergcc3.so.3 #20 0x00007fc34bb49fbe in ?? () from /opt/libreoffice7.3/program/libuno_cppuhelpergcc3.so.3 #21 0x00007fc34bb5cce0 in ?? () from /opt/libreoffice7.3/program/libuno_cppuhelpergcc3.so.3 #22 0x00007fc35162c401 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #23 0x00007fc351204089 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #24 0x00007fc3512061ee in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #25 0x00007fc351206668 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #26 0x00007fc350aff142 in comphelper::SynchronousDispatch::dispatch(com::sun::star::uno::Reference<com::sun::star::uno::XInterface> const&, rtl::OUString const&, rtl::OUString const&, com::sun::star::uno::Sequence<com::sun::star::beans::PropertyValue> const&) () from /opt/libreoffice7.3/program/libmergedlo.so #27 0x00007fc3517c949f in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #28 0x00007fc3517cc7a7 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #29 0x00007fc3517cfb55 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #30 0x00007fc3517d1733 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #31 0x00007fc35221da1f in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #32 0x00007fc3524f7a16 in SalUserEventList::DispatchUserEvents(bool) () from /opt/libreoffice7.3/program/libmergedlo.so #33 0x00007fc3435587c3 in QtInstance::ImplYield(bool, bool) () from /opt/libreoffice7.3/program/libvclplug_qt5lo.so #34 0x00007fc34355893e in QtInstance::DoYield(bool, bool) () from /opt/libreoffice7.3/program/libvclplug_qt5lo.so #35 0x00007fc3524f0362 in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #36 0x00007fc3525571e5 in Application::Execute() () from /opt/libreoffice7.3/program/libmergedlo.so #37 0x00007fc3517d9ded in ?? () from /opt/libreoffice7.3/program/libmergedlo.so #38 0x00007fc3525e853f in ImplSVMain() () from /opt/libreoffice7.3/program/libmergedlo.so #39 0x00007fc3517c5eb5 in soffice_main () from /opt/libreoffice7.3/program/libmergedlo.so #40 0x000000000040069b in ?? () #41 0x00007fc34f816d0a in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 #42 0x00000000004006cf in ?? () [Inferior 1 (process 20459) detached]
This PC is running Distributor ID: Debian Description: Debian GNU/Linux 11 (bullseye) Release: 11 Codename: bullseye Deinstalled Version: 7.3.0.3 and installed Version: 7.2.5.2 Version: 7.2.5.2 / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded TestPing.ods can be opened now without a crash! Trying to create a pivot table still ends in an endless loop! But i can croll the table still with the mouse wheel. The menus are greyed out and everything is dead!
[Automated Action] NeedInfo-To-Unconfirmed
I don't know a lot about pivot tables. I tried creating it in a couple of ways, but as there are many possibilities, probably I didn't create it the same way as you. Can you give exact steps on what fields I should drag where in the dialog? No problem for me, btw. Arch Linux 64-bit Version: 7.3.2.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.3.2-1 Calc: threaded
Today i retestet with version Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded and it works.
Maybe the reason is a reinstallation of this version or on upgrade of the Debian - who knows
So, let's close this one as WFM, but don't hesitate reopen it if you will see the problem again