Hello,
I'm new to Open Office. Having built a nice database and form, after adding a Table Control it appears that the displayed information cannot be sorted by each column. I've been poking around and at one time I thought I got the Table Control to be sortable by column. Is there a way to make the Table Control sort by each of the displayed columns?
Thank you.
Glen
[Solved] Sorting by column in a Table Control
-
- Posts: 2
- Joined: Tue Mar 01, 2016 4:50 am
[Solved] Sorting by column in a Table Control
Last edited by Hagar Delest on Wed Mar 02, 2016 11:16 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Open Office 4.1.2 Windows 10
Re: Sorting by column in a Table Control
Hello
Make a navigation control in your data-form. I mean the form as you see in the form-navigator.
Romke
Make a navigation control in your data-form. I mean the form as you see in the form-navigator.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: Sorting by column in a Table Control
As long as the columns are fields in the table or query the form is based on, you can sort pretty easily. As Romke indicated, the button to bring up the sort dialog is on the navigation control bar - it looks like "AZ"
If you have listboxes or calculated fields in your tablecontrol, those cannot be sorted.
If you have listboxes or calculated fields in your tablecontrol, those cannot be sorted.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
-
- Posts: 2
- Joined: Tue Mar 01, 2016 4:50 am
Re: Sorting by column in a Table Control
Many thanks for your help. I couldn't find the navigation control. Now it's installed on the form and life is good.
Glen
Glen
Open Office 4.1.2 Windows 10