Re: Calc: Complex searches

2023-03-23 Thread David Robley
There is some discussion at https://forum.openoffice.org/en/forum/viewtopic.php?t=46565 which you might find useful. Since you are not subscribed to this list you may not see all the replies to your query. To subscribe to Apache OpenOffice mailing lists go to http://openoffice.apache.org/mail

Calc: Complex searches

2023-03-23 Thread helices
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