[Archived] Open Office Spreadsheets

[Paul]

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

[Baz]

Have used Calc rarely but this forum looks like it covers what you may need.

Click

[Paul]

That looks like an interesting forum Baz, thanks