Ask Your Question

Calc data source as fields [closed]

asked 2017-07-19 23:38:30 +0100

Joe Castor gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Joe Castor
close date 2017-07-24 03:31:18.643571

2 Answers

Sort by » oldest newest most voted

answered 2017-07-20 23:42:58 +0100

m.a.riosv gravatar image

Look on Menu/Data/Define range/optiins to keep the format.

edit flag offensive delete link more


Great. Thanks. Exactly what I was searching for. Works perfect.

Joe Castor gravatar imageJoe Castor ( 2017-07-24 03:27:46 +0100 )edit

answered 2017-07-20 22:43:16 +0100

Joe Castor gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-19 23:38:30 +0100

Seen: 121 times

Last updated: Jul 20 '17