[Solved] Cannot remove filter/sort permantly

Creating and using forms

[Solved] Cannot remove filter/sort permantly

Postby thegoodguy » Mon Jul 29, 2013 3:11 pm

Hi all,

I have a simple form displaying names and addresses. I once applied a filter to the "Name" field so as to view only those names beginning with "c". This worked fine and I got the information I needed. The problem is that now, when ever I open the form, the "c" filter is ALWAYS applied. I have clicked the "remove filter/sort" several times and tried to delete the filter from the "filter navigator" window, but no luck. I cannot clear the filter from the form.

Can someone please let me know how I clear this applied filter.

Many thanks.
Last edited by thegoodguy on Mon Jul 29, 2013 4:37 pm, edited 1 time in total.
OpenOffice 3.4.1 on Windows 7 Pro
thegoodguy
 
Posts: 14
Joined: Sat Jul 13, 2013 6:09 pm

Re: Cannot remove filter/sort permantly

Postby Arineckaig » Mon Jul 29, 2013 4:31 pm

Can someone please let me know how I clear this applied filter.

Try opening the form document in edit mode and check that under the "Data" tab of the "Form Properties" dialog there is nothing entered in the "Filter" property box.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB
Arineckaig
Volunteer
 
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: Cannot remove filter/sort permantly

Postby thegoodguy » Mon Jul 29, 2013 4:36 pm

Brilliant! That was it :)

Thank you Arineckaig.
OpenOffice 3.4.1 on Windows 7 Pro
thegoodguy
 
Posts: 14
Joined: Sat Jul 13, 2013 6:09 pm

Re: [Solved] Cannot remove filter/sort permantly

Postby smirclehari » Fri Nov 15, 2019 7:47 am

Dear Sir,

I have sorted the data from a to z and saved. But im unable to clear the sorting and make as normal.Kindly help me out.

Hari
Thanks.,
OpenOffice 3.1 on Windows Vista
smirclehari
 
Posts: 1
Joined: Sun Jul 28, 2019 3:40 am

Re: [Solved] Cannot remove filter/sort permantly

Postby Zizi64 » Fri Nov 15, 2019 9:51 am

I have sorted the data from a to z and saved. But im unable to clear the sorting and make as normal.

The result of the sorting procedure can not Undoable after saving (after closeing/reopening the document). There is not stored any information for restoring the previous state.

You can
- re-sort the data by an another rule, even by usage of a helper column containing some data for the sorting.
- get a previous version of your file - if you made backup copies often.

 Edit: My post is related to the Calc documents. 
Last edited by Zizi64 on Fri Nov 15, 2019 11:19 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Cannot remove filter/sort permantly

Postby robleyd » Fri Nov 15, 2019 10:12 am

I have sorted the data from a to z


Are you doing this in Base, or perhaps in Calc - the spreadsheet component of OpenOffice?
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Forms

Who is online

Users browsing this forum: No registered users and 5 guests