This bug was filed from the crash reporting server and is br-628f6f47-0ebd-40ab-bb88-d9df898952b1. ========================================= The crash occurs on Windows only with a serial letter is based on a spreadsheet source. The database document and the connected spreadsheet document reside on a network drive (drive letter S:). We use this since many years with office versions up to 6.4. Unfortunately, I'm in the process to replace the server machine. I can't test if it has something to do with the network drive.
Created attachment 173028 [details] Database document with query on spreadsheet The data source with a little auto-refresh macro pulling data from a second database. Don't use that macro.
Created attachment 173029 [details] The spreadsheet source This is the actual source of the serial letter. Correction: This spreadsheet has a macro, not the Base document.
The crash occurs when I confirm to print the serial letter. "This document contains database fields. Do you want to print a form letter?" [Yes] --> Crash Happens with a fresh profile having the database registered. Does not happen with LO 6.4
I could reproduce the whole setup with another Windows client. It had 7.1.2 installed which did NOT crash. After upgrading, version 7.1.4 does crash. May be related to https://bugs.documentfoundation.org/show_bug.cgi?id=141854 perhaps?
And it crashes with all files local on drive C: It has something to do with the parameter query. Register my database document under some name. Make sure that the connection to the spreadsheet works. Open any new Writer document and create database fields from one of the queries. Query "Tageslaufzettel" of my database document is a parameter query prompting for a date, say 2021-7-1, but Writer crashes after form letter confirmation and before showing the parameter prompt. It crashes with "Query1" as well which has no parameters. Database fields from the table "Laufzettel_ab_heute" do NOT make it crash.
How to reproduce the crash without any of my attachments: Add a query to the dBase Bibliography and create database fields from that query.
marked as regression since mail merge from query always worked as expected.
Repro using Version: 7.2.0.4 (x64) / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: threaded Steps combining comment 6 and comment 3: 1. Create a new Writer document 2. View->Data Sources (Ctrl+Shift+F4) 3. Righr-click "Bibliography" in the data sources list->Edit Database File... 4. In Queries, create a query in Design View, add Biblio to it, and double-click "*".Close the window, confirm saving, and choose a name. 5. Back in Writer, add a mail merge field (Insert->Field->More Fields (Ctrl+F2) -> Database tab) pointing to any field from the newly created query in the bilbiography database. 6. File->Print, and confirm printing form letter.
More discussion on https://ask.libreoffice.org/t/bug-id-142952-crashing-mail-merge/67215/4 I think it has something to do with the datasource widget displayed in the datasource window and in the mail merge dialog.
You could try bibisecting it with either 7.1 or 7.0 repositories (have to check both as you only have info on 6.4 and 7.1): https://wiki.documentfoundation.org/QA/Bibisect/Windows
(In reply to Buovjaga from comment #10) > You could try bibisecting it with either 7.1 or 7.0 repositories (have to > check both as you only have info on 6.4 and 7.1): > https://wiki.documentfoundation.org/QA/Bibisect/Windows Sorry, no. I can't do that. I can't follow that manual. I don't care if LO can do mail merge on a Windows PC. We can live with LO 6.4 or OOo 3.3. Does not matter at all.
Issue seems to be fixed in: Version: 7.2.2.2 (x64) / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE Calc: threaded I don't know how.