Bug 160915 - Please add option to not save OLE replacement objects
Summary: Please add option to not save OLE replacement objects
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Mike Kaganski
URL:
Whiteboard: target:24.8.0
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-02 22:25 UTC by NOYB
Modified: 2024-05-03 09:24 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 NOYB 2024-05-02 22:25:50 UTC
Description:
Saving OLE replacement objects tremendously increases the size of Calc workbook files and provides no benefit in most cases (not being linked or embedded by other applications).

Steps to Reproduce:
1.Save Calc spreadsheet that contains charts.
2.
3.

Actual Results:
OLE replacement objects are included within the saved file.

Expected Results:
OLE replacement objects not included within the saved file.


Reproducible: Always


User Profile Reset: No

Additional Info:
In many, if not most cases, documents are not link or embedded by other documents/applications.  Unnecessarily included OLE replacement objects is a waste of time, storage, memory, CPU, backup, etc. resources.

Please implement an option to not include OLE replacement objects in the saved document file.

Thanks
Comment 1 m_a_riosv 2024-05-03 01:14:55 UTC
Then should be forced to always redraw the chart at opening the file?
Comment 2 Mike Kaganski 2024-05-03 03:16:04 UTC
https://gerrit.libreoffice.org/c/core/+/167026
Comment 3 NOYB 2024-05-03 03:59:41 UTC
We discussed that settings option in the Ask LibreOffice community forum.  It's a little misleading because of "Graphic" in the name and no mention of OLE.

Suppose redrawing the charts is how it would be done.  Removing the "ReplacementObjects" folder from the zip shrinks the file size considerably.  It seems to open fine without them.  But recreates that folder when saved.  Reinflating the file size.

Don't have a non prod or dev environment to test that patch.  So I'll have to wait for it to be merged into a release.

Thanks for your attention to this.
Comment 4 Commit Notification 2024-05-03 09:20:08 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/2aa310cfe0bc10e7bf079147d379f6eb7d061b74

tdf#160915: make own OLE objects obey AddReplacementImages setting

It will be available in 24.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.