LibreOffice Calc crashes when clicking on "Data Provider"

[skyzXCI]

Hello!

First time poster! Hopefully this will be clear. I’m looking for help regarding Calc crashing.
Currently running: LibreOffice 24.2.3.2 on Fedora 40, fully updated.

For context: I’ve been working on my own financial budgeting spreadsheet and I’m at a point where I’m trying out Pivot Tables and Pivot Charts. I’m also exploring how to import my raw financial data.

Problem: Calc always crashes whenever I click on the “Data Provider” button in the “Data” tab.

I’ve not experienced any crashes regarding other things than that “Data Provider” button. I’ve tried with a blank spreadsheet and it also crashes, so it’s probably not related to anything in my financial spreadsheet.

I’ve tried installing LibreOffice Base as it seems that Base is not installed on Fedora, I only had Writer, Calc and Impress so I thought that Data Provider connected to a database on Base. It did not help. I’ve launched LibreOffice from the terminal to see the output when the crash happens and it says “Fatal Exception: Signal 11” and then it dumps the stack.

I’ve been dealing with this issue for the last couple of days and despite my best efforts and searching, I’m lost.

Any ideas on what might be happening? Would that be a Fedora thing/bug and should I turn to them?

Thank you for your help!

Cheers!

[fpy]

Maybe : Safe Mode

@skyzXCI

dumps the stack

… which reads ?

[skyzXCI]

Hello!

Thanks for your reply!
EDIT: tried it in safe mode as suggested and it still crashes in the same way unfortunately.

This is the output when LibreOffice Calc crashes after launching it from the terminal:

Fatal exception: Signal 11
Stack:
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3f096)[0x7f9314300096]
/usr/lib64/libreoffice/program/libuno_sal.so.3(+0x3f282)[0x7f9314300282]
/lib64/libc.so.6(+0x40710)[0x7f931400d710]
/lib64/libgio-2.0.so.0(+0xe3ce7)[0x7f930d459ce7]
/lib64/libgio-2.0.so.0(+0xe9a39)[0x7f930d45fa39]
/lib64/libgio-2.0.so.0(g_dbus_connection_register_object+0x14f)[0x7f930d47f7df]
/lib64/libgio-2.0.so.0(g_dbus_connection_export_menu_model+0xb3)[0x7f930d460203]
/usr/lib64/libreoffice/program/libvclplug_gtk3lo.so(+0x90fa1)[0x7f92fd8c2fa1]
/usr/lib64/libreoffice/program/libvcllo.so(+0x2952e7)[0x7f93106952e7]
/usr/lib64/libreoffice/program/libvcllo.so(+0x1c45d3)[0x7f93105c45d3]
/usr/lib64/libreoffice/program/libvcllo.so(+0x2a2d67)[0x7f93106a2d67]
/usr/lib64/libreoffice/program/libvcllo.so(_ZN10WorkWindowC2EPN3vcl6WindowEl+0x85)[0x7f93106a2f75]
/usr/lib64/libreoffice/program/libvclplug_gtk3lo.so(+0x9d52f)[0x7f92fd8cf52f]
/usr/lib64/libreoffice/program/…/program/libsclo.so(+0x920f84)[0x7f92e5520f84]
/usr/lib64/libreoffice/program/…/program/libsclo.so(+0xb3a1fa)[0x7f92e573a1fa]
/usr/lib64/libreoffice/program/libsfxlo.so(+0x1d5a21)[0x7f93129d5a21]
/usr/lib64/libreoffice/program/libsfxlo.so(+0x21776a)[0x7f9312a1776a]
/usr/lib64/libreoffice/program/libsfxlo.so(+0x217b6a)[0x7f9312a17b6a]
/usr/lib64/libreoffice/program/libfwklo.so(+0x1cb15d)[0x7f93131cb15d]
/usr/lib64/libreoffice/program/libvcllo.so(+0x2a1426)[0x7f93106a1426]
/usr/lib64/libreoffice/program/libvcllo.so(_ZN16SalUserEventList18DispatchUserEventsEb+0x167)[0x7f9310932f07]
/usr/lib64/libreoffice/program/libvclplug_gtk3lo.so(+0x8929f)[0x7f92fd8bb29f]
/lib64/libglib-2.0.so.0(+0x62dcd)[0x7f930d28bdcd]
/lib64/libglib-2.0.so.0(+0x5c6ac)[0x7f930d2856ac]
/lib64/libglib-2.0.so.0(+0xbd708)[0x7f930d2e6708]
/lib64/libglib-2.0.so.0(g_main_context_iteration+0x33)[0x7f930d286b23]
/usr/lib64/libreoffice/program/libvclplug_gtk3lo.so(+0x91c7c)[0x7f92fd8c3c7c]
/usr/lib64/libreoffice/program/libvcllo.so(+0x57aa5e)[0x7f931097aa5e]
/usr/lib64/libreoffice/program/libvcllo.so(_ZN11Application7ExecuteEv+0x7d)[0x7f931097ac3d]
/usr/lib64/libreoffice/program/libsofficeapp.so(+0x406f6)[0x7f931420d6f6]
/usr/lib64/libreoffice/program/libvcllo.so(_Z10ImplSVMainv+0x402)[0x7f9310990392]
/usr/lib64/libreoffice/program/libsofficeapp.so(soffice_main+0x136)[0x7f9314229c06]
/usr/lib64/libreoffice/program/soffice.bin(+0x10c7)[0x56223bbb90c7]
/lib64/libc.so.6(+0x2a088)[0x7f9313ff7088]
/lib64/libc.so.6(__libc_start_main+0x8b)[0x7f9313ff714b]
/usr/lib64/libreoffice/program/soffice.bin(+0x1105)[0x56223bbb9105]

[fpy]

1. maybe First steps to take before submitting a bug - The Document Foundation Wiki
2. “Data provider” looks still highly experimental

how to use calc "data -> data provider" to connect on sqlite db

Hello, You have stated you have a registered Base file connected to SQLite. With that you can access the data (tables and queries) from Data Sources. This is menu → View>Data Sources (or Shift+Ctrl+F4). This opens access to registered databases where you can select the DB then the table or query. In the right panel the actual data can then be placed in the spreadsheet. For more on this, see the LO documentation → LibreOffice Calc Guide Chapter 10 - Linking Calc Data. Edit 2019-10-07: Ther…

[skyzXCI]

Hello!

Well, your first suggestion helped a lot.

In the section related to " Rendering issues specific to Linux", it is mentioned that “Sometimes gtk3 or kf5/qt VCL backends trigger bugs”. I have tried the provided command:

SAL_USE_VCLPLUGIN=gen libreoffice

When LibreOffice opens, the interface looks like the old windows on Win95, but when I click on “Data Provider”, it doesn’t crash and it looks like it open normally! I can interact with the window and the options. The logical conclusion is that it is indeed related to linux libraries and not LibreOffice.

It is also good to know that Data Provider is still an experimental feature. It’s not something I use normally.

Thank you for your help!

Cheers!