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/iu/units/?format=api&page=44
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=45", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=43", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1f58a334b5624f0e", "url": "https://translations.documentfoundation.org/api/units/112430458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.964990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=40534d9c1c9bb3d5", "url": "https://translations.documentfoundation.org/api/units/112430459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.966757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/112430460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.968298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/112430461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.969668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=557a5bcbbb7048f0", "url": "https://translations.documentfoundation.org/api/units/112430462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.971055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a6ee7a4cdf606994", "url": "https://translations.documentfoundation.org/api/units/112430463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.972358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/112430464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.973600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/112430465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.974989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/112430466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.976650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/112430467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.978383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/112430468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.980465Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/112430469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.982487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/112430470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.984445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/112430471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.986079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/112430472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.987845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/112430473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.989592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/112430474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.991397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/112430475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.992889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/112430476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.994032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/112430477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.995075Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/112430478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.996137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/112430479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.997137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/112430480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.998107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/112430481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.999536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/112430482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.000903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8309f9fb3decc026", "url": "https://translations.documentfoundation.org/api/units/112430483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.001961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/112430484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.003480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0ea4b1ca7e18d2a6", "url": "https://translations.documentfoundation.org/api/units/112430485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.005494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2084a89dde642264", "url": "https://translations.documentfoundation.org/api/units/112430486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.007725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/112430487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.009927Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=23378dbb9d3c7c02", "url": "https://translations.documentfoundation.org/api/units/112430488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.011802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=91b99b192d6bb9d3", "url": "https://translations.documentfoundation.org/api/units/112430489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.013199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=630d3b454b44e2e0", "url": "https://translations.documentfoundation.org/api/units/112430490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.014391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7f5e04c89d7712cf", "url": "https://translations.documentfoundation.org/api/units/112430491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.015390Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a748a27953774505", "url": "https://translations.documentfoundation.org/api/units/112430492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.016366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=99f02ae49c65bd5a", "url": "https://translations.documentfoundation.org/api/units/112430493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.017296Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a77715bd8ddd77ea", "url": "https://translations.documentfoundation.org/api/units/112430494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.018379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=91dcb2afbb1f26c4", "url": "https://translations.documentfoundation.org/api/units/112430495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.019506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/112430496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.020744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/112430497/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.022558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/112430498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.024536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/112430499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.026294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=99191cb47471ad5a", "url": "https://translations.documentfoundation.org/api/units/112430500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.028159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6534098860cc2167", "url": "https://translations.documentfoundation.org/api/units/112430501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.029511Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/112430502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.030602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/112430503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.034550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eec226c365fcc433", "url": "https://translations.documentfoundation.org/api/units/112430504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.036773Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430505, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/112430505/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.039180Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/112430506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.040926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112430507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/112430507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:07.042416Z" } ] }{ "count": 8439, "next": "