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/mailing-lists.html
As a courtesy I have forwarded a copy of this reply to you as well as to
the mailing list. Do Not reply to me personally but just to the list at
<users@openoffice.apache.org> - replies to my personal email address
will be ignored.
On 24/03/2023 06:29, helices wrote:
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
