Bug 157408 - LibreOffice - Writer crashed when two databases (ods-files) are involved in one serial-letter.
Summary: LibreOffice - Writer crashed when two databases (ods-files) are involved in o...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.5.6.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-24 08:55 UTC by Benjamin B.
Modified: 2024-05-10 03:17 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Benjamin B. 2023-09-24 08:55:22 UTC
Description:
Im a teacher and I use serial letters (form letter) to print the achieved points per excercise for each student. Each serial letter (written with LO-Writer) has a similar structure. In the process of creating a new serial letter, I always copy an old serial letter. This process is important to save time, but in my opinion this is also the cause of the crash.

Afterwards I click (in german) "Einfügen --> Feldbefehl --> weitere Feldbefehle"  and then "Datenbank --> Seriendruck-Feld" to connect the odt-file with the database of the ods-file. Usually LO-Writer shows me in the list of databases the ods-file, but does not offer me to unfold the database, so that I can select a table/column of the ods-file. Continueing in LO-Writer leads to a crash.

After some time I found a solution. First you have to delete ALL OLD REFERENCES in the serial-letter. After doing so, the connection to the new ods-file succeeds and there are no more crashes. This is not intuitive and should not be the way how the user should act.


Steps to Reproduce:
1. Copy on old ODT-file (and rename it) which was a serial letter with references to an old ODS-file.
2. Leave old column-references in the ODT-file
3. Connect the (new) ODT-file to another ODS-file. 
4. Now the imported database does not offer you unfolding und double clicking it or importing again and again often leads to a crash.

Actual Results:
The program crashes. I thing because there is a mixture of references. The programm is connected to a nrw ods file, but in the odt-file there are references to columns of an old ods-file.

Expected Results:
When the user connects to a new ods-file (databse), it should delete all old references to the old ods-file. It should also open a prompt and tell the user, that that will happen.



Reproducible: Always


User Profile Reset: Yes

Additional Info:
This bug is very old. I hoped since many years this will be solved but today a installed the newest version and it did still exist so I decided to report the bug.
Comment 1 Stéphane Guillou (stragu) 2023-10-11 20:14:30 UTC
Thanks for the report.
I tried reproducing the crash with my own sample files but could not.
Can you please provide a zip of sample files, with precise steps that reproduce the crash with those files?
And how exactly do you to the new ODS? Using "Exchange database"?

Version: 7.5.7.1 (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 2 Stéphane Guillou (stragu) 2023-10-11 20:22:41 UTC
(and if you see the Crash Report dialog, please do sent a crash report and share the link to it here. Thank you!)
Comment 3 QA Administrators 2024-04-09 03:13:29 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2024-05-10 03:17:10 UTC
Dear Benjamin B.,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp