Bug 43929

Summary: EDITING Tables: Changing of maximum value of binary-fields must be possible
Product: LibreOffice Reporter: robert
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: dr, iplaw67, sasha.libreoffice
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description robert 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 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
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.