At work we have switched from Excel to OOo. We had a database with 10 columns, the header on each has a drop down arrow to select any data entered into that field to sort info.
Entries from Excel still sort, but none of the new rows of info I have added will.
A co-worker uses the same file without this problem.
Sorry if this is basic, but I'm not sure where my settings are different...
Thanks!
[Solved] New data wont sort
-
zoe the noob
- Posts: 2
- Joined: Thu Dec 27, 2007 9:24 pm
[Solved] New data wont sort
Last edited by Hagar Delest on Sun May 19, 2013 7:28 pm, edited 3 times in total.
Reason: tagged solved.
Reason: tagged solved.
-
Hagar Delest
- Moderator
- Posts: 32667
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: New data wont sort
It's a bug for new rows in Calc, you should subscribe and vote for that request (up to 2 votes per issue) : Issue 59229 - Autofilter does not recognize added entries.
NB: workaround = remove the AutoFilter and reactivate it.
NB: workaround = remove the AutoFilter and reactivate it.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
-
zoe the noob
- Posts: 2
- Joined: Thu Dec 27, 2007 9:24 pm
Re: New data wont sort
Thanks.
Will try out the work around soon.
In the meantime I did put in a vote for this issue.
Will try out the work around soon.
In the meantime I did put in a vote for this issue.