From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/scalc/guide/cellreferences_url.xhp | 65 ++++++++++++++++++++++ 1 file changed, 65 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/cellreferences_url.xhp (limited to 'helpcontent2/source/text/scalc/guide/cellreferences_url.xhp') diff --git a/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp new file mode 100644 index 000000000..de83a313c --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp @@ -0,0 +1,65 @@ + + + + + + + + +References to Other Sheets and Referencing URLs +/text/scalc/guide/cellreferences_url.xhp + + + +HTML; in sheet cells +references; URL in cells +cells; Internet references +URL; in Calc +mw deleted "sheet references;" +Referencing URLs + +For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure: + + +In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data. + + +Choose Sheet - External Links. The External Data dialog appears. + + +Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the File - Open dialog. +$[officename] loads the Web page or file in the "background", that is, without displaying it. In the large list box of the External Data dialog, you can see the name of all the sheets or named ranges you can choose from. + + +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 $[officename] Calc document. + + +Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry. + + +Under %PRODUCTNAME - PreferencesTools - Options - %PRODUCTNAME 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. + + +
+ + +
+ + -- cgit v1.2.3