[Solved] OLE Objects Lost
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
[Solved] OLE Objects Lost
Dear All,
I have a Text document with multiple Spreadsheets embedded in it as OLE objects. They’ve been fine for weeks now, but suddenly appear as shown below.
Any idea what’s happened?
James.
I have a Text document with multiple Spreadsheets embedded in it as OLE objects. They’ve been fine for weeks now, but suddenly appear as shown below.
Any idea what’s happened?
James.
Last edited by MrProgrammer on Tue Aug 01, 2023 5:49 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
- Hagar Delest
- Moderator
- Posts: 32716
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: OLE Objects Lost
There are some very old topics about that issue, like this one: [Issue] Missing objects and footers. It may help.
Else, can you try LibreOffice? It is under much active development, it may do better. See the [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information.
Else, can you try LibreOffice? It is under much active development, it may do better. See the [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
Thanks for the response—helpful thread.
I’m starting to wonder if, as I’ve pasted in a table from a spreadsheet, then deleted it, then pasted in another one (ad infinitum), my file has become bloated because it hasn’t truly deleted the older attempts. Any way I can check that?
I’m starting to wonder if, as I’ve pasted in a table from a spreadsheet, then deleted it, then pasted in another one (ad infinitum), my file has become bloated because it hasn’t truly deleted the older attempts. Any way I can check that?
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
Re: OLE Objects Lost
You might want to look at Tools | Options | OpenOffice Writer | View and ensure Display graphics and objects is checked.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.4.2; SlackBuild for 24.2.4 by Eric Hameleers
---------------------
Apache OpenOffice 4.1.15
LibreOffice 24.2.4.2; SlackBuild for 24.2.4 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
Thanks for the suggestion. Was ticked though.
As it happens, all the images have disappeared now. (First time round it was the spreadsheets.) I fear that I may have to look for a different software solution. From what I can tell from googling around, it’s an intermittent issue which no-one’s really been able to fix.
As it happens, all the images have disappeared now. (First time round it was the spreadsheets.) I fear that I may have to look for a different software solution. From what I can tell from googling around, it’s an intermittent issue which no-one’s really been able to fix.
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
- Hagar Delest
- Moderator
- Posts: 32716
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: OLE Objects Lost
That's why LibreOffice should be a good bet as a replacement.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
Yes, that might be the way to go. Though I did see reports of the same issue on there.
It’s a pity, as I very much like OpenOffice’s interface.
It’s a pity, as I very much like OpenOffice’s interface.
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
Re: OLE Objects Lost
Using Linux, years ago I disabled /Tools /Options /Load-Save /General: "Save AutoRecovery information every x minutes" ,and "Always create backup copy" (this latter because my network server doesn't like it). I have lost no images in OO Writer or OO Impress since.
However, I CANNOT guarantee this will work for anyone. It seems to work for me using Linux. I have not tried it using Windows. I am also meticulous in Saving my files (Ctrl S regularly and instinctively).
However, I CANNOT guarantee this will work for anyone. It seems to work for me using Linux. I have not tried it using Windows. I am also meticulous in Saving my files (Ctrl S regularly and instinctively).
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
- LastUnicorn
- Posts: 585
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: OLE Objects Lost
If you mean you like LibreOffice to look a bit like OpenOffice then try this theme: Galaxy icon themeJames Bejon wrote: ↑Mon Jul 24, 2023 9:25 pm It’s a pity, as I very much like OpenOffice’s interface.
I use it in LibreOffice 7.4.7.2 and it still seems to work just fine.
LibreOffice (Still) 7.6.7.2 (x64) Fully installed to system on Windows 10 and Windows 11
LibreOffice (Still) Portable 7.6.7.2 (x86) [PortableApps] on Windows 10
LibreOffice (Still) Portable 7.6.7.2 (x86) [PortableApps] on Windows 10
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
I did see that recommended somewhere (possibly by you!), and I did it. The images went soon after that. I’ll plug a way for a bit longer, and if it happens again, give LibreOffice a go I think.RoryOF wrote: ↑Mon Jul 24, 2023 9:34 pm Using Linux, years ago I disabled /Tools /Options /Load-Save /General: "Save AutoRecovery information every x minutes" ,and "Always create backup copy" (this latter because my network server doesn't like it). I have lost no images in OO Writer or OO Impress since.
However, I CANNOT guarantee this will work for anyone. It seems to work for me using Linux. I have not tried it using Windows. I am also meticulous in Saving my files (Ctrl S regularly and instinctively).
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
Re: OLE Objects Lost
LibreOffice spent 44K euro(?) some years ago (perhaps 6 or 7?) in solving this and associated problems; there have however been some (very few) reports of image loss in post-fix LibreOffice versions, which may be due to User errors.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
Good to know, thanks.
I wonder if that also fixed the spreadsheet issue. They happened at very similar times for me.
I wonder if that also fixed the spreadsheet issue. They happened at very similar times for me.
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
-
- Posts: 19
- Joined: Sun May 10, 2020 2:53 pm
Re: OLE Objects Lost
Thanks for the advice. I’m finding LibreOffice pretty much fine. The only problem so far is that pasted in Calcs/Spreadsheets make a bit of a mess of Hebrew, but it’s not too bad.Hagar Delest wrote: ↑Mon Jul 24, 2023 9:18 pm That's why LibreOffice should be a good bet as a replacement.
Apache OpenOffice 4.1.14
macOS 13.3.1
macOS 13.3.1
- Hagar Delest
- Moderator
- Posts: 32716
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: OLE Objects Lost
Don't hesitate to open a new topic in the Calc section for that. That would be strange that a formatting issue would be worse in LO than in AOO.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10