Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||change order of fields using Table Designer|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description aziem 2005-07-01 23:32:58 UTC
In the Database Table Designer, it would be helpful to be able to change the order of the fields. The user should be able to drag one field and place it in front of another. The drag and drop method is preferable. I also tried cut and paste. Paste puts the field at the end instead of before the current position.
Comment 1 marc.neumann 2005-07-04 13:26:52 UTC
Hi, This can't be possible ATM, because most databases doesn't allow to insert a field between two other. Anyway, this is still a valid enhancement request and may be some days in the future database will allow those things. I reassign it to the User Experience Team for evaluating. Bye Marc
Comment 2 Frank Schönheit 2005-07-25 13:20:07 UTC
*** Issue 47667 has been marked as a duplicate of this issue. ***
Comment 3 brex14 2006-12-24 13:51:18 UTC
Microsoft Access changes order of fields...
Comment 4 ioneil 2006-12-24 14:14:10 UTC
"This can't be possible ATM, because most databases doesn't allow to insert a field between two other. Anyway, this is still a valid enhancement request and may be some days in the future database will allow those things." That's the advantage of having the OOo frontend to the database: shouldn't we be able to transparently wrap this functionality into any backend? Two possibilities come to mind: 1) create a new table with the the old data but new column order, then delete the old one 2) create an invisible system table for OOo that has the preferred column order, and use it whenever presenting data to the user. The first option is probably more robust, but also more computationally expensive, depending on the number of records in the table to be re-ordered. Cheers, -im
Comment 5 marsman 2007-04-18 09:31:22 UTC
I really need this. With cut and paste it is possible to change the order any way you like, but when saved it returns to the original state.
Comment 6 flutaphone 2008-05-13 05:23:37 UTC
I would like to vote for this also. I frequently like to bypass forms, etc, and enter my data into a table. But I would like to be able to adjust the table so I enter the items in an intuitive order for maximum efficiency.
Comment 7 taboutanche 2014-06-05 05:58:10 UTC
i have the same problem in tables edition. and also in requests it's will be helpfull to move colums before saving the request. drag and drop : yes