[Solved] how can i get a Libreoffice Calc always updated from external data file text origin?

[iwre0]

I know how to do it with excel. In the menu Data i can connect with text file, so as soon i open my excel file all the data is up to date depending text file.

This is a video showing what i’m trying to say.

How can i do the same with Libreoffice?
My ERP gives a lot information in text file format, so i want to work with them with Libreoffice as quickly and confortable as excel, so the user should not to know where the data origin is

Thank you

[mariosv]

Please take a look to this thread.

How do I automatically import numbers from a text document to a cell or cell area in Libre Calc?

Hi all, I have a lot of text documents to copy into Libre Calc sheets. I can’t do regular file import because there is other stuff in the sheet as well. I would like to have either each cell call numbers from the text document, or import the file into a certain cell range/area of the sheet. I don’t want to just copy/paste the text files because this gets very time consuming when there are a lot of them! Is there an automated function for this or a command-method to do this? If not, is there a …

[iwre0]

Thank you very much mariosv

The only difference is that is not possible to avoid ask to the user if wants update the data or not when he is openning the document.

There is another one. You can not put any data in the same sheet that is used to import the external file data, otherwise it wil be deleted.
But I think i can live with that…

[mariosv]

There is an option in Menu/Tools/Options/LibreOffice calc/General - Updating.