Jump to content

BRFCS

BY THE FANS, FOR THE FANS
SINCE 1996
Proudly partnered with TheTerraceStore.com

[Archived] Open Office Spreadsheets


Recommended Posts

I use Open Office occassionally and only ever the spreadsheet. It's running on an Asus using Linux. The spreadsheet is one I have created in Excel as a .xls ( I also have .xlsx) and transferred to the Asus on a data stick. I'm not doing anything complicated but have one small problem I can't solve, applying AutoFilter. I select my headings row, always the first row in my case, click Data, Filter, AutoFilter and the drop down arrows appear. I then click a drop down arrow and I'm shown:

-all-

-Standard-

-Top 10 -

-empty-

-not empty-

If I was using Excel I would see all the different items in the column as my filter options. I can't get this in Open Office

Can anyone suggest where I'm going wrong?

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.