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=40
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=41", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=39", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Statistics Functions" ], "previous_source": "", "target": [ "" ], "id_hash": -5897051907943278782, "content_hash": -5897051907943278782, "location": "04060108.xhp", "context": "04060108.xhp\ntit\nhelp.text", "note": "p4YTh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974474/?format=api", "priority": 100, "id": 112108462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2e2976889d005742", "url": "https://translations.documentfoundation.org/api/units/112108462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.840305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>statistics functions</bookmark_value><bookmark_value>Function Wizard; statistics</bookmark_value><bookmark_value>functions; statistics functions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 5755265143273233381, "content_hash": 5755265143273233381, "location": "04060108.xhp", "context": "04060108.xhp\nbm_id3153018\nhelp.text", "note": "xJyMy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110974508/?format=api", "priority": 100, "id": 112108463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cfdecf27b4fd1be5", "url": "https://translations.documentfoundation.org/api/units/112108463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.842163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Statistics Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -3653679829312444946, "content_hash": -3653679829312444946, "location": "04060108.xhp", "context": "04060108.xhp\nhd_id3153018\nhelp.text", "note": "EcgjZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110974546/?format=api", "priority": 100, "id": 112108464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4d4b858da2d265ee", "url": "https://translations.documentfoundation.org/api/units/112108464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.843519Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<variable id=\"statistiktext\">This category contains the <emph>Statistics</emph> functions.</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5309534091528974620, "content_hash": -5309534091528974620, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3157874\nhelp.text", "note": "M7Z6D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110974599/?format=api", "priority": 100, "id": 112108465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3650bedff796cee4", "url": "https://translations.documentfoundation.org/api/units/112108465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.844839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Some of the examples use the following data table:" ], "previous_source": "", "target": [ "" ], "id_hash": 3110882082655944344, "content_hash": 3110882082655944344, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3149001\nhelp.text", "note": "HiTED", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110974650/?format=api", "priority": 100, "id": 112108468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ab2c12c5a2d5be98", "url": "https://translations.documentfoundation.org/api/units/112108468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.847877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "x value" ], "previous_source": "", "target": [ "" ], "id_hash": 267449268429799975, "content_hash": 267449268429799975, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3153551\nhelp.text", "note": "PeXDp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974681/?format=api", "priority": 100, "id": 112108470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=83b62bb150324227", "url": "https://translations.documentfoundation.org/api/units/112108470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.853645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "y value" ], "previous_source": "", "target": [ "" ], "id_hash": -3967827592908545360, "content_hash": -3967827592908545360, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3147536\nhelp.text", "note": "b9ACz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974709/?format=api", "priority": 100, "id": 112108472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=48ef71d3a2b162b0", "url": "https://translations.documentfoundation.org/api/units/112108472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.855952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The statistical functions are described in the following subsections." ], "previous_source": "", "target": [ "" ], "id_hash": 7708999778292664413, "content_hash": 7708999778292664413, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3156324\nhelp.text", "note": "BbE8F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110974741/?format=api", "priority": 100, "id": 112108474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=eafbde744eb3085d", "url": "https://translations.documentfoundation.org/api/units/112108474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.857898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "" ], "id_hash": -2966132965479816684, "content_hash": -2966132965479816684, "location": "04060109.xhp", "context": "04060109.xhp\ntit\nhelp.text", "note": "gREzE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974784/?format=api", "priority": 100, "id": 112108475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=56d62dc87bffe214", "url": "https://translations.documentfoundation.org/api/units/112108475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.859372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>spreadsheets; functions</bookmark_value> <bookmark_value>Function Wizard; spreadsheets</bookmark_value> <bookmark_value>functions; spreadsheets</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2889756523113244871, "content_hash": -2889756523113244871, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148522\nhelp.text", "note": "WoHfE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110974812/?format=api", "priority": 100, "id": 112108477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=57e585c0b8779739", "url": "https://translations.documentfoundation.org/api/units/112108477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.860935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "" ], "id_hash": 7024016505950538733, "content_hash": 7024016505950538733, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148522\nhelp.text", "note": "qcCTY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974856/?format=api", "priority": 100, "id": 112108479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e17a51cc1da98bed", "url": "https://translations.documentfoundation.org/api/units/112108479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.862374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<variable id=\"tabelletext\">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example.</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2783587935049714885, "content_hash": 2783587935049714885, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144508\nhelp.text", "note": "BceQk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110974880/?format=api", "priority": 100, "id": 112108480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a6a14a7a95b38cc5", "url": "https://translations.documentfoundation.org/api/units/112108480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.863737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>ADDRESS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4598909094892086070, "content_hash": -4598909094892086070, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3146968\nhelp.text", "note": "aoGD9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974915/?format=api", "priority": 100, "id": 112108482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=402d648b54a4dcca", "url": "https://translations.documentfoundation.org/api/units/112108482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.865437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "ADDRESS" ], "previous_source": "", "target": [ "" ], "id_hash": 2684530464677923973, "content_hash": 2684530464677923973, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3146968\nhelp.text", "note": "YWzqF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110974962/?format=api", "priority": 100, "id": 112108483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a5415e3bffd78c85", "url": "https://translations.documentfoundation.org/api/units/112108483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.867241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ADRESSE\">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet." ], "previous_source": "", "target": [ "" ], "id_hash": -6346032754747434559, "content_hash": -6346032754747434559, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155762\nhelp.text", "note": "EDZCM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110974979/?format=api", "priority": 100, "id": 112108485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=27ee5cd5104919c1", "url": "https://translations.documentfoundation.org/api/units/112108485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.868653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used." ], "previous_source": "", "target": [ "" ], "id_hash": 6500763140005585231, "content_hash": 6500763140005585231, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301348\nhelp.text", "note": "hrEcs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110975004/?format=api", "priority": 100, "id": 112108487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=da3759a220fc614f", "url": "https://translations.documentfoundation.org/api/units/112108487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.870178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position." ], "previous_source": "", "target": [ "" ], "id_hash": -911371874454514455, "content_hash": -911371874454514455, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301445\nhelp.text", "note": "JJpSk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110975033/?format=api", "priority": 100, "id": 112108489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=735a281bdcdb54e9", "url": "https://translations.documentfoundation.org/api/units/112108489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.873407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "In INDIRECT, the parameter is appended as the second parameter." ], "previous_source": "", "target": [ "" ], "id_hash": -4950075489879108756, "content_hash": -4950075489879108756, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230153\nhelp.text", "note": "qFesv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110975059/?format=api", "priority": 100, "id": 112108490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3b4dcc918e63536c", "url": "https://translations.documentfoundation.org/api/units/112108490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.875000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used." ], "previous_source": "", "target": [ "" ], "id_hash": -2075736064795905404, "content_hash": -2075736064795905404, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230151\nhelp.text", "note": "gvGjb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110975079/?format=api", "priority": 100, "id": 112108492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6331810bfa5f7284", "url": "https://translations.documentfoundation.org/api/units/112108492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.877177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation." ], "previous_source": "", "target": [ "" ], "id_hash": 1709027029175537816, "content_hash": 1709027029175537816, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301556\nhelp.text", "note": "S5Du7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/110975105/?format=api", "priority": 100, "id": 112108493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=97b7af07398c9098", "url": "https://translations.documentfoundation.org/api/units/112108493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.879321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted." ], "previous_source": "", "target": [ "" ], "id_hash": -1059518466302375336, "content_hash": -1059518466302375336, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301521\nhelp.text", "note": "tBvLY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110975132/?format=api", "priority": 100, "id": 112108495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=714bd59187148a58", "url": "https://translations.documentfoundation.org/api/units/112108495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.881211Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed." ], "previous_source": "", "target": [ "" ], "id_hash": -8055874548874886449, "content_hash": -8055874548874886449, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301650\nhelp.text", "note": "NGGAw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110975154/?format=api", "priority": 100, "id": 112108496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1033c8c79733c2cf", "url": "https://translations.documentfoundation.org/api/units/112108496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.882683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0." ], "previous_source": "", "target": [ "" ], "id_hash": 8115260084259178319, "content_hash": 8115260084259178319, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230162\nhelp.text", "note": "Ag8KD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110975178/?format=api", "priority": 100, "id": 112108498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f09f320cd62cc74f", "url": "https://translations.documentfoundation.org/api/units/112108498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.884418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function." ], "previous_source": "", "target": [ "" ], "id_hash": 3590831610914499776, "content_hash": 3590831610914499776, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301756\nhelp.text", "note": "d2kpf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110975212/?format=api", "priority": 100, "id": 112108501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b1d5325338cd6cc0", "url": "https://translations.documentfoundation.org/api/units/112108501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.886391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])" ], "previous_source": "", "target": [ "" ], "id_hash": 987991828813510454, "content_hash": 987991828813510454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154707\nhelp.text", "note": "TgFFT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110975710/?format=api", "priority": 100, "id": 112108504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=8db60d556d6af736", "url": "https://translations.documentfoundation.org/api/units/112108504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.888514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Row</emph> represents the row number for the cell reference" ], "previous_source": "", "target": [ "" ], "id_hash": 5088181695370283547, "content_hash": 5088181695370283547, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147505\nhelp.text", "note": "FyoLc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110975749/?format=api", "priority": 100, "id": 112108508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c69cda4b2930ca1b", "url": "https://translations.documentfoundation.org/api/units/112108508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.890896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Column</emph> represents the column number for the cell reference (the number, not the letter)" ], "previous_source": "", "target": [ "" ], "id_hash": -6237596525700379609, "content_hash": -6237596525700379609, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145323\nhelp.text", "note": "AEorU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110975788/?format=api", "priority": 100, "id": 112108511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=296f9b02116b0c27", "url": "https://translations.documentfoundation.org/api/units/112108511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.893399Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Abs</emph> determines the type of reference:" ], "previous_source": "", "target": [ "" ], "id_hash": 8889697732632519959, "content_hash": 8889697732632519959, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153074\nhelp.text", "note": "8VYFW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110975832/?format=api", "priority": 100, "id": 112108513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fb5e8cfcfa282517", "url": "https://translations.documentfoundation.org/api/units/112108513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.895468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "1: absolute ($A$1)" ], "previous_source": "", "target": [ "" ], "id_hash": 4950740850650695570, "content_hash": 4950740850650695570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153298\nhelp.text", "note": "EEfQf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110975881/?format=api", "priority": 100, "id": 112108515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c4b49092d20cc792", "url": "https://translations.documentfoundation.org/api/units/112108515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.896950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "2: row reference type is absolute; column reference is relative (A$1)" ], "previous_source": "", "target": [ "" ], "id_hash": -8926242809178159723, "content_hash": -8926242809178159723, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150431\nhelp.text", "note": "jNcJG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110975882/?format=api", "priority": 100, "id": 112108517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=041f9d75540d0595", "url": "https://translations.documentfoundation.org/api/units/112108517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.898839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "3: row (relative); column (absolute) ($A1)" ], "previous_source": "", "target": [ "" ], "id_hash": 9140721639584882894, "content_hash": 9140721639584882894, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146096\nhelp.text", "note": "KXVHa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110975883/?format=api", "priority": 100, "id": 112108518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=feda5de6ce2ee0ce", "url": "https://translations.documentfoundation.org/api/units/112108518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.900287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "4: relative (A1)" ], "previous_source": "", "target": [ "" ], "id_hash": -8521629544004173645, "content_hash": -8521629544004173645, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153334\nhelp.text", "note": "AeGMD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110975936/?format=api", "priority": 100, "id": 112108520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=09bd17144a2840b3", "url": "https://translations.documentfoundation.org/api/units/112108520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.901372Z" }, { "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": -7379494026329237918, "content_hash": -7379494026329237918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802465915\nhelp.text", "note": "3BFnh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110975977/?format=api", "priority": 100, "id": 112108522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1996c54802875662", "url": "https://translations.documentfoundation.org/api/units/112108522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.902640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes." ], "previous_source": "", "target": [ "" ], "id_hash": -8090009019137561493, "content_hash": -8090009019137561493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153962\nhelp.text", "note": "R2QXf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110976059/?format=api", "priority": 100, "id": 112108523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0fba83a8e8996c6b", "url": "https://translations.documentfoundation.org/api/units/112108523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.903871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "" ], "id_hash": 6158664688613790099, "content_hash": 6158664688613790099, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147299\nhelp.text", "note": "3eSyo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976065/?format=api", "priority": 100, "id": 112108525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d577f8e77f911193", "url": "https://translations.documentfoundation.org/api/units/112108525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.905037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=ADDRESS(1;1;2;;\"Sheet2\")</item> returns the following: Sheet2.A$1" ], "previous_source": "", "target": [ "" ], "id_hash": 8915481783737849529, "content_hash": 8915481783737849529, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148744\nhelp.text", "note": "oCjxy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110976091/?format=api", "priority": 100, "id": 112108527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fbba2772312916b9", "url": "https://translations.documentfoundation.org/api/units/112108527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.906332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." ], "previous_source": "", "target": [ "" ], "id_hash": -6990483334965291855, "content_hash": -6990483334965291855, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159260\nhelp.text", "note": "zEj2o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110976146/?format=api", "priority": 100, "id": 112108529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1efcd071ab1b14b1", "url": "https://translations.documentfoundation.org/api/units/112108529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.907642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>AREAS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7072070132031450786, "content_hash": 7072070132031450786, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150372\nhelp.text", "note": "n7RGj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110976236/?format=api", "priority": 100, "id": 112108531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e2250a50ce626ea2", "url": "https://translations.documentfoundation.org/api/units/112108531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.908997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "AREAS" ], "previous_source": "", "target": [ "" ], "id_hash": -2873436012796235041, "content_hash": -2873436012796235041, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150372\nhelp.text", "note": "BmNK5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976263/?format=api", "priority": 100, "id": 112108532, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=581f812ba47732df", "url": "https://translations.documentfoundation.org/api/units/112108532/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.910306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_BEREICHE\">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell." ], "previous_source": "", "target": [ "" ], "id_hash": -2296054605787946059, "content_hash": -2296054605787946059, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150036\nhelp.text", "note": "Bi6yp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110976314/?format=api", "priority": 100, "id": 112108534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6022c680451c23b5", "url": "https://translations.documentfoundation.org/api/units/112108534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.911362Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges." ], "previous_source": "", "target": [ "" ], "id_hash": 8788259985831439169, "content_hash": 8788259985831439169, "location": "04060109.xhp", "context": "04060109.xhp\npar_id061020090307073\nhelp.text", "note": "cvDFN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/110976366/?format=api", "priority": 100, "id": 112108535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f9f62be519432b41", "url": "https://translations.documentfoundation.org/api/units/112108535/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.912419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "AREAS(Reference)" ], "previous_source": "", "target": [ "" ], "id_hash": -4011799632394081583, "content_hash": -4011799632394081583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155907\nhelp.text", "note": "Tg8WA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976401/?format=api", "priority": 100, "id": 112108536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4853397d611baad1", "url": "https://translations.documentfoundation.org/api/units/112108536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.913474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Reference represents the reference to a cell or cell range." ], "previous_source": "", "target": [ "" ], "id_hash": -8385337005647716684, "content_hash": -8385337005647716684, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153118\nhelp.text", "note": "fJLtE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110976416/?format=api", "priority": 100, "id": 112108537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0ba14c6bb86e1eb4", "url": "https://translations.documentfoundation.org/api/units/112108537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.914440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1))." ], "previous_source": "", "target": [ "" ], "id_hash": -1615880179506973561, "content_hash": -1615880179506973561, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149946\nhelp.text", "note": "K5zS8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110976435/?format=api", "priority": 100, "id": 112108538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=69933d89bce47487", "url": "https://translations.documentfoundation.org/api/units/112108538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.915444Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 1472854209275403689, "content_hash": 1472854209275403689, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146820\nhelp.text", "note": "sh5wD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110976510/?format=api", "priority": 100, "id": 112108539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=9470a1198dcc9da9", "url": "https://translations.documentfoundation.org/api/units/112108539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.916433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>DDE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7941482527970087483, "content_hash": 7941482527970087483, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148727\nhelp.text", "note": "mUP2a", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110976609/?format=api", "priority": 100, "id": 112108540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ee35d0488da0d23b", "url": "https://translations.documentfoundation.org/api/units/112108540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.917396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "DDE" ], "previous_source": "", "target": [ "" ], "id_hash": -6084178397908938716, "content_hash": -6084178397908938716, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148727\nhelp.text", "note": "AMXUq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976651/?format=api", "priority": 100, "id": 112108541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/112108541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.918395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed." ], "previous_source": "", "target": [ "" ], "id_hash": -3672875923859036273, "content_hash": -3672875923859036273, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149434\nhelp.text", "note": "2FAG7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/110976679/?format=api", "priority": 100, "id": 112108542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/112108542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.919388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" ], "previous_source": "", "target": [ "" ], "id_hash": 6958039810471576071, "content_hash": 6958039810471576071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148886\nhelp.text", "note": "JBRdm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110976716/?format=api", "priority": 100, "id": 112108543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e08fec57a42f4207", "url": "https://translations.documentfoundation.org/api/units/112108543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.920516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\"." ], "previous_source": "", "target": [ "" ], "id_hash": -5937338882859885522, "content_hash": -5937338882859885522, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154842\nhelp.text", "note": "qAN6x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110976744/?format=api", "priority": 100, "id": 112108544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/112108544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.921496Z" } ] }{ "count": 8439, "next": "