Ask Your Question

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

asked 2013-12-02 11:44:06 +0200

iwre0 gravatar image

updated 2013-12-04 08:29:53 +0200

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-16 00:22:12.825485

1 Answer

Sort by » oldest newest most voted

answered 2013-12-03 01:17:15 +0200

m.a.riosv gravatar image
edit flag offensive delete link more



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...

iwre0 gravatar imageiwre0 ( 2013-12-04 08:29:25 +0200 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2013-12-04 11:36:30 +0200 )edit

Question Tools

1 follower


Asked: 2013-12-02 11:44:06 +0200

Seen: 1,726 times

Last updated: Dec 04 '13