Download it now!
Bug 50816 - EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms
Summary: EDITING: Pictures in forms not deleted in the *.odb-file when deleted in forms
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: high major
Assignee: Not Assigned
Depends on:
Blocks: Database-Forms
  Show dependency treegraph
Reported: 2012-06-07 01:18 UTC by Robert Großkopf
Modified: 2020-10-19 07:42 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Only one form - you see nothing inside. File over 500kB (531.22 KB, application/vnd.sun.xml.base)
2012-06-07 01:18 UTC, Robert Großkopf

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2012-06-07 01:18:35 UTC
Created attachment 62697 [details]
Only one form - you see nothing inside. File over 500kB

Create a form in base, load a picture into this form and save the database. The database is as big as the pictures. 
Then reopen the database. Delete the picture in the form. Save the database. The picture isn't seen any longer in the form, but the file is too big for only one form without anything inside.
Have a look at the file with a packing-program. Only with a packing-program you could delete the picture.

Comment 1 Jochen 2012-08-29 18:41:03 UTC
I can confirm the bug
OS: Windows 7 pro 64 bit
LO 3.5.5
Comment 2 Julien Nabet 2014-11-30 21:35:55 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this.
(put all since Jochen confirmed on Windows)
Comment 3 Alex Thurgood 2015-01-03 17:39:08 UTC Comment hidden (no-value)
Comment 4 QA Administrators 2016-01-17 20:04:08 UTC Comment hidden (obsolete)
Comment 5 Robert Großkopf 2016-01-29 15:14:06 UTC
Bug still exists with LO, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 6 Robert Großkopf 2016-03-06 15:45:20 UTC
Bug appears also in the first available LO-version (LO, OpenSUSE 42.1 64bit rpm Linux). So I set this bug as "Inherited From OOo".
Comment 7 QA Administrators 2017-05-22 13:19:02 UTC Comment hidden (obsolete)
Comment 8 Robert Großkopf 2017-05-28 15:51:23 UTC
Bug still exists with LO, OpenSUSE 42.1 Leap, 64bit rpm Linux.

... but the importance is very high:
If you delete a picture, it won't be deleted in the odb-file
the picture will be copied every time you open the form for editing and saving it after you have edited. The file will blow up very fast!!

Another person, who could set the importance higher, must have a look here. I am not allowed to do this. Seems I am only a simple user with 87 open bug-reports ...
Comment 9 Julien Nabet 2017-05-31 16:00:30 UTC
On pc Debian x86-64 with master sources some days ago, I could still reproduce this.

Let's increase importance since:
- it concerns all platform
- not a corner case
- insidious since no error
- data loss/corruption possible

Lionel: I don't know if the root cause is in Base part or other part dealing with image but thought you might have some opinion.

Robert: I don't know who manages rights on LO bugzilla but I suppose this page could help to find some useful contacts.
Comment 10 QA Administrators 2018-06-24 02:41:42 UTC Comment hidden (obsolete)
Comment 11 Drew Jensen 2018-06-24 18:40:37 UTC
Checked with 6.1 Beta 1 under Ubuntu 18.04

The problem persists.

Using the same build and opening a Writer File, add image, save it and the file is 502 K. Re-open it and delete the image, save again, the file is now 8 K.

To be clear the image(s) is(are) left in the Base Form, and ODT file, which when embedded in a Base file does not act the same as a free standing ODT file in this regard.

Using the test file, adding a new image and removing it from the form leaves both images stuck in the ODT form.
Comment 12 QA Administrators 2019-06-25 02:42:29 UTC Comment hidden (obsolete)
Comment 13 Robert Großkopf 2019-06-25 05:40:47 UTC
Bug still exists in LO on OpenSUSE 15 64bit rpm Linux