en gl gl it gl ca en gl gl en gl gl en en en en gl en pt gl en en en en
References to Other Sheets and Referencing URLs
Por exemplo, se atopa unha páxina en Internet que conteña información de bolsa en celas de folla de cálculo, pode cargar esta páxina no Calc do LibreOffice empregando o procedemento seguinte:
Nun documento do Calc do LibreOffice, coloque o cursor na cela na que desexe inserir os datos externos.
Choose Sheet - External Links. The External Data dialog appears.
Introduza o URL do documento ou páxina web na caixa de diálogo. O URL debe ter o formato: http:///www.o-meu-banco.gal/táboa.html. O URL dos ficheiros locais ou da rede local está na ruta que ve a caixa de diálogo Ficheiro - Abrir.
O LibreOffice carga a páxina web ou ficheiro «no fondo», ou sexa, sen mostrar o proceso. Na extensa lista da caixa de diálogo Datos externos pódese ver o nome de todas as follas ou intervalos con nome que se poden escoller.
Select one or more sheets or named ranges. You can also activate the automatic update function every "n" seconds and click OK.
The contents will be inserted as a link in the LibreOffice Calc document.
Save your spreadsheet. When you open it again later, LibreOffice Calc will update the linked cells following an inquiry.
Under LibreOffice - PreferencesTools - Options - LibreOffice Calc - General you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under Edit - Links.
Inserting External Data in Table (WebQuery)
Precisamos da súa axuda!
Impressum (Legal Info) | Privacy Policy | Statutes (non-binding English translation) - Satzung (binding German version) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Mozilla Public License v2.0. “LibreOffice” and “The Document Foundation” are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy. LibreOffice was based on OpenOffice.org.
Help content debug info:
This page is: /text/scalc/guide/cellreferences_url.xhp
Title is: References to Other Sheets and Referencing URLs