Bug 152852 - LibO writer loses connection to xlsx file as database for series letter and crashes when trying to reconnect
Summary: LibO writer loses connection to xlsx file as database for series letter and c...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-02 23:22 UTC by Klaus Renger
Modified: 2023-10-28 03:13 UTC (History)
2 users (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 Klaus Renger 2023-01-02 23:22:09 UTC
Description:
Created a LibO writer series letter template using Addresses.xlsx file as database for e.g. addresses. First run after creation works fine. After closing LibO and reopening for working with the same document an error is shown when hitting the data source button: "The connection to the data source could not be established". Going into details it shows "File Addresses.xls could not be loaded". Apparently it looks for an xls file while the connection was made to an xlsx file. When I try to delete the connection and rebuilt it, LibO crashs when hitting 'ok' to save the changes. The bahaviour is the same independent from creating the connection from writer or through base.

Steps to Reproduce:
1.Create database with e.g. address files in calc and store as xlsx
2.Create series letter in writer
3.Connect database through series letter assistant or through base 
4.Link data fields in series letter with database and e.g. print a few letters
5.Close LibO
6.Reopen the series letter
7.Hit datasource button to select database 

Actual Results:
Error message appears as described

Expected Results:
The previously linked database should be shown 


Reproducible: Always


User Profile Reset: No

Additional Info:
none
Comment 1 Robert Großkopf 2023-01-03 06:59:38 UTC
Have tested this one.
Created a *.xlsx-file.
Connected a database file to this *.xslx-file.
Created a series letter for this database.

Close LO, reopened LO, reopened the Writer file.
Could switch to data source. Datasource is almost available.

Tested with different LO versions (LO 7.4.3.2, also LO 7.3.6.2). No problem with data source.

Might be this is a special problem of packages of your Linux distribution.
My system: OpenSUSE 15.3 64bit rpm Linux, packages for LO directly installed from libreoffice.org (not the packages from OpenSUSE).
Comment 2 Klaus Renger 2023-01-03 11:15:51 UTC
Thanks a lot for taking care of this.
Here is the detailed build info:

Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 24; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.1
Calc: threaded
Comment 3 Stéphane Guillou (stragu) 2023-03-30 13:47:25 UTC
I can't reproduce either with:

Version: 7.3.7.2 / LibreOffice Community
Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

LO 7.3 won't see further releases. Can you please test with 7.4 or 7.5 and see if you have the same issue?
Please also test with Help > Safe mode, to see if the issue is linked to your user profile.
Thank you!
Comment 4 QA Administrators 2023-09-27 03:15:43 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2023-10-28 03:13:36 UTC
Dear Klaus Renger,

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