Move fields to the top or bottom

Discuss the database features

Move fields to the top or bottom

Postby arfgh » Fri Nov 04, 2016 3:52 pm

Hey guys.

I am unable to control what elements on my forms are over or under.
I have a form where i have an image control when on mouse over another 'imageprev' control that is bigger will be visible and show the image. On design time i selected that 'imageprev' and used the feature 'bring to the top' or whetever it is called in english. Also i selected all the labels and other fields and used the 'bring them to back' feature.

But for some reason, the labels keep over the 'imageprev'.

With libreoffice last version the result is worse. All the text fields and listbox etc etc keep over the imageprev control.

So i need a way to determine some 'zorder' or some...

thx in advance

Edit: Added AOO last version image. See the labels over the image control

Image

Edit: Added LibreOffice last version problem. See that all is over the image control

Image
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby arfgh » Sat Nov 05, 2016 5:36 pm

anybody ?

Villeroy, help :)
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby Villeroy » Sat Nov 05, 2016 8:09 pm

Looks like a bug. I can reproduce it with my own forms.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24594
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Move fields to the top or bottom

Postby arfgh » Sun Nov 06, 2016 1:56 am

i used a lot the features move to back, and bring to top, but the final result is that, always some field keep over. And in LO is worse as you see.
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby F3K Total » Sun Nov 06, 2016 2:31 pm

Hello,
the following was testet using AOO 4.1.3
IMPOV it's possible to define a zOrder of the controls on a form. I think it depends on their index in the structural form. You can simply reorder them, by using a helper form, see attached picture. The result appears not in design mode.
zOrder_controls.PNG
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 891
Joined: Fri Dec 16, 2011 8:20 pm

Re: Move fields to the top or bottom

Postby Villeroy » Sun Nov 06, 2016 5:54 pm

Wow! Very interesting. However, picture controls fall out of this order.

Simple form for testing: https://forum.openoffice.org/en/forum/d ... hp?id=3751
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24594
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Move fields to the top or bottom

Postby F3K Total » Sun Nov 06, 2016 6:06 pm

Villeroy wrote: picture controls fall out of this order.
Worked for me in AOO but not in LO :shock: See attached examples
z32.png
z32.png (5.75 KiB) Viewed 2881 times
I took care, that the helper form wasn't a subform, and dragged all controls first to the helper form and then back in correct order.
EDIT: I also have problems, if a subform is involved ...
R
Attachments
3over2.odt
(15.83 KiB) Downloaded 48 times
2over3.odt
(15.83 KiB) Downloaded 40 times
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 891
Joined: Fri Dec 16, 2011 8:20 pm

Re: Move fields to the top or bottom

Postby arfgh » Sun Nov 06, 2016 11:56 pm

anyways i imagine 'zorder' property doesnt exist in AOO Basic ?
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby arfgh » Fri Nov 11, 2016 4:27 pm

^^ i did all that but worked on a database and not in other. Yes, sub-forms involved.... Anyways it should exist in basic some way to control that order...
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby arfgh » Mon Mar 20, 2017 3:54 pm

guys, i hope in the next AOO version this problem is fixed, because it is a complete nightmare to control this problem..... I have tried tons times the solutions you gave here, with no success. If we have for example a big image control over all, and we want to make it visible, ALL THE LABELS WILL BE SHOWED OVER THE IMAGE. We can move to the top and blablalba, will never works.
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby Villeroy » Mon Mar 20, 2017 10:12 pm

arfgh wrote:guys, i hope in the next AOO version this problem is fixed, because it is a complete nightmare to control this problem..... I have tried tons times the solutions you gave here, with no success. If we have for example a big image control over all, and we want to make it visible, ALL THE LABELS WILL BE SHOWED OVER THE IMAGE. We can move to the top and blablalba, will never works.

Without a bug report no developer will ever notice that such a problem exists.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24594
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Move fields to the top or bottom

Postby arfgh » Fri Mar 24, 2017 5:19 pm

Is there a way to obtain all the form labels by index in order to hide them ?
I mean if is possible to get the labels collection by their index in order to interact with them.
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby Villeroy » Sat Mar 25, 2017 11:38 pm

You can loop through all controls and check each one if it is a label control.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24594
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Move fields to the top or bottom

Postby arfgh » Sun Mar 26, 2017 11:11 am

i know villeroy, but i have figured that exist other proper way to obtain the selective labels collection, without to loop through all controls...
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby arfgh » Sat Apr 01, 2017 2:12 am

is there a way to know programatically basic the number of controls in a form ?
also
is there a way to know programatically basic the control type ?
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby Villeroy » Sat Apr 01, 2017 11:19 am

I would fire up MRI to find the answer to all these questions. You can do the same.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24594
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Move fields to the top or bottom

Postby arfgh » Sat Apr 01, 2017 12:41 pm

i have thought about that, but i dont know how to use that extension...
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby robleyd » Sat Apr 01, 2017 12:44 pm

Perhaps you might find this tutorial on MRI helpful.
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Moderator
 
Posts: 1021
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Move fields to the top or bottom

Postby arfgh » Sun Apr 02, 2017 6:01 pm

Well, i am trying but for example... following the structure of a form with MRI to the last label with getByInex(38), i cant see in the MRI the way to use 'setVisible'. Isnt into the 'Methods' tab and in the macro i can use it. What am i missing ?
Also is there a way to see its control type ?
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 350
Joined: Tue Mar 05, 2013 6:44 pm

Re: Move fields to the top or bottom

Postby Arineckaig » Sun Apr 09, 2017 6:23 pm

i cant see in the MRI the way to use 'setVisible'. Isnt into the 'Methods' tab and in the macro i can use it. What am i missing ?
As I understand it, to remove the visibility of a Form Control its setVisible() method should be applied to the View of the Form Control. In this way the Model of the Form Control is left unchanged so that visibility is automatically restored as soon as the form document is closed and reopened.

Also is there a way to see its control type ?
Again as I understand it the most reliable type property for a Form Control tends to be its ImplementationName.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
OOo 4.1.1 on MS Windows XP MySQL and HSQLDB
Arineckaig
Volunteer
 
Posts: 827
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests