Apache OpenOffice (AOO) Bugzilla – Issue 20815
form wizard save in doc format when default file format changed to doc
Last modified: 2006-05-31 14:29:06 UTC
Can create a form using Data Source \..db..\Links\New Document\Form Autopilot The form shows the data, allows updates etc. However, once I have saved the form, double clicking on it simply gets me a blank form in edit mode. Obviously I want the form linked to the Data Source, so that my user can use it to update the db. From the HELP files: "Data The Data tab page defines the form properties that refer to the database that is linked to the form. Defines the data source on which the form is based, or specifies whether the data can be edited by the user. Apart from the sort and filter functions, you will also find all the necessary properties to create a subform. To access this command... Choose Format - Form - Data tab Open context menu of a selected form element - choose Form - Data tab Open Form Functions floating toolbar from Main Toolbar or Design Mode Object Bar, click Form Properties icon - Data tab." But for the life of me I cannot find these functions. They are NOT under Choose Format - Form - Data tab - there is NO "Form" under "Format"??? Neither is there a "Forms Properties" under "Form Functions" - greyed out?? How do I link a form with the db in question so that my users can use it WITHOUT having to re-create it every time? I would have thought that the Autopilot would sort that out? Same problem under Linux (RedHat 9. Same problem, regardless of db type (ODBC, JDBC, dbase etc...)
Hi Albert, normally you find the form in the datasource browser. - Open a new document - press F4 or VIEW/DATASOURCES - open your datasource on the left hand side. - open the forms container ==>> there are your forms created with the autopilot. doubleclick the forms and you can use it as expect. Is this what you are looking for? If yes then please close this issue. If not please reopen it and give me more info. Bye Marc
Actually, it is a more subtle problem, but I finally cracked it. I had my document types defaulting to MS format, not OO format. Even though the "SAVE AS" of the form indicated .sxw format, they do not work when double clicking. Change the default document format to OOo (.swx) format, and now the forms work. To duplicate the problem, you have to a) set default file format to MS b) create a form c) CLOSE OOo d) double click on the form - then you get the form in edit mode, not as a "live" form (i.e. connected to a database) This is not clear from the help files - maybe a few words would explain? Lastly, just a word of thanks and admiration of the fantastic job you guys did - splendid! Thanks guys - you rock!
reopen, because it's still a bug.
change summary, set target , confirm and send to the right developer short description: - change default file format under TOOLS/OPTIONS/LOADSAVE/GENERAl to Word. - create a form with the form autopilot ==>> the form is saved in doc format ==>> the form doesn't work The wizard should save the form in OOo format.
Personally I think forms should always be saved in OOo format - after all, MSWord does not have that functionality, so what's the point in converting the form? OOo has a unique function here. IMHO, simply force the SAVE AS of a form in OOo format, regardless of default settings, and adjust the help files to indicate that forms will always be saved as OOo. (.sxw)
yes, this sounds very reasonable, Albert ...
I will overwork the formwizard for the next version and work this bug in.
change subcomponent to 'none'
BC: Forms and reports are now always saved with the "writer8" filter
.
Hi, fixed in cws dbwizard1 Bye Marc
Hi, verified in cws dbwizard1 Bye Marc
Hi, fixed in current developer build -> close. The current developer build can be found at http://download.openoffice.org/680/index.html Feel free to reopen if this issue is not fixed in the developer build. Bye Marc
Thanks for all the hard work -- will check it out as soon as I have some free time (exams & stuff, you know!) Albert
*** Issue 43313 has been marked as a duplicate of this issue. ***