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/en_AU/units/?format=api&page=41
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=42", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=40", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>File</emph> is the complete file name, including path specification." ], "previous_source": "", "target": [ "" ], "id_hash": 7315661511110541223, "content_hash": 7315661511110541223, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153034\nhelp.text", "note": "vsezP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110976768/?format=api", "priority": 100, "id": 112108545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e586736262bdbfa7", "url": "https://translations.documentfoundation.org/api/units/112108545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.922469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Range</emph> is the area containing the data to be evaluated." ], "previous_source": "", "target": [ "" ], "id_hash": -8797125138790730943, "content_hash": -8797125138790730943, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147472\nhelp.text", "note": "kU4Vp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110976790/?format=api", "priority": 100, "id": 112108546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=05ea554ba1b83341", "url": "https://translations.documentfoundation.org/api/units/112108546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.923455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Mode</emph> is an optional parameter that controls the method by which the DDE server converts its data into numbers." ], "previous_source": "", "target": [ "" ], "id_hash": 4320051185540375453, "content_hash": 4320051185540375453, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152773\nhelp.text", "note": "9zEYF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110976817/?format=api", "priority": 100, "id": 112108547, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bbf3e7aa25a3a39d", "url": "https://translations.documentfoundation.org/api/units/112108547/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.925195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Mode" ], "previous_source": "", "target": [ "" ], "id_hash": 1366355475372460189, "content_hash": 1366355475372460189, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154383\nhelp.text", "note": "kTM5K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976862/?format=api", "priority": 100, "id": 112108548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=92f64510ca7c489d", "url": "https://translations.documentfoundation.org/api/units/112108548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.927228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "" ], "id_hash": 1778018240787986991, "content_hash": 1778018240787986991, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145146\nhelp.text", "note": "hAUG9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976888/?format=api", "priority": 100, "id": 112108550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=98acca2b6e553a2f", "url": "https://translations.documentfoundation.org/api/units/112108550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.929542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "0 or missing" ], "previous_source": "", "target": [ "" ], "id_hash": -2450793688976304581, "content_hash": -2450793688976304581, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154558\nhelp.text", "note": "GLZVP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110976918/?format=api", "priority": 100, "id": 112108551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5dfd081feecc563b", "url": "https://translations.documentfoundation.org/api/units/112108551/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.931706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Number format from the \"Default\" cell style" ], "previous_source": "", "target": [ "" ], "id_hash": 2506316584798282112, "content_hash": 2506316584798282112, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145596\nhelp.text", "note": "qgE6C", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110976929/?format=api", "priority": 100, "id": 112108552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a2c839a7a3926180", "url": "https://translations.documentfoundation.org/api/units/112108552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.933724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Data are always interpreted in the standard format for US English" ], "previous_source": "", "target": [ "" ], "id_hash": -6041178584146709210, "content_hash": -6041178584146709210, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154380\nhelp.text", "note": "547CV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2008, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110976965/?format=api", "priority": 100, "id": 112108554, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2c296c15d33cf526", "url": "https://translations.documentfoundation.org/api/units/112108554/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.935938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Data are retrieved as text; no conversion to numbers" ], "previous_source": "", "target": [ "" ], "id_hash": -426597428070967290, "content_hash": -426597428070967290, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153775\nhelp.text", "note": "PEbpW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2009, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110976983/?format=api", "priority": 100, "id": 112108556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7a146be63dbc1806", "url": "https://translations.documentfoundation.org/api/units/112108556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.937696Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\data1.ods\";\"sheet1.A1\")</item> reads the contents of cell A1 in sheet1 of the <item type=\"productname\">%PRODUCTNAME</item> Calc spreadsheet data1.ods." ], "previous_source": "", "target": [ "" ], "id_hash": 4335012515870683916, "content_hash": 4335012515870683916, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148734\nhelp.text", "note": "Ae8L2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2010, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110977021/?format=api", "priority": 100, "id": 112108557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bc290eea5158330c", "url": "https://translations.documentfoundation.org/api/units/112108557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.939211Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\motto.odt\";\"Today's motto\")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.odt document containing the motto text and define it as the first line of a section named <item type=\"literal\">Today's Motto</item> (in <item type=\"productname\">%PRODUCTNAME</item> Writer under <emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type=\"productname\">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type=\"productname\">%PRODUCTNAME</item> Calc cells in which this DDE link is defined." ], "previous_source": "", "target": [ "" ], "id_hash": -3384527376398056909, "content_hash": -3384527376398056909, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153081\nhelp.text", "note": "96FU5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2011, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/110977046/?format=api", "priority": 100, "id": 112108559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5107be487d358233", "url": "https://translations.documentfoundation.org/api/units/112108559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.940440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>ERRORTYPE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1918345880442002828, "content_hash": 1918345880442002828, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153114\nhelp.text", "note": "DmwaH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2012, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110977102/?format=api", "priority": 100, "id": 112108560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=9a9f556a18145d8c", "url": "https://translations.documentfoundation.org/api/units/112108560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.941950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "ERRORTYPE" ], "previous_source": "", "target": [ "" ], "id_hash": 6126491897215722938, "content_hash": 6126491897215722938, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153114\nhelp.text", "note": "Lp8zY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2013, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110977141/?format=api", "priority": 100, "id": 112108561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d505abebc4da25ba", "url": "https://translations.documentfoundation.org/api/units/112108561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.943054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Returns the number corresponding to an <link href=\"text/scalc/05/02140000.xhp\">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text." ], "previous_source": "", "target": [ "" ], "id_hash": -5680160780120138924, "content_hash": -5680160780120138924, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148568\nhelp.text", "note": "hEDCC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2014, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110977181/?format=api", "priority": 100, "id": 112108562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=312c03dd81d55b54", "url": "https://translations.documentfoundation.org/api/units/112108562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.944198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The Status Bar displays the predefined error code from <item type=\"productname\">%PRODUCTNAME</item> if you click the cell containing the error." ], "previous_source": "", "target": [ "" ], "id_hash": -1829222880947143955, "content_hash": -1829222880947143955, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149877\nhelp.text", "note": "G7W2S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2015, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110977205/?format=api", "priority": 100, "id": 112108563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=669d4b7b3e20faed", "url": "https://translations.documentfoundation.org/api/units/112108563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.945343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "ERRORTYPE(Reference)" ], "previous_source": "", "target": [ "" ], "id_hash": -6713984224407071925, "content_hash": -6713984224407071925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151322\nhelp.text", "note": "KKLCk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2016, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110977220/?format=api", "priority": 100, "id": 112108565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=22d322eb8ca3d34b", "url": "https://translations.documentfoundation.org/api/units/112108565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.946490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Reference</emph> contains the address of the cell in which the error occurs." ], "previous_source": "", "target": [ "" ], "id_hash": -6554719520712774592, "content_hash": -6554719520712774592, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150132\nhelp.text", "note": "DkKtR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2017, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110977255/?format=api", "priority": 100, "id": 112108566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2508f5530598ac40", "url": "https://translations.documentfoundation.org/api/units/112108566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.947551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." ], "previous_source": "", "target": [ "" ], "id_hash": 1941990232443135341, "content_hash": 1941990232443135341, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146904\nhelp.text", "note": "QgTxS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2018, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110977289/?format=api", "priority": 100, "id": 112108567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=9af355d3ca0d256d", "url": "https://translations.documentfoundation.org/api/units/112108567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.948590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>INDEX function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3510616849146248191, "content_hash": -3510616849146248191, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151221\nhelp.text", "note": "mtLKD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2019, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110977309/?format=api", "priority": 100, "id": 112108568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4f47c89364230401", "url": "https://translations.documentfoundation.org/api/units/112108568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.949875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "INDEX" ], "previous_source": "", "target": [ "" ], "id_hash": -6205565825555549533, "content_hash": -6205565825555549533, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151221\nhelp.text", "note": "8DKwz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2020, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110978149/?format=api", "priority": 100, "id": 112108569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=29e166c2997532a3", "url": "https://translations.documentfoundation.org/api/units/112108569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.951997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a reference, a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -8397598796967873698, "content_hash": -8397598796967873698, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150268\nhelp.text", "note": "TgAJs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2021, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110978166/?format=api", "priority": 100, "id": 112108571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0b75bc62f47b735e", "url": "https://translations.documentfoundation.org/api/units/112108571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.953736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "INDEX() returns a reference if the argument is one or more references. When used in a cell in the form =INDEX(), the reference is resolved and the values displayed. When INDEX() is used in arguments of other functions, =FUNCTION(INDEX()...), the function gets the reference passed that was returned by INDEX(). Returning a reference is different from returning an array of values for functions that handles them differently." ], "previous_source": "", "target": [ "" ], "id_hash": -6873999040353118520, "content_hash": -6873999040353118520, "location": "04060109.xhp", "context": "04060109.xhp\npar_id901682701069280\nhelp.text", "note": "GwG9e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2022, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110978222/?format=api", "priority": 100, "id": 112108572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=209aa64af56056c8", "url": "https://translations.documentfoundation.org/api/units/112108572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.954868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "INDEX(Reference [; [Row] [; [Column] [; Range]]])" ], "previous_source": "", "target": [ "" ], "id_hash": 3329173742403328129, "content_hash": 3329173742403328129, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149007\nhelp.text", "note": "dr8Bi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2023, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110978247/?format=api", "priority": 100, "id": 112108573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ae3399e147821881", "url": "https://translations.documentfoundation.org/api/units/112108573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.956263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or either use the tilde (~) <link href=\"text/scalc/01/04060199.xhp#referenceoperators\">range concatenation operator</link> or define a named range with multiple areas." ], "previous_source": "", "target": [ "" ], "id_hash": 4763170941283659549, "content_hash": 4763170941283659549, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153260\nhelp.text", "note": "AMnwW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2024, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110978271/?format=api", "priority": 100, "id": 112108575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c21a2ebc17acef1d", "url": "https://translations.documentfoundation.org/api/units/112108575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.957587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Row</emph> (optional) represents the row or the array of row indexes of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned." ], "previous_source": "", "target": [ "" ], "id_hash": 8690371446690704261, "content_hash": 8690371446690704261, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145302\nhelp.text", "note": "MKdnE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2025, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110978303/?format=api", "priority": 100, "id": 112108576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f89a66c986326b85", "url": "https://translations.documentfoundation.org/api/units/112108576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.958878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Column</emph> (optional) represents the column or array of column indexes of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned." ], "previous_source": "", "target": [ "" ], "id_hash": 3245157780478865290, "content_hash": 3245157780478865290, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154628\nhelp.text", "note": "usFXV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2026, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110978333/?format=api", "priority": 100, "id": 112108577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ad091dcec989af8a", "url": "https://translations.documentfoundation.org/api/units/112108577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.960250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If <emph>Row</emph>, <emph>Column</emph> or both are omitted or defined as arrays of indexes, the INDEX function must be entered as an <link href=\"text/scalc/01/04060107.xhp\">array function</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 8042928239876025018, "content_hash": 8042928239876025018, "location": "04060109.xhp", "context": "04060109.xhp\npar_id621679327293280\nhelp.text", "note": "FBj7m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2027, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110978353/?format=api", "priority": 100, "id": 112108578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ef9e389ef3c4aaba", "url": "https://translations.documentfoundation.org/api/units/112108578/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.961716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default is 1." ], "previous_source": "", "target": [ "" ], "id_hash": -8124523639308866552, "content_hash": -8124523639308866552, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155514\nhelp.text", "note": "BmioJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2028, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110978404/?format=api", "priority": 100, "id": 112108579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0f3fe4cbadbb2c08", "url": "https://translations.documentfoundation.org/api/units/112108579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.963490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>{=INDEX({1,3,5;7,9,10},{2;1},1)}</input> return a 2 row array containing 7 and 1. The row index {2;1} pick row 2 then row 1. The columns index 1 picks the first column." ], "previous_source": "", "target": [ "" ], "id_hash": -2732052766968460686, "content_hash": -2732052766968460686, "location": "04060109.xhp", "context": "04060109.xhp\npar_id541679331443608\nhelp.text", "note": "BMeAR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2029, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110978423/?format=api", "priority": 100, "id": 112108581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5a15cc7bc538ca72", "url": "https://translations.documentfoundation.org/api/units/112108581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.965431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>{=INDEX(D3:G12,{1;2;3;4},{3,1})}</input> return a 4 rows by 2 columns array. The row index array {1;2;3;4} picks rows 3 to 6 and {3;1} picks the third (F) and first column (D). Columns 1 and 3 of the source reference are swapped in the resulting array." ], "previous_source": "", "target": [ "" ], "id_hash": 2561781032724062582, "content_hash": 2561781032724062582, "location": "04060109.xhp", "context": "04060109.xhp\npar_id511679333116273\nhelp.text", "note": "RGnNr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2030, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110978452/?format=api", "priority": 100, "id": 112108582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a38d4646bfd9e176", "url": "https://translations.documentfoundation.org/api/units/112108582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.966860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 8631622783403805933, "content_hash": 8631622783403805933, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159112\nhelp.text", "note": "7pFH2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110978481/?format=api", "priority": 100, "id": 112108583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f7c9af306ff3cced", "url": "https://translations.documentfoundation.org/api/units/112108583/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.968051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -3275555322380811905, "content_hash": -3275555322380811905, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150691\nhelp.text", "note": "UFxmm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110978504/?format=api", "priority": 100, "id": 112108584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=528ae3c9f75a017f", "url": "https://translations.documentfoundation.org/api/units/112108584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.969019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>{=INDEX(A1:B6;1)}</input> returns the values of the first row of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 3373830903152245766, "content_hash": 3373830903152245766, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4109012\nhelp.text", "note": "mfFAA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2033, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110978596/?format=api", "priority": 100, "id": 112108585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=aed24154c29ffc06", "url": "https://translations.documentfoundation.org/api/units/112108585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.969966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>{=INDEX(A1:B6;0;1)}</input> returns the values of the first column of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 5763011134459683020, "content_hash": 5763011134459683020, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9272133\nhelp.text", "note": "jLKKJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2034, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110978621/?format=api", "priority": 100, "id": 112108586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cffa5417d21720cc", "url": "https://translations.documentfoundation.org/api/units/112108586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.970956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range." ], "previous_source": "", "target": [ "" ], "id_hash": -4579606228710604787, "content_hash": -4579606228710604787, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148595\nhelp.text", "note": "igC59", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2035, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110978630/?format=api", "priority": 100, "id": 112108587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4071f8661689c00d", "url": "https://translations.documentfoundation.org/api/units/112108587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.972207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>{=INDEX((A1:B6;C1:D6);0;0;2)}</input> returns the values of the second range C1:D6 of the multiple range. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -2227884281875185104, "content_hash": -2227884281875185104, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9960020\nhelp.text", "note": "GQjbB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110978643/?format=api", "priority": 100, "id": 112108588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6114f70caa274230", "url": "https://translations.documentfoundation.org/api/units/112108588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.974051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX\">INDEX wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -3088447245330367753, "content_hash": -3088447245330367753, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751508\nhelp.text", "note": "HSbEt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2037, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110978663/?format=api", "priority": 100, "id": 112108590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5523a197fa8cbaf7", "url": "https://translations.documentfoundation.org/api/units/112108590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.976349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>INDIRECT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1128844034642182997, "content_hash": -1128844034642182997, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153181\nhelp.text", "note": "LCBWC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110978722/?format=api", "priority": 100, "id": 112108592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=70558a54d4557cab", "url": "https://translations.documentfoundation.org/api/units/112108592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.978355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "INDIRECT" ], "previous_source": "", "target": [ "" ], "id_hash": 6065144281656826621, "content_hash": 6065144281656826621, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153181\nhelp.text", "note": "VXKFM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2039, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110978768/?format=api", "priority": 100, "id": 112108593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d42bb896f3a59afd", "url": "https://translations.documentfoundation.org/api/units/112108593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.979856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_INDIREKT\">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string." ], "previous_source": "", "target": [ "" ], "id_hash": -5986397852430006106, "content_hash": -5986397852430006106, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147169\nhelp.text", "note": "5Pxmv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2040, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110978805/?format=api", "priority": 100, "id": 112108594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2cec0aded9bf88a6", "url": "https://translations.documentfoundation.org/api/units/112108594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.981635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "INDIRECT(Ref [; A1])" ], "previous_source": "", "target": [ "" ], "id_hash": 2695684104847913136, "content_hash": 2695684104847913136, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149824\nhelp.text", "note": "hDCWQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2041, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110978867/?format=api", "priority": 100, "id": 112108596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a568fe69382070b0", "url": "https://translations.documentfoundation.org/api/units/112108596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.983343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents." ], "previous_source": "", "target": [ "" ], "id_hash": 8146128659930204794, "content_hash": 8146128659930204794, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154317\nhelp.text", "note": "cZG9F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2042, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110978885/?format=api", "priority": 100, "id": 112108598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f10cdcdb2dc4ca7a", "url": "https://translations.documentfoundation.org/api/units/112108598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.984893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used." ], "previous_source": "", "target": [ "" ], "id_hash": 7809132219533021688, "content_hash": 7809132219533021688, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802470312\nhelp.text", "note": "6xBcm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2043, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110978910/?format=api", "priority": 100, "id": 112108600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ec5f9c610d52d1f8", "url": "https://translations.documentfoundation.org/api/units/112108600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.986166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT(\"[filename]sheetname!\"&B1) is not converted into the Calc address in INDIRECT(\"filename#sheetname.\"&B1)." ], "previous_source": "", "target": [ "" ], "id_hash": -9025562161285509845, "content_hash": -9025562161285509845, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN10CAE\nhelp.text", "note": "5adA4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2044, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110978946/?format=api", "priority": 100, "id": 112108602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=02bec308a65ecd2b", "url": "https://translations.documentfoundation.org/api/units/112108602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.987460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference and cell C108 contains a value of <item type=\"input\">100</item>." ], "previous_source": "", "target": [ "" ], "id_hash": 3099673932217486913, "content_hash": 3099673932217486913, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150608\nhelp.text", "note": "mJRg8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2045, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110978978/?format=api", "priority": 100, "id": 112108604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ab044104c15c8e41", "url": "https://translations.documentfoundation.org/api/units/112108604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.989192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> totals the cells in the area of A1 up to the cell with the address defined by row 1 and column 3. This means that area A1:C1 is totaled." ], "previous_source": "", "target": [ "" ], "id_hash": -1748132909726659601, "content_hash": -1748132909726659601, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3083286\nhelp.text", "note": "UbprA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110979014/?format=api", "priority": 100, "id": 112108605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=67bd62616f928bef", "url": "https://translations.documentfoundation.org/api/units/112108605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.991096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>COLUMN function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -862982028918071288, "content_hash": -862982028918071288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154818\nhelp.text", "note": "T2BJo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110979063/?format=api", "priority": 100, "id": 112108606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7406126abecae008", "url": "https://translations.documentfoundation.org/api/units/112108606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.993027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "COLUMN" ], "previous_source": "", "target": [ "" ], "id_hash": 2443648171927541574, "content_hash": 2443648171927541574, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154818\nhelp.text", "note": "sHB7C", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2048, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979115/?format=api", "priority": 100, "id": 112108608, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a1e99510bbc61746", "url": "https://translations.documentfoundation.org/api/units/112108608/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.994468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <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 COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." ], "previous_source": "", "target": [ "" ], "id_hash": 2955182560504194790, "content_hash": 2955182560504194790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149711\nhelp.text", "note": "Kj3xA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2049, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/110979151/?format=api", "priority": 100, "id": 112108610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a902eae1ad4826e6", "url": "https://translations.documentfoundation.org/api/units/112108610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.995968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "COLUMN([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": -3401701009952994570, "content_hash": -3401701009952994570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149447\nhelp.text", "note": "poCRX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979228/?format=api", "priority": 100, "id": 112108611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=50cabaf455aa0af6", "url": "https://translations.documentfoundation.org/api/units/112108611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.997305Z" } ] }