Issue 51485 - change order of fields using Table Designer
Summary: change order of fields using Table Designer
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m113
Hardware: All All
: P4 Trivial with 12 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 47667 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-07-01 23:32 UTC by aziem
Modified: 2014-06-05 05:58 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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