I'm in table data view and have a column I want to move. The help says to use the format menu and then either left ot right arrow to move the column. In my menu heading I do not have the format option, only file, Edit, View, Insert, Tools, Window and Help
Please how can I move this column in my data view?
Went in via Base
Can't move a column
-
nitramtrah
- Posts: 6
- Joined: Sat Sep 04, 2010 12:45 pm
Can't move a column
Last edited by nitramtrah on Fri Apr 08, 2011 3:37 pm, edited 2 times in total.
Martin with OpenOfficeOrg 3.2.1 on Windows 7
Re: Can't move a column
Hi,
Wich application was used when this happened ? Writer-table, Calc or Base?
Wich application was used when this happened ? Writer-table, Calc or Base?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
nitramtrah
- Posts: 6
- Joined: Sat Sep 04, 2010 12:45 pm
Re: Can't move a column
The help probably refers to the table grid control in forms, but not to the thing that you get when you double click on a table in the main window of Base.
That's an internal thing about databases. They don't have an order, not how the records/lines appear and not how the columns show up.
Well, the columns show up in the order how they were created. If you want to change this later on, either duplicate your table with the columns in different order in the new table, or build a query where you can specify sequence of the columns. Double-clicking on a query will show you the same table grid like a double click on a table, but in most cases Base won't allow you to insert new rows or modify the data. In other words the query is read only.
For a quick way to get a table grid with the order of the columns that suits you use the form wizard with only a main form for this table. The form wizard allows you in the 3rd or 4th step to specify the order of the columns.
That's an internal thing about databases. They don't have an order, not how the records/lines appear and not how the columns show up.
Well, the columns show up in the order how they were created. If you want to change this later on, either duplicate your table with the columns in different order in the new table, or build a query where you can specify sequence of the columns. Double-clicking on a query will show you the same table grid like a double click on a table, but in most cases Base won't allow you to insert new rows or modify the data. In other words the query is read only.
For a quick way to get a table grid with the order of the columns that suits you use the form wizard with only a main form for this table. The form wizard allows you in the 3rd or 4th step to specify the order of the columns.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
Re: Can't move a column
Just stumbled over this tutorial on how to re-arrange columns. It maybe helpful.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
Re: Can't move a column
The order of rows and columns in a database is completely meaningless.
A most simple query like
SELECT "F3", "F2", "F1", "F4" "ID" FROM "TableName" ORDER BY "F1"
returns the row set in your desired order of rows and columns with no access limitations as long as the primary key is included (the "ID" field in my example).
You can create this most simple type of query in the graphical query designer.
On your form you can simply change the appearance as well as the tab order independently from the underlying row set.
A most simple query like
SELECT "F3", "F2", "F1", "F4" "ID" FROM "TableName" ORDER BY "F1"
returns the row set in your desired order of rows and columns with no access limitations as long as the primary key is included (the "ID" field in my example).
You can create this most simple type of query in the graphical query designer.
On your form you can simply change the appearance as well as the tab order independently from the underlying row set.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice