Filter issue on Open Office
Solved
chnordiste
-
plaoureux -
plaoureux -
Hello,
I have a problem and I would like to have your help...
I have Open Office and Excel...
In a document on Excel, I set up filters to select a specific person.
In Excel, no problem, when I select my filter, I have all the names appearing in the dropdown list
In Open Office, I have the filter but it is empty, it just says "All - Standard - top 10" but no names...
I performed the operation in Open Office, which is Data - Filter - uncheck AutoFilter
and then did the reverse operation: Data - Filter - check AutoFilter
But nothing, still the same result..
Does anyone have an idea of the problem encountered and if so, can you help me????
Thank you very much in advance
Sab
I have a problem and I would like to have your help...
I have Open Office and Excel...
In a document on Excel, I set up filters to select a specific person.
In Excel, no problem, when I select my filter, I have all the names appearing in the dropdown list
In Open Office, I have the filter but it is empty, it just says "All - Standard - top 10" but no names...
I performed the operation in Open Office, which is Data - Filter - uncheck AutoFilter
and then did the reverse operation: Data - Filter - check AutoFilter
But nothing, still the same result..
Does anyone have an idea of the problem encountered and if so, can you help me????
Thank you very much in advance
Sab
Configuration: Windows XP Firefox 2.0.0.6
10 réponses
Hello,
I have a problem and I would really appreciate it if someone could help me...
After reformatting my laptop, I was installed Open Office (I used to use Word). I can open most of my Word documents except for those I created on my desktop computer. I'm using Word 2003 on that computer. When I try to open them with Open Office on my laptop and select the appropriate filter: Word 2003 XML, it opens my documents blank; the text doesn't appear...
Should I download another version of Open Office? Or other filters?...
If anyone is able to help me, I would be very grateful...
Thank you in advance.
I have a problem and I would really appreciate it if someone could help me...
After reformatting my laptop, I was installed Open Office (I used to use Word). I can open most of my Word documents except for those I created on my desktop computer. I'm using Word 2003 on that computer. When I try to open them with Open Office on my laptop and select the appropriate filter: Word 2003 XML, it opens my documents blank; the text doesn't appear...
Should I download another version of Open Office? Or other filters?...
If anyone is able to help me, I would be very grateful...
Thank you in advance.
Otherwise, go to the OpenOffice website and download an add-on called Autofilter. This add-on, once installed, allows you to create filters just like in Excel, meaning you can have multiple filters in the same workbook and you don't need to select your entire data range.
However, be careful with the AND and OR filters, which require the special filter.
However, be careful with the AND and OR filters, which require the special filter.
Indeed, normally filters in Excel work with Open Office, but on my file, there is indeed a filter, but it only filters the first row, which is the header... I only have the following options: "All - Standard - Top 10".
Even if I restart creating my filters in Open Office... selecting the entire table
It's strange, isn't it?
Even if I restart creating my filters in Open Office... selecting the entire table
It's strange, isn't it?
weird, yeah!
have you tried applying the auto filter by selecting the row where your field is located?
have you tried applying the auto filter by selecting the row where your field is located?
I took the test, still the same problem...
I did another one on a different document... and there it works...
I think my problem comes from my spreadsheet...
I'm going to transfer my data to another document... I think that's the best solution...
Thank you for your help
But what I experienced is still strange...
A thousand thanks to you Ksign
Chnordiste
I did another one on a different document... and there it works...
I think my problem comes from my spreadsheet...
I'm going to transfer my data to another document... I think that's the best solution...
Thank you for your help
But what I experienced is still strange...
A thousand thanks to you Ksign
Chnordiste
Often faced with the same problem, I just discovered that the autoFilter is based on the data selected at the time of its activation ...
Specifically, in Excel, you just need to select the header row of the columns for the autoFilter to set itself based on all the values contained in each of the columns ... In OOo, you have to select the rows you want to include ... Confusing at first, it should provide interesting flexibility when you only want to work on a part of the data ... But everyone will have their own opinion ...
Séb
Specifically, in Excel, you just need to select the header row of the columns for the autoFilter to set itself based on all the values contained in each of the columns ... In OOo, you have to select the rows you want to include ... Confusing at first, it should provide interesting flexibility when you only want to work on a part of the data ... But everyone will have their own opinion ...
Séb
For the auto filter problem, it's not quite like that. The auto filter in OOo behaves like in Excel, except if there are empty cells between the filled ones, then you have to do the manipulation as explained above. A second difference is that empty or non-empty fields are not proposed either in the auto filter list; you have to use the standard filter and select empty or non-empty to search based on those criteria.
Are you sure it’s MS-Word 2003? Couldn’t it be 2007?
--
<signature>Why hack MS-Office when there is a free solution? Use OpenOffice.org</signature>