I have over 171500 rows of data. When I use Subtotal tool, Calc stops working.
Here is the data
https://porssisahko.net/api/internal/excel-export
Store the large document in the native file format of your application. That is Open Document Spreadsheet (*.ods).
Use a pivot table instead of subtotals.
tried with OP-file as .ods …after grouping by years, month,days ~4min freeze and crash!
Version: 25.8.3.2 (AARCH64) / LibreOffice Community
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Flatpak
Calc: threaded
no crash with:
Version: 25.2.3.2 (AARCH64) / LibreOffice Community
Build ID: 520(Build:2)
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Debian package version: 4:25.2.3-2+deb13u2
Calc: threaded
Download and extract the zip. It contains 2 files:
- sahkon-binnat.fdb is a Firebird database.
- sahkon-binnat.fdb is a LibreOffice Base document connected to the database.
- Open the document and call menu:Edit>Database>Properties.
- Click the [Browse…] button, reconnect the document with its database and save the document
- Test the query and the report. They open instantly. It would work with millions of rows as well.
For integration in Calc (formatting, printing, charting etc.):
- Call menu:Tools>Options>Base>Databases and register the database document.
- Open a spreadsheet, hit Ctrl+Shift+F4 and drag the query into Calc.
- Call menu:Data>Define…, click “Options”, check options “Keep formatting” and “Insert/Remove Cells”.