Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=44
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=45", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=43", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold." ], "previous_source": "", "target": [ "" ], "id_hash": -6964637376951726322, "content_hash": -6964637376951726322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id291612447349416\nhelp.text", "note": "Fa8kD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110982842/?format=api", "priority": 100, "id": 112354507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1f58a334b5624f0e", "url": "https://translations.documentfoundation.org/api/units/112354507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.555342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon." ], "previous_source": "", "target": [ "" ], "id_hash": -4588238262470200363, "content_hash": -4588238262470200363, "location": "04060109.xhp", "context": "04060109.xhp\npar_id971612447352912\nhelp.text", "note": "LbWuo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110982919/?format=api", "priority": 100, "id": 112354508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=40534d9c1c9bb3d5", "url": "https://translations.documentfoundation.org/api/units/112354508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.556357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110982968/?format=api", "priority": 100, "id": 112354509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/112354509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.557553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982986/?format=api", "priority": 100, "id": 112354510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/112354510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.559754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3064035665891014416, "content_hash": -3064035665891014416, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154564\nhelp.text", "note": "VAtaY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/110983023/?format=api", "priority": 100, "id": 112354511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=557a5bcbbb7048f0", "url": "https://translations.documentfoundation.org/api/units/112354511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.561809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "ROW([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 2805314088482138516, "content_hash": 2805314088482138516, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154916\nhelp.text", "note": "97EEE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110983079/?format=api", "priority": 100, "id": 112354512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a6ee7a4cdf606994", "url": "https://translations.documentfoundation.org/api/units/112354512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.564117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "" ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110983133/?format=api", "priority": 100, "id": 112354513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/112354513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.566155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "" ], "id_hash": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110983516/?format=api", "priority": 100, "id": 112354514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/112354514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.568228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "" ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110983575/?format=api", "priority": 100, "id": 112354515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/112354515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.570464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "" ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110983667/?format=api", "priority": 100, "id": 112354516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/112354516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.572452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110983735/?format=api", "priority": 100, "id": 112354517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/112354517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.574937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "" ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110983778/?format=api", "priority": 100, "id": 112354518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/112354518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.576806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "" ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110983785/?format=api", "priority": 100, "id": 112354519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/112354519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.578427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "" ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110983820/?format=api", "priority": 100, "id": 112354520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/112354520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.579549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110983876/?format=api", "priority": 100, "id": 112354521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/112354521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.580616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110983915/?format=api", "priority": 100, "id": 112354522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/112354522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.581695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110983938/?format=api", "priority": 100, "id": 112354523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/112354523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.582771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2168, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110983953/?format=api", "priority": 100, "id": 112354524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/112354524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.583811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "" ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110983969/?format=api", "priority": 100, "id": 112354525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/112354525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.584817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "" ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2170, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110983987/?format=api", "priority": 100, "id": 112354526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/112354526/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.585843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2171, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110984005/?format=api", "priority": 100, "id": 112354527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/112354527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.586868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "" ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110984027/?format=api", "priority": 100, "id": 112354528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/112354528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.587901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110984039/?format=api", "priority": 100, "id": 112354529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/112354529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.588900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110984114/?format=api", "priority": 100, "id": 112354530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/112354530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.589879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110984133/?format=api", "priority": 100, "id": 112354531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/112354531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.590869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you use the optional <emph>CellValue</emph> parameter, the formula locates the URL, and then displays the text or number." ], "previous_source": "", "target": [ "" ], "id_hash": 218980914375213094, "content_hash": 218980914375213094, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11800\nhelp.text", "note": "ciAoA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110984162/?format=api", "priority": 100, "id": 112354532, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8309f9fb3decc026", "url": "https://translations.documentfoundation.org/api/units/112354532/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.591934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110984221/?format=api", "priority": 100, "id": 112354533, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/112354533/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.592940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "HYPERLINK(\"URL\" [; CellValue])" ], "previous_source": "", "target": [ "" ], "id_hash": -8168208340886170970, "content_hash": -8168208340886170970, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1180E\nhelp.text", "note": "YFNSo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110984274/?format=api", "priority": 100, "id": 112354534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0ea4b1ca7e18d2a6", "url": "https://translations.documentfoundation.org/api/units/112354534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.593960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>URL</emph> specifies the link target. The optional <emph>CellValue</emph> parameter is the text or a number that is displayed in the cell and will be returned as the result. If the <emph>CellValue</emph> parameter is not specified, the <emph>URL</emph> is displayed in the cell text and will be returned as the result." ], "previous_source": "", "target": [ "" ], "id_hash": -6880188934720839068, "content_hash": -6880188934720839068, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11811\nhelp.text", "note": "weY4K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110984310/?format=api", "priority": 100, "id": 112354535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2084a89dde642264", "url": "https://translations.documentfoundation.org/api/units/112354535/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.594951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "" ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110984356/?format=api", "priority": 100, "id": 112354536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/112354536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.595987Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\")</input> displays the text \"http://www.example.org\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -6685719284871824382, "content_hash": -6685719284871824382, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11827\nhelp.text", "note": "frvbX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110984392/?format=api", "priority": 100, "id": 112354537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=23378dbb9d3c7c02", "url": "https://translations.documentfoundation.org/api/units/112354537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.596994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";\"Click here\")</input> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 1277222501774768595, "content_hash": 1277222501774768595, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182A\nhelp.text", "note": "wHG7A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110984427/?format=api", "priority": 100, "id": 112354538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=91b99b192d6bb9d3", "url": "https://translations.documentfoundation.org/api/units/112354538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.597998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";12345)</input> displays the number 12345 and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -2085945883601083680, "content_hash": -2085945883601083680, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224534\nhelp.text", "note": "jamR2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110984464/?format=api", "priority": 100, "id": 112354539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=630d3b454b44e2e0", "url": "https://translations.documentfoundation.org/api/units/112354539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.599009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK($B4)</input> where cell B4 contains <literal>http://www.example.org</literal>. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result." ], "previous_source": "", "target": [ "" ], "id_hash": -45593686545329457, "content_hash": -45593686545329457, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182D\nhelp.text", "note": "qLdBN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110984476/?format=api", "priority": 100, "id": 112354540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7f5e04c89d7712cf", "url": "https://translations.documentfoundation.org/api/units/112354540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.600004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\"</input> displays the text Click example.org in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 2830691007777424645, "content_hash": 2830691007777424645, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11830\nhelp.text", "note": "cWDrv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110984477/?format=api", "priority": 100, "id": 112354541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a748a27953774505", "url": "https://translations.documentfoundation.org/api/units/112354541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.601019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"#Sheet1.A1\";\"Go to top\")</input> displays the text Go to top and jumps to cell Sheet1.A1 in this document." ], "previous_source": "", "target": [ "" ], "id_hash": 1869041006723579226, "content_hash": 1869041006723579226, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8859523\nhelp.text", "note": "DDEtK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2186, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110984478/?format=api", "priority": 100, "id": 112354542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=99f02ae49c65bd5a", "url": "https://translations.documentfoundation.org/api/units/112354542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.602091Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</input> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." ], "previous_source": "", "target": [ "" ], "id_hash": 2843765593580861418, "content_hash": 2843765593580861418, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2958769\nhelp.text", "note": "CoMEq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2187, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110984479/?format=api", "priority": 100, "id": 112354543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a77715bd8ddd77ea", "url": "https://translations.documentfoundation.org/api/units/112354543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.603364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Open Documents folder\")</input> displays the text \"Open Documents folder\" and shows the folder contents using the standard file manager in your operating system." ], "previous_source": "", "target": [ "" ], "id_hash": 1287100061349521092, "content_hash": 1287100061349521092, "location": "04060109.xhp", "context": "04060109.xhp\npar_id321615667588042\nhelp.text", "note": "Ky2xV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110984480/?format=api", "priority": 100, "id": 112354544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=91dcb2afbb1f26c4", "url": "https://translations.documentfoundation.org/api/units/112354544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.604857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110984541/?format=api", "priority": 100, "id": 112354545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/112354545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.606508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2190, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110984555/?format=api", "priority": 100, "id": 112354546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/112354546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.607889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110984583/?format=api", "priority": 100, "id": 112354547, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/112354547/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.609580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110984608/?format=api", "priority": 100, "id": 112354548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/112354548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.611264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]])" ], "previous_source": "", "target": [ "" ], "id_hash": 1808508286739262810, "content_hash": 1808508286739262810, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1665089\nhelp.text", "note": "V3C9Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110984636/?format=api", "priority": 100, "id": 112354549, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=99191cb47471ad5a", "url": "https://translations.documentfoundation.org/api/units/112354549/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.613330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "" ], "id_hash": -1930907858890907289, "content_hash": -1930907858890907289, "location": "04060109.xhp", "context": "04060109.xhp\npar_id661585662472832\nhelp.text", "note": "3kCjF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110984651/?format=api", "priority": 100, "id": 112354550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6534098860cc2167", "url": "https://translations.documentfoundation.org/api/units/112354550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.614402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110984712/?format=api", "priority": 100, "id": 112354551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/112354551/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.615641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "" ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2196, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/110984741/?format=api", "priority": 100, "id": 112354552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/112354552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.617038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "First Syntax" ], "previous_source": "", "target": [ "" ], "id_hash": 7980984110325482547, "content_hash": 7980984110325482547, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id431585688827982\nhelp.text", "note": "Cwsfn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110984764/?format=api", "priority": 100, "id": 112354553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eec226c365fcc433", "url": "https://translations.documentfoundation.org/api/units/112354553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.618617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." ], "previous_source": "", "target": [ "" ], "id_hash": -7239259067986216298, "content_hash": -7239259067986216298, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9302346\nhelp.text", "note": "xTLTZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2198, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110984796/?format=api", "priority": 100, "id": 112354554, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/112354554/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.620027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used." ], "previous_source": "", "target": [ "" ], "id_hash": 4132487332375574583, "content_hash": 4132487332375574583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8296151\nhelp.text", "note": "yNzcp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/110984833/?format=api", "priority": 100, "id": 112354555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/112354555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.621530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field." ], "previous_source": "", "target": [ "" ], "id_hash": -1497535495358537996, "content_hash": -1497535495358537996, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4809411\nhelp.text", "note": "bmrBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/110984873/?format=api", "priority": 100, "id": 112354556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/112354556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.622958Z" } ] }{ "count": 8439, "next": "