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 field H > 95 or field K > 95 or field P > 95 A. How can such searches be done within Calc? B. How can I convert this spreadsheet into a database table, accesssible to SQL-like queries, like the above example? What else ought I consider? Please, advise. Thank you. ~ Mike