Bug 119045 - (ODS) Charts don't load correctly if there is an extra dot in the filename of an imported CSV file (see attached files).
Summary: (ODS) Charts don't load correctly if there is an extra dot in the filename of...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-01 15:43 UTC by Hamish McIntyre-Bhatty
Modified: 2018-09-09 20:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
CSV file used to generate the chart. (43.66 KB, text/csv)
2018-08-01 15:44 UTC, Hamish McIntyre-Bhatty
Details
Resulting chart which doesn't open. (63.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-08-01 15:44 UTC, Hamish McIntyre-Bhatty
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hamish McIntyre-Bhatty 2018-08-01 15:43:21 UTC
Description:
This crash occurs in v6.0.3.2, but also occurred in version 5 (can't determine which version as no longer installed).

My host OS is Mint 19 (based on Ubuntu 18.04 LTS).

I thought this issue was where the filename had an extra dot and nothing else, but it doesn't appear to be so. I think it only occurs if you import a CSV file with an extra dot in the filename (see attached file #1), then create a chart with default settings (no customisations), and save to a file with the same name but the extension ods (see attached file).

I suppose this could be a file save issue as well, but I can't diagnose any further on my own.

Steps to Reproduce:
1. Open the attached CSV file.
2. Create a chart with standard options (click through and hit finish).
3. Save the file as ODS with the same name, except for the file extension.
4. Attempt to open the ODS file after closing Libreoffice.

Actual Results:
This occurs both on my desktop with a modern Intel i5-4440, and my laptop with an AMD E1-1200 APU (6 years old). In both cases, there is a massive hang with high CPU load (up to a few minutes on the laptop) before I am informed that

"This file contains links to other files.
Should they be updated?"

If I click yes, I get the error

"The following external file could not be loaded. Data linked from this file did not get updated.

sump:M0-2018-07-26 07:55:20.047821"

And the chart is missing.

If I click no, nothing happens and the chart is missing.

Expected Results:
The file and chart both load quickly as normal.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
On the desktop:

Version: 6.0.3.2
Build ID: 1:6.0.3-0ubuntu1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); Calc: group

I believe OpenGL (hardware acceleration?) is enabled, but the option name has changed, so I am unsure.
Comment 1 Hamish McIntyre-Bhatty 2018-08-01 15:44:14 UTC
Created attachment 143902 [details]
CSV file used to generate the chart.

CSV file used to generate the chart.
Comment 2 Hamish McIntyre-Bhatty 2018-08-01 15:44:52 UTC
Created attachment 143903 [details]
Resulting chart which doesn't open.

Resulting chart which doesn't open.
Comment 3 Buovjaga 2018-09-01 16:10:48 UTC
I confirm the problem with your ODS file, but I cannot reproduce it with the steps.

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 1c59d021b3dd27c8c0255312bd0d53ad25965bab
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on September 1st 2018
Comment 4 Hamish McIntyre-Bhatty 2018-09-04 08:52:50 UTC
Hmm okay. What version of Libreoffice are you using? I could retest against the latest to see if it has been fixed.
Comment 5 Buovjaga 2018-09-04 10:31:00 UTC
(In reply to Hamish McIntyre-Bhatty from comment #4)
> Hmm okay. What version of Libreoffice are you using? I could retest against
> the latest to see if it has been fixed.

An easy way for you would be to download an appimage of a master build, set it to executable and run: https://libreoffice.soluzioniopen.com/index.php/daily-version/
Comment 6 Hamish McIntyre-Bhatty 2018-09-08 14:24:29 UTC
Using today's test build on the same system, I can confirm this doesn't happen anymore, so I guess it was already fixed. I'll mark this as fixed.
Comment 7 Buovjaga 2018-09-09 20:13:39 UTC
Great, tweaking status as we don't know the fix.