Bug 43929 - EDITING Tables: Changing of maximum value of binary-fields must be possible
Summary: EDITING Tables: Changing of maximum value of binary-fields must be possible
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
Reported: 2011-12-18 06:36 UTC by Robert Großkopf
Modified: 2017-11-02 23:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2011-12-18 06:36:19 UTC
When creatind databases with fileds for pictures there is no way to change the maximum value for a binary-field. So databases could get very large when users dont know, that the picture must not be so large to see all details on a monitor.

Other way could be to change the maximum value in a form.
Comment 1 sasha.libreoffice 2012-04-30 04:59:52 UTC
Thanks for new idea
May be I not understand problem:
Database should not allow attach pictures if they exceed specified size. And when users see that size is too big, they will reduce size of images?
Comment 2 Robert Großkopf 2012-05-01 00:21:54 UTC
It's right. When creating tables there are many ways to set character-length to varchar-fileds and other fileds. But there ist no way to set max-value for pictures.
There is only one way to put pictures in a table - controlfields in a form. There should be a possibiltity to set the max-value like it is in other fields of the form. The user should see a popup when the picture is bigger than max-value. So he can reduce the size of the picture.

Example: database for a scool. Pictures of all students are in the database. Pictures where shot with digicam 12 MP. The database will immediately blow up to more than 1 GB. Pictures are only used at the pc-monitor and for very little pictures (passport photo).

Could also be a good idea to reduce the pictures to the max-value, when the size is bigger. But I dont know if there is any function in LibreOffice which works like that from ImageMagic.
Comment 3 sasha.libreoffice 2012-05-02 03:46:03 UTC
Thanks for explanation.
Comment 4 Alex Thurgood 2015-01-03 17:40:10 UTC Comment hidden (no-value)