[Solved] Manual Form Creation - Grid

Creating and using forms

[Solved] Manual Form Creation - Grid

Postby mazatak » Mon Nov 15, 2010 6:38 pm

Hi All,

please can someone put me out of my misery ... I have been trying for two weeks to find a way to manually create a sub-form of type Grid and I can' for the life of me find how to do that. I can add a normal sub-form from the form navigator but I don't see an option to use grid instead of the text entry fields. I have not seen the answer to this in any posts or documentation I have gone through so far, but apologies if I have missed it.

Thanks

Maz
OpenOffice 3.2.1 on Windows 7
mazatak
 
Posts: 12
Joined: Thu Nov 04, 2010 2:03 pm

Re: Manual Form Creation - Grid

Postby Villeroy » Mon Nov 15, 2010 6:47 pm

Toolbar "Form Design" has all the tools you need.
Get the form navigator from its button #5, build a hierarchy of forms and subforms (as many as needed to depict the relations), select forms and controls, move forms and subforms across other forms and subforms, drag fields onto your form, your grid control.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Manual Form Creation - Grid

Postby mazatak » Mon Nov 15, 2010 7:09 pm

Hi Vileroy,

you have just described what I do to get the normal forms but I still don't see how to create grid forms instead of normal ones. By grid forms I mean a form in tabular format like the one below:

grid.jpg
grid.jpg (25.56 KiB) Viewed 2704 times

What am I missing?

Maz
OpenOffice 3.2.1 on Windows 7
mazatak
 
Posts: 12
Joined: Thu Nov 04, 2010 2:03 pm

Re: Manual Form Creation - Grid

Postby Villeroy » Mon Nov 15, 2010 7:26 pm

From any form you get a grid for free when you hit the last button on toolbar "Form Navigation" (the one you should see while working with the form).

Building a table control form from scratch:
Create new form in design view (or use any Writer or spreadsheet doc)
View>Toolbars>Form Design
Button #5
Right-click the top-level forms container and add a form.
Get its properties, name it, bind it.
View>Toolbars>Form Controls
Button "More Controls"
Pick the tool to draw a table control.
Draw the grid, skip the stupid wizard.
Hit button #6 on "Form Design"
Drag some field onto the form and onto the grid as well.
You may replace the new form field or table column with some other control type (right-click>replace with>...)
Explore the other button of "Form Design"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Solved Re: Manual Form Creation - Grid

Postby mazatak » Tue Nov 16, 2010 12:49 pm

Hi Villeroy,

that worked beautifully. Thank you very much!

Maz
OpenOffice 3.2.1 on Windows 7
mazatak
 
Posts: 12
Joined: Thu Nov 04, 2010 2:03 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests