Apache OpenOffice (AOO) Bugzilla – Issue 53282
"form as table" view seems to have arbitrary and illogical column order
Last modified: 2017-05-20 10:44:42 UTC
As the summary already says it, you can't change the order of the database table columns in the datasource view connected to a form. I open this table on the top of the form e. g. with document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") dispatcher.executeDispatch(document, ".uno:ViewFormAsGrid", "", 0, Array()) I would very very much appreciate if you could bring this feature into the next version! I'm sure that a lot of other people will also stumble over this missing feature, above all when the final release is out and people will experiment with the new form / database features. Best regards Helge Kraak
I forgot to say, that it would already be a big improvement, if the columns would follow the tab activation order you set in the form fields. Until now I don't see any logic behind the column order (e.g. alphabetical arrangement or something similar). it seems to me that the order at the moment is taken from the order in which you created the form fields. I only estimate, didn't verify it myself.
changing summary from Datasource view of form connected table not influencable regarding the column order to "form as table" view seems to have unchangeable, arbitrary and illogical column order (Helge, if this doesn't completely meet the problem you mean, we have to change again :) Yes, in fact the order is taken from the "logical" order of controls within their form (see the form navigator), which usually is the order in which the fields were created. And no, there won't be any fix for this in OOo 2.0, sorry, but in the current phase (near the release), it's simply not important enough anymore.
Hi Frank, your new description meets the problem very good. Thank you :-)!
Reset the assignee to the default "issues@openoffice.apache.org".