In Calc, I’m accessing a data source (LO Database query), and when trying to move the query data into the Calc sheet as “fields”, I only have the choice of “text” and not “fields.” I am trying to create a list in Calc that will update from the database query data source when the Calc sheet is opened. I am doing conditional formatting on one column (date test, change cell to yellow background), which I’m hoping will remain when updated. Help will be greatly appreciated.
Answering my own question, at least as a partial answer, I have learned that after opening View/ “Data Sources” dialog on the left of the Calc screen, identify the Table or Query, and drag the object (name) from the list directly into a cell (A1). Once that’s done, the file can be closed, then reopened as needed, and from the Data menu, clicking on “Refresh Range” will update the data in the sheet. This process substitutes what I was trying to do satisfactorily.
The next step is to keep the cell formatting when the Refresh occurs. Conditional formatting is retained but nothing else. Joe
Look on Menu/Data/Define range/optiins to keep the format.
Great. Thanks. Exactly what I was searching for. Works perfect.