Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2851
{ "count": 142802, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2852", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2850", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99014566/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049021Z", "action": 59, "target": "Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry.", "id": 36428374, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014543/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048996Z", "action": 59, "target": "The contents will be inserted as a link in the $[officename] Calc document.", "id": 36428373, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428373/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014530/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048970Z", "action": 59, "target": "Select one or more sheets or named ranges. You can also activate the automatic update function every \"n\" seconds and click <item type=\"menuitem\">OK</item>.", "id": 36428372, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014523/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048944Z", "action": 59, "target": "$[officename] loads the Web page or file in the \"background\", that is, without displaying it. In the large list box of the <item type=\"menuitem\">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from.", "id": 36428371, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014511/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048918Z", "action": 59, "target": "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 <item type=\"menuitem\">File - Open</item> dialog.", "id": 36428370, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428370/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014488/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048892Z", "action": 59, "target": "Choose <item type=\"menuitem\">Sheet - External Links</item>. The <link href=\"text/scalc/01/04090000.xhp\"><item type=\"menuitem\">External Data</item></link> dialog appears.", "id": 36428369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014465/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048865Z", "action": 59, "target": "In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data.", "id": 36428368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014448/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048839Z", "action": 59, "target": "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:", "id": 36428367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014428/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048813Z", "action": 59, "target": "<variable id=\"cellreferences_url\"><link href=\"text/scalc/guide/cellreferences_url.xhp\">Referencing URLs</link></variable>", "id": 36428366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014410/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048787Z", "action": 59, "target": "<bookmark_value>HTML; in sheet cells</bookmark_value><bookmark_value>references; URL in cells</bookmark_value><bookmark_value>cells; Internet references</bookmark_value><bookmark_value>URL; in Calc</bookmark_value>", "id": 36428365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014395/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048761Z", "action": 59, "target": "References to Other Sheets and Referencing URLs", "id": 36428364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014376/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048735Z", "action": 59, "target": "If you examine the name of the other document in this formula, you will notice that it is written as a <link href=\"text/shared/00/00000002.xhp#url\">URL</link>. This means that you can also enter a URL from the Internet.", "id": 36428363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014359/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048708Z", "action": 59, "target": "If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a \"$\" sign to designate it as an <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">absolute reference</link>.", "id": 36428362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014349/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048683Z", "action": 59, "target": "Confirm the formula by clicking the green check mark.", "id": 36428361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014316/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048656Z", "action": 59, "target": "The path and document name URI <emph>must always</emph> be enclosed in single quotes. If the name contains single quotes (') they must be escaped using two single quotes (''). Only a sheet name may not be quoted if it does not contain a space or a character that would be an operator or the name would be pure numeric (for example, '123' must be quoted).", "id": 36428360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014278/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048630Z", "action": 59, "target": "For example, <switchinline select=\"sys\"><caseinline select=\"WIN\">'file:///C:/Users/user/Documents/Price list.ods'#$'Information SKU'.H51</caseinline><defaultinline>'file:///home/user/Documents/Price list.ods'#$'Information SKU'.H51</defaultinline></switchinline>.", "id": 36428359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014256/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048604Z", "action": 59, "target": "The reference to a cell of another document contains the fully qualified name of the other document between single quotes <literal>(')</literal>, then a hash <literal>#</literal>, then the name of the sheet of the other document, followed by a period and the name or reference of the cell.", "id": 36428358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014207/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048577Z", "action": 59, "target": "Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you.", "id": 36428357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014199/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048551Z", "action": 59, "target": "Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.", "id": 36428356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014140/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048526Z", "action": 59, "target": "Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.", "id": 36428355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014124/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048501Z", "action": 59, "target": "Choose <emph>File - Open</emph>, to load an existing spreadsheet document.", "id": 36428354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014106/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048475Z", "action": 59, "target": "To Reference a Cell in Another Document", "id": 36428353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014090/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048449Z", "action": 59, "target": "The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href=\"text/shared/optionen/01060900.xhp\">Formula options page</link>.", "id": 36428352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014068/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048423Z", "action": 59, "target": "When referencing a sheet with name containing spaces, use single quotes around the name: <item type=\"literal\">='Sheet with spaces in name'.A1</item>", "id": 36428351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014032/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048397Z", "action": 59, "target": "If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.", "id": 36428350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014024/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048371Z", "action": 59, "target": "Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.", "id": 36428349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99014007/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048345Z", "action": 59, "target": "<item type=\"literal\">=Sheet2.A1</item>", "id": 36428348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013983/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048319Z", "action": 59, "target": "By way of example, enter the following formula in cell A1 of Sheet1:", "id": 36428347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013955/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048291Z", "action": 59, "target": "Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).", "id": 36428346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013931/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048256Z", "action": 59, "target": "To Reference a Cell in the Same Document", "id": 36428345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013891/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048231Z", "action": 59, "target": "In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file.", "id": 36428344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013863/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048204Z", "action": 59, "target": "In a sheet cell you can show a reference to a cell in another sheet.", "id": 36428343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428343/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013829/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048177Z", "action": 59, "target": "<variable id=\"cellreferences\"><link href=\"text/scalc/guide/cellreferences.xhp\">Referencing Other Sheets</link></variable>", "id": 36428342, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428342/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013816/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048150Z", "action": 59, "target": "<bookmark_value>sheet references</bookmark_value> <bookmark_value>references; to cells in other sheets/documents</bookmark_value> <bookmark_value>addresses; to cells in other sheets/documents</bookmark_value> <bookmark_value>cells; operating in another document</bookmark_value> <bookmark_value>documents;references</bookmark_value> <bookmark_value>cell;address</bookmark_value> <bookmark_value>address; of cell</bookmark_value>", "id": 36428341, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428341/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013773/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048125Z", "action": 59, "target": "Referencing a Cell in Another Document", "id": 36428340, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428340/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013729/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048099Z", "action": 59, "target": "This method can also be used to insert a range from another sheet of the same document into the current sheet. Select the active document as source in step 4 above.", "id": 36428339, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428339/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013709/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048073Z", "action": 59, "target": "Click the name under \"Range names\" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference.", "id": 36428338, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013689/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048048Z", "action": 59, "target": "Using the <emph>Drag Mode</emph> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy.", "id": 36428337, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428337/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013637/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.048022Z", "action": 59, "target": "In the Navigator, the source file object appears under \"Range names\".", "id": 36428336, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428336/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013621/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047997Z", "action": 59, "target": "Open the <link href=\"text/scalc/01/02110000.xhp\">Navigator</link>. In the lower box of the Navigator select the source file.", "id": 36428335, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013596/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047973Z", "action": 59, "target": "Open the sheet in which you want to insert something.", "id": 36428334, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428334/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013530/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047948Z", "action": 59, "target": "To set the source range as the range, select the cells and choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. Save the source document, and do not close it.", "id": 36428333, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428333/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013505/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047922Z", "action": 59, "target": "Open the document that contains the source cells.", "id": 36428332, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013482/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047897Z", "action": 59, "target": "With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link, or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file.", "id": 36428331, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428331/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013439/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047871Z", "action": 59, "target": "<variable id=\"cellreference_dragdrop\"><link href=\"text/scalc/guide/cellreference_dragdrop.xhp\">Referencing Cells by Drag-and-Drop</link></variable>", "id": 36428330, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428330/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013424/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047845Z", "action": 59, "target": "<bookmark_value>drag and drop; referencing cells</bookmark_value> <bookmark_value>cells; referencing by drag and drop </bookmark_value> <bookmark_value>references;inserting by drag and drop</bookmark_value> <bookmark_value>inserting;references, by drag and drop</bookmark_value>", "id": 36428329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013390/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047819Z", "action": 59, "target": "Referencing Cells by Drag-and-Drop", "id": 36428328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013373/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047793Z", "action": 59, "target": "By default, all cells of the selection, including the hidden cells, are copied, deleted, moved, or formatted. Restrict the selection to visible rows choosing <menuitem>Edit - Select - Select Visible Rows Only</menuitem> or to visible columns choosing <menuitem>Edit - Select - Select Visible Columns Only</menuitem>.", "id": 36428327, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428327/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013335/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047768Z", "action": 59, "target": "Copy, delete, move, or format a selection of currently visible cells.", "id": 36428326, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428326/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99013325/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.047743Z", "action": 59, "target": "Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href=\"text/scalc/01/12080000.xhp\">outline</link>.", "id": 36428325, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428325/?format=api" } ] }