Calc: Complex searches

Over the last few years, I have an OpenOffice Calc spreadsheet that has grown to: 500 rows X 100 columns Simple searches are too limited: Find rows where field D = someText Need to do more complex "queries" like: Show all rows Where field A is blank and field D = someText and f

Calc: How to graph polynomial trend line like Excel?

How can we create more complex trend lines in Calc, like the Polynomial line in Excel? ~ Mike