#1

How do I insert selected data from base into a Calc spreadsheet?

1 Like
#7

Get the data source window (Ctrl+Shift+F4).
Navigate your databse and drag the icon of a query or a table onto a sheet cell.
The result will be a linked database range which can be refreshed by menu:Data>Refresh when any cell in that range is selected.
Call menu:Data>Define… and mark the entry “Import1” which is the default name of the linked database range.
Click the extra options and make sure that the following 2 options are checked:

  • Keep formatting which means the the spreadsheet formatting.
  • Insert or delete cells which resizes the changing import range by insertion and deletion of cells, preserving any other data/formulas from being overwritten.

Calculated fields (formulas adjacent to the import range) expand and shrink with the dynamic data range.

1 Like
#2

view > data sources > select your database table> select the data > press data to text button. I think…

1 Like
#6

However, this doesn’t appear to update the content in the calc spreadsheet when the database updates.

#8
#3

Hello,

The database needs to be registered. Usually this is done when the Base file is created but can be done at any time.

With a registered database all tables and queries are available in other modules. In Calc, from the menu View->DataSources or key combo of Shift+Ctrl+F4.

1 Like
How to send the output of a Query to a Sheet in Calc
#4

Thanks, got it.

I miss the data symbol from OpenOffice.

Just reciently converted from OO to LO.

#5

Please only use answers to actually answer the original question. Otherwise use add a comment to respond.

1 Like
#9

That answer was wrong. That button is disabled in Calc. Calc has more powerful options to copy or link database data.