Bug 159579 - Charts in Calc converted from OLE to images when upgrading 7.5 to 7.6 and 7.6 to 24.2
Summary: Charts in Calc converted from OLE to images when upgrading 7.5 to 7.6 and 7.6...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-05 19:16 UTC by Chris Kirkland
Modified: 2024-02-28 03:14 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 Chris Kirkland 2024-02-05 19:16:25 UTC
Description:
Following upgrade charts in a Calc file were found to be images and no longer OLE objects. This happened when uppgrading from 7.5 to 7.6 and has happened again upgrading from 7.6.4 to 24.2.0.3. 
Upgrade has been done using the .msi file and the offline help was also installed each time.

Steps to Reproduce:
1. All LibreOffice files are closed (version 7.6.4.1)
2. LibreOffice .msi file is download (version 24.2.0.3)
3. msi file is run and option of Custom Installation is used.
4. Installation location is kept as default, no changes are made. Changes were made in previous version to choose dictionaries and interface langgueage, UK English.
5. Help files are also installed.
6. Computer is restarted.
7. LibreOffice is run and file opened.
8. When new data is added to the Calc file it is found that the relevant chart is not updated.
9. When trying to open the relevant chart it is found it has been converted to an image.


Actual Results:
Chart is converted to image in Calc.

Expected Results:
Chart should remain as a chart.


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
The previous version 7.6.4.1 was installed as a parallel install. Opening the Calc file in this version also shows the Chart as an image. 
Sorry, as the file contains a lot of personal information I cannot share it.
Comment 1 m_a_riosv 2024-02-06 01:59:59 UTC
But maybe you can reduce it to minimum size and clear/replace private data.
Comment 2 Chris Kirkland 2024-02-06 08:04:28 UTC
(In reply to m_a_riosv from comment #1)
> But maybe you can reduce it to minimum size and clear/replace private data.

Sorry, the charts (now images) are there to show that private data too. I will try to find a way to recreate the problem when I have the time.
The original file was created in 2010, probably using OpenOffie.org and used almost daily since then. The Calc file has 42 sheets and is 49 MB. The charts were recreated when the same problem occured with LO 7.6.
Comment 3 Stéphane Guillou (stragu) 2024-02-22 15:41:43 UTC
Which format are the files saved as?
Comment 4 Chris Kirkland 2024-02-23 10:16:17 UTC
(In reply to Stéphane Guillou (stragu) from comment #3)
> Which format are the files saved as?

It is .ods format and always has been. It was created in 2010.
Comment 5 QA Administrators 2024-02-24 03:14:35 UTC Comment hidden (obsolete)
Comment 6 Stéphane Guillou (stragu) 2024-02-27 07:16:30 UTC
I have tested on Windows 11:

1. Create a chart in an ODS file with LO 7.6.5.2
2. Open ODS file in 24.2.0.3

I could not reproduce.
Marking as "need info" while we wait for a potential example file.

If you still have the original file (with OLE objects), you could try to reset your user profile (after backing up the original) and open the file again with the newer version, see if the issue persists.
Comment 7 Chris Kirkland 2024-02-27 18:48:55 UTC
(In reply to Stéphane Guillou (stragu) from comment #6)
> I have tested on Windows 11:
> 
> 1. Create a chart in an ODS file with LO 7.6.5.2
> 2. Open ODS file in 24.2.0.3
> 
> I could not reproduce.
> Marking as "need info" while we wait for a potential example file.
> 
> If you still have the original file (with OLE objects), you could try to
> reset your user profile (after backing up the original) and open the file
> again with the newer version, see if the issue persists.

Hi, The original file lost the OLE part of the objects and left them only as images. There are no OLE objects left in the file, only images. I have copied the data into a new file in case it is something to do with the original file's make-up or an error that has crept in over the years.
I Have converted the file to zip and compared with a Calc file with a chart.
Faulty file has: 
Configurations2 [folder]
META-INF [folder]
Pictures [folder]
Thumbnails [folder]
Content.xml
Manifest.rdf
meta.xml
mimetype
settings.xml
styles.xml
File with chart:
Configurations2 [folder]
META-INF [folder]
Object 1 [folder]
ObjectReplacements [folder]
Thumbnails [folder]
Content.xml
Manifest.rdf
meta.xml
mimetype
settings.xml
styles.xml
I'm not sure if this helps.
Comment 8 QA Administrators 2024-02-28 03:14:48 UTC Comment hidden (obsolete)