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=43
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=44", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=42", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -8348883544228323497, "content_hash": -8348883544228323497, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155343\nhelp.text", "note": "eFMjk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110981025/?format=api", "priority": 100, "id": 112430408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/112430408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.873008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>OFFSET function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3038312647783775519, "content_hash": -3038312647783775519, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158430\nhelp.text", "note": "JqPAK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981086/?format=api", "priority": 100, "id": 112430409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/112430409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.875247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "OFFSET" ], "previous_source": "", "target": [ "" ], "id_hash": 4884207378341721603, "content_hash": 4884207378341721603, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158430\nhelp.text", "note": "MwiPA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981127/?format=api", "priority": 100, "id": 112430410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/112430410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.876791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -7919841624111631330, "content_hash": -7919841624111631330, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149167\nhelp.text", "note": "tSGCC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110981145/?format=api", "priority": 100, "id": 112430411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/112430411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.878263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "OFFSET(Reference; Rows; Columns [; Height [; Width]])" ], "previous_source": "", "target": [ "" ], "id_hash": -6274711237888482790, "content_hash": -6274711237888482790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159194\nhelp.text", "note": "nED4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110981162/?format=api", "priority": 100, "id": 112430412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=28ebbf5fbd81621a", "url": "https://translations.documentfoundation.org/api/units/112430412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.879523Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Reference</emph> is the reference from which the function searches for the new reference." ], "previous_source": "", "target": [ "" ], "id_hash": -3109094795117095836, "content_hash": -3109094795117095836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152360\nhelp.text", "note": "3Q5gL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110981168/?format=api", "priority": 100, "id": 112430413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/112430413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.881054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row." ], "previous_source": "", "target": [ "" ], "id_hash": -7759693311848095052, "content_hash": -7759693311848095052, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156032\nhelp.text", "note": "Q5SeM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110981169/?format=api", "priority": 100, "id": 112430414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/112430414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.883040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column" ], "previous_source": "", "target": [ "" ], "id_hash": -2855369498407954685, "content_hash": -2855369498407954685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3166458\nhelp.text", "note": "CEqaQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110981207/?format=api", "priority": 100, "id": 112430415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/112430415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.885237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position." ], "previous_source": "", "target": [ "" ], "id_hash": -6370777246515822578, "content_hash": -6370777246515822578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150708\nhelp.text", "note": "K2dos", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981252/?format=api", "priority": 100, "id": 112430416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/112430416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.887158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position." ], "previous_source": "", "target": [ "" ], "id_hash": 6677511436333980503, "content_hash": 6677511436333980503, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147278\nhelp.text", "note": "NEDfS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981270/?format=api", "priority": 100, "id": 112430417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/112430417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.888917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column." ], "previous_source": "", "target": [ "" ], "id_hash": 3258256735597929644, "content_hash": 3258256735597929644, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8662373\nhelp.text", "note": "uQEQG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110981348/?format=api", "priority": 100, "id": 112430418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/112430418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.890648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns." ], "previous_source": "", "target": [ "" ], "id_hash": 4191163419148031225, "content_hash": 4191163419148031225, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9051484\nhelp.text", "note": "cuFvq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981374/?format=api", "priority": 100, "id": 112430419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/112430419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.892350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100." ], "previous_source": "", "target": [ "" ], "id_hash": -2369817467347873031, "content_hash": -2369817467347873031, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149744\nhelp.text", "note": "cUGMh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110981416/?format=api", "priority": 100, "id": 112430420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/112430420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.894089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4)." ], "previous_source": "", "target": [ "" ], "id_hash": -742657699281128448, "content_hash": -742657699281128448, "location": "04060109.xhp", "context": "04060109.xhp\npar_id7439802\nhelp.text", "note": "pZtbS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110981448/?format=api", "priority": 100, "id": 112430421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/112430421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.895557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2)." ], "previous_source": "", "target": [ "" ], "id_hash": 3535053803764573335, "content_hash": 3535053803764573335, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3009430\nhelp.text", "note": "QQGzq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110981463/?format=api", "priority": 100, "id": 112430422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/112430422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.897088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4)." ], "previous_source": "", "target": [ "" ], "id_hash": 5510456478988959992, "content_hash": 5510456478988959992, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2629169\nhelp.text", "note": "ZngJG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110981473/?format=api", "priority": 100, "id": 112430423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/112430423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.898865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5)." ], "previous_source": "", "target": [ "" ], "id_hash": 1923255265426347232, "content_hash": 1923255265426347232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6668599\nhelp.text", "note": "4XD3D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110981488/?format=api", "priority": 100, "id": 112430424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/112430424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.900645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)." ], "previous_source": "", "target": [ "" ], "id_hash": -7553978692711600114, "content_hash": -7553978692711600114, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153739\nhelp.text", "note": "jpz9q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110981511/?format=api", "priority": 100, "id": 112430425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/112430425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.902808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -7194728458143845642, "content_hash": -7194728458143845642, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153740\nhelp.text", "note": "VCAvt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110981542/?format=api", "priority": 100, "id": 112430426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1c2730962cf132f6", "url": "https://translations.documentfoundation.org/api/units/112430426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.904427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>LOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7361603316006066001, "content_hash": 7361603316006066001, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3159273\nhelp.text", "note": "AFMxC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981612/?format=api", "priority": 100, "id": 112430427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/112430427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.906139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981646/?format=api", "priority": 100, "id": 112430428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/112430428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.908274Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> and <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." ], "previous_source": "", "target": [ "" ], "id_hash": 1649568430919950969, "content_hash": 1649568430919950969, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153389\nhelp.text", "note": "WYT2e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/110981689/?format=api", "priority": 100, "id": 112430429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=96e471bf85aea279", "url": "https://translations.documentfoundation.org/api/units/112430429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.909878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110981714/?format=api", "priority": 100, "id": 112430430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/112430430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.911722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "LOOKUP(Lookup; SearchVector [; ResultVector])" ], "previous_source": "", "target": [ "" ], "id_hash": -8386330871162544930, "content_hash": -8386330871162544930, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154104\nhelp.text", "note": "sLcHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110981741/?format=api", "priority": 100, "id": 112430431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0b9dc4815f76dcde", "url": "https://translations.documentfoundation.org/api/units/112430431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.913599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference." ], "previous_source": "", "target": [ "" ], "id_hash": 7237691220109810230, "content_hash": 7237691220109810230, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150646\nhelp.text", "note": "yGLLE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110981783/?format=api", "priority": 100, "id": 112430432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e47171d1589bda36", "url": "https://translations.documentfoundation.org/api/units/112430432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.915278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "" ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110981836/?format=api", "priority": 100, "id": 112430433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/112430433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.916878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "" ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110981862/?format=api", "priority": 100, "id": 112430434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/112430434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.918230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "" ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/110981886/?format=api", "priority": 100, "id": 112430435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/112430435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.919323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981902/?format=api", "priority": 100, "id": 112430436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/112430436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.920354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981915/?format=api", "priority": 100, "id": 112430437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/112430437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.921295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981924/?format=api", "priority": 100, "id": 112430438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/112430438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.922350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])" ], "previous_source": "", "target": [ "" ], "id_hash": -4068678915336599423, "content_hash": -4068678915336599423, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155425\nhelp.text", "note": "V8cAu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110981934/?format=api", "priority": 100, "id": 112430439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=47892615523d8881", "url": "https://translations.documentfoundation.org/api/units/112430439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.923781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." ], "previous_source": "", "target": [ "" ], "id_hash": 2029050507715629929, "content_hash": 2029050507715629929, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144755\nhelp.text", "note": "CNK7e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110981942/?format=api", "priority": 100, "id": 112430440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9c28a2afb7b75369", "url": "https://translations.documentfoundation.org/api/units/112430440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.925129Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values." ], "previous_source": "", "target": [ "" ], "id_hash": 7994380975018243295, "content_hash": 7994380975018243295, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149939\nhelp.text", "note": "GGWDt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110981951/?format=api", "priority": 100, "id": 112430441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eef1bf24071a74df", "url": "https://translations.documentfoundation.org/api/units/112430441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.926214Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "" ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110981962/?format=api", "priority": 100, "id": 112430442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/112430442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.927627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981964/?format=api", "priority": 100, "id": 112430443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/112430443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.929570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982007/?format=api", "priority": 100, "id": 112430444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/112430444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.933598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "" ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110982054/?format=api", "priority": 100, "id": 112430445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/112430445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.936372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -7751377004937243571, "content_hash": -7751377004937243571, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146070\nhelp.text", "note": "NWzFA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110982069/?format=api", "priority": 100, "id": 112430446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=146d93aebc95944d", "url": "https://translations.documentfoundation.org/api/units/112430446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.940507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (columns and rows are exchanged)" ], "previous_source": "", "target": [ "" ], "id_hash": -1478624749447993405, "content_hash": -1478624749447993405, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148672\nhelp.text", "note": "SQxFe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110982099/?format=api", "priority": 100, "id": 112430447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6b7ade9fdd0d27c3", "url": "https://translations.documentfoundation.org/api/units/112430447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.942733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”." ], "previous_source": "", "target": [ "" ], "id_hash": 4634706998389279706, "content_hash": 4634706998389279706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id141612447324913\nhelp.text", "note": "vwqHz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/110982176/?format=api", "priority": 100, "id": 112430448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c051c97595028bda", "url": "https://translations.documentfoundation.org/api/units/112430448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.944530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Element" ], "previous_source": "", "target": [ "" ], "id_hash": 2569298458541281685, "content_hash": 2569298458541281685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id151612978320063\nhelp.text", "note": "eAMVa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982241/?format=api", "priority": 100, "id": 112430449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a3a7fb55d74fd195", "url": "https://translations.documentfoundation.org/api/units/112430449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.946564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Hydrogen" ], "previous_source": "", "target": [ "" ], "id_hash": -2956641131870373628, "content_hash": -2956641131870373628, "location": "04060109.xhp", "context": "04060109.xhp\npar_id711612450364379\nhelp.text", "note": "BcKD5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982294/?format=api", "priority": 100, "id": 112430450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=56f7e68e368eb904", "url": "https://translations.documentfoundation.org/api/units/112430450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.948302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "" ], "id_hash": -3753674292092525244, "content_hash": -3753674292092525244, "location": "04060109.xhp", "context": "04060109.xhp\npar_id681612450364379\nhelp.text", "note": "ACHPj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982339/?format=api", "priority": 100, "id": 112430451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4be8451e814f2544", "url": "https://translations.documentfoundation.org/api/units/112430451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.950002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Lithium" ], "previous_source": "", "target": [ "" ], "id_hash": 6395355888623892843, "content_hash": 6395355888623892843, "location": "04060109.xhp", "context": "04060109.xhp\npar_id531612453345232\nhelp.text", "note": "7YEmL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982506/?format=api", "priority": 100, "id": 112430452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d8c0de4bf1a1396b", "url": "https://translations.documentfoundation.org/api/units/112430452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.951986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Oganesson" ], "previous_source": "", "target": [ "" ], "id_hash": -6406307038623048080, "content_hash": -6406307038623048080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id571612453039430\nhelp.text", "note": "Y3c6z", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982547/?format=api", "priority": 100, "id": 112430453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=271839b0c0c9de70", "url": "https://translations.documentfoundation.org/api/units/112430453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.954342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Symbol" ], "previous_source": "", "target": [ "" ], "id_hash": -2741696328488591392, "content_hash": -2741696328488591392, "location": "04060109.xhp", "context": "04060109.xhp\npar_id341612978329327\nhelp.text", "note": "4H4fa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982607/?format=api", "priority": 100, "id": 112430454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=59f389b72271dfe0", "url": "https://translations.documentfoundation.org/api/units/112430454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.956886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Atomic Number" ], "previous_source": "", "target": [ "" ], "id_hash": 8197228261284471071, "content_hash": 8197228261284471071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id601612978601591\nhelp.text", "note": "jVBoy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110982628/?format=api", "priority": 100, "id": 112430455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f1c267ac40a7611f", "url": "https://translations.documentfoundation.org/api/units/112430455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.959957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Relative Atomic Mass" ], "previous_source": "", "target": [ "" ], "id_hash": -3629097185374679292, "content_hash": -3629097185374679292, "location": "04060109.xhp", "context": "04060109.xhp\npar_id751612978603374\nhelp.text", "note": "WjrrE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110982700/?format=api", "priority": 100, "id": 112430456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4da2db56725f4f04", "url": "https://translations.documentfoundation.org/api/units/112430456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.961833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead." ], "previous_source": "", "target": [ "" ], "id_hash": 6194904089656399110, "content_hash": 6194904089656399110, "location": "04060109.xhp", "context": "04060109.xhp\npar_id51612447346319\nhelp.text", "note": "Cb3HA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110982771/?format=api", "priority": 100, "id": 112430457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d5f8b87291959506", "url": "https://translations.documentfoundation.org/api/units/112430457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:06.963780Z" } ] }