Issue 51485

Summary:	change order of fields using Table Designer
Product:	Base	Reporter:	aziem <ahz001>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	arbedall, issues
Version:	680m113
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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