Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||[dBase]Form / subform controls not saved -- lost on reopening|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Version:||OOo 1.0.1||Keywords:||needhelp, oooqa|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description danstrome 2002-09-09 02:13:57 UTC
When making a form and subform (Autopilot > Form) to link two dBase tables together, most of the graphical controls are lost when the form is saved, closed, and reopened. Happened in about half of experiments. The Form Navigator thinks all the parts are still present, but most controls are not visible. This may be a UI issue. This issue is a response to the dev@dba mail message http://dba.openoffice.org/servlets/ReadMsg?msgId=398440&listName=dev The response was too long, so I zipped everything up and attached it to this issue. See attached zip file containing dBase tables, forms, two content.xml files, and a writer document explaining the procedure and results and comparing the content.xml files. Unzip the files into some directory and create a data source called exper_dbase_linked that points to the exper_dbase directory to make things work.
Comment 1 danstrome 2002-09-09 02:17:36 UTC
Created attachment 2770 [details] dBase tables, forms, and description for lost form controls - (zipped size = 76K)
Comment 2 Frank Schönheit 2002-09-09 07:48:50 UTC
Created attachment 2774 [details] Daniel's readme as extracted from his attachement
Comment 3 Frank Schönheit 2002-09-09 08:16:59 UTC
Daniel, thanks for the extensive explanations. I had a look into some of the documents, and they were definately broken (in a way which cannot easily be repaired during loading). Sadly, I have the small problem that I could not reproduce "Experiment 1" - I followed your instructions step-by-step, and everything was fine (in OpenOffice.org 1.0 as well as 1.0.1). I did not yet try the other scenarios (Marc, can you reproduce some of them?). Dealing with 1., it would be interesting if we can break this down. For instance: * does the same broken document appear if you only create the form with the auto pilot, and immediately reload it (without modifying)? * does the same broken document appear if you do only create the form, without creating the tables from scratch? BTW: The one effect you described (improper linking after creating the sub form with the grid) is because you entered "elemen01.elem_id" as "link master fields". You only need "elem_id", this is automatically set in the context of the parent form. After this, the linking works.
Comment 4 Frank Schönheit 2002-09-09 08:18:39 UTC
Daniel, another question: From the broken document, I supect the auto pilot is doing something wrong. Did you, on the second page, really only select the first button, or did you click around a little bit before, trying different layouts or such?
Comment 5 danstrome 2002-09-16 20:41:16 UTC
I should have left #1 out. It is the most complicated example, and I played around with a lot of settings. The other examples are simpler. Thanks for the hint about not needing to use table_name.column_name in the SQL statement. I had just been assuming it was needed. But I now see it works quite well without the table_name. I am uploading two more zipped files of examples, in which graphical control widgets disappeared during saving and reopening. Each has a separate readme. The first is more dBase table linking experiments, tried with and without the AutoPilot. The second is an example of using combo boxes to display the items in lookup (reference) tables, using 3 MySQL tables.
Comment 6 danstrome 2002-09-16 20:44:06 UTC
Created attachment 2858 [details] readme for dBase table linking experiments - part 2
Comment 7 danstrome 2002-09-16 20:59:19 UTC
Created attachment 2859 [details] zip of dBase tables and forms - part 2 (size = 70K)
Comment 8 danstrome 2002-09-16 21:06:25 UTC
Created attachment 2860 [details] readme for doctors-procedures forms with combo boxes
Comment 9 danstrome 2002-09-16 21:08:30 UTC
Created attachment 2861 [details] zip of doctors-procedures forms and mysql tables
Comment 10 marc.neumann 2002-10-11 11:47:20 UTC
set the status to started
Comment 11 marc.neumann 2003-02-18 10:02:05 UTC
Comment 12 hans_werner67 2004-02-02 12:33:03 UTC
change subcomponent to 'none'
Comment 13 thorsten.ziehm 2004-08-19 15:46:45 UTC
Because of limited resource for OOo2.0, it was decided to shift this tasks to the next milestone. If somebody will be found, who can implement this until OOo2.0, then this tasks will be re-targeted.