Binding a range of cells to simple csv data file

[jjj4]

This really is so simple but I can’t figure it out. I have a simple text file with a 3x3 matrix of csv numbers i.e.

2,7,5

9,9,0

3,2,1

I want to bind a grid of nine cells on my spreadsheet (say A1:C3) to that file.

if the file changes, i refresh the spreadsheet, the spread sheet changes. simple. i can do this all day long in *xcel.

this should be so simple its ridiculous but “sheet”->“link to external data” doesnt work.

[karolus]

It is possible to link the .csv into one sheet, via → Sheet → insert Sheet from file^[1] with [x] Link option in Import-dialog.

To refresh the sheet after changing the CSV file, use → Fiile → Reload

[1] In prior Versions of LO it was → insert → insert Sheet from File

[Lupp]

I don’t think there ever was an option to link in a csv as a table (data source).
You can link to tables contained in spreadsheets of Calc or Excel style or those contained in HTML files.

[PYS]

Hi

Sorry, I only have a short connection time and could not explain in detail but what is requested is possible…

• Follow the FAQ I’ve created showing how to link a text file to a database.
• Register the database: Tools▸Options▸LibreOffice Base▸Databases▸New (select the database)
• Then, in the spreadsheet, View▸Data Sources
• Unfold the Database▸Tables▸Click at the intersection of the row and column headers to select all data
• Click Data to Text in the Table Data toolbar: data is inserted into the sheet and one database range is created (default Import1) as you can see in the navigator.

Then just do Data▸Refresh Range to update the data

Longer to explain than to do …

Regards

[mariosv]

You can link to the csv file as it was a spreadsheet.

Opening both files it’s easier, and you can see how the sheet name it’s assigned.

[PYS]

Yes of course, but the question was not how to link a range of cells?

[mariosv]

I’m not sure, but anyway with this method there is no limit on the range (sheet limits), it’s easier using arrays to link.