Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=40
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=41", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=39", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2e2976889d005742", "url": "https://translations.documentfoundation.org/api/units/112354307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.249857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cfdecf27b4fd1be5", "url": "https://translations.documentfoundation.org/api/units/112354308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.251319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4d4b858da2d265ee", "url": "https://translations.documentfoundation.org/api/units/112354309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.252753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3650bedff796cee4", "url": "https://translations.documentfoundation.org/api/units/112354310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.254182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ab2c12c5a2d5be98", "url": "https://translations.documentfoundation.org/api/units/112354311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.255543Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=83b62bb150324227", "url": "https://translations.documentfoundation.org/api/units/112354312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.257058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=48ef71d3a2b162b0", "url": "https://translations.documentfoundation.org/api/units/112354313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.258743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eafbde744eb3085d", "url": "https://translations.documentfoundation.org/api/units/112354314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.260987Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=56d62dc87bffe214", "url": "https://translations.documentfoundation.org/api/units/112354315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.262663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=57e585c0b8779739", "url": "https://translations.documentfoundation.org/api/units/112354316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.264512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e17a51cc1da98bed", "url": "https://translations.documentfoundation.org/api/units/112354317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.266246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a6a14a7a95b38cc5", "url": "https://translations.documentfoundation.org/api/units/112354318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.268166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=402d648b54a4dcca", "url": "https://translations.documentfoundation.org/api/units/112354319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.270143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a5415e3bffd78c85", "url": "https://translations.documentfoundation.org/api/units/112354320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.271894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=27ee5cd5104919c1", "url": "https://translations.documentfoundation.org/api/units/112354321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.273552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=da3759a220fc614f", "url": "https://translations.documentfoundation.org/api/units/112354322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.275054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=735a281bdcdb54e9", "url": "https://translations.documentfoundation.org/api/units/112354323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.276417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3b4dcc918e63536c", "url": "https://translations.documentfoundation.org/api/units/112354324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.277781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6331810bfa5f7284", "url": "https://translations.documentfoundation.org/api/units/112354325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.279159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=97b7af07398c9098", "url": "https://translations.documentfoundation.org/api/units/112354326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.280635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=714bd59187148a58", "url": "https://translations.documentfoundation.org/api/units/112354327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.282074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1033c8c79733c2cf", "url": "https://translations.documentfoundation.org/api/units/112354328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.283492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f09f320cd62cc74f", "url": "https://translations.documentfoundation.org/api/units/112354329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.284903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b1d5325338cd6cc0", "url": "https://translations.documentfoundation.org/api/units/112354330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.286412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8db60d556d6af736", "url": "https://translations.documentfoundation.org/api/units/112354331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.287930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c69cda4b2930ca1b", "url": "https://translations.documentfoundation.org/api/units/112354332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.290844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=296f9b02116b0c27", "url": "https://translations.documentfoundation.org/api/units/112354333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.293727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fb5e8cfcfa282517", "url": "https://translations.documentfoundation.org/api/units/112354334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.296346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c4b49092d20cc792", "url": "https://translations.documentfoundation.org/api/units/112354335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.298502Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=041f9d75540d0595", "url": "https://translations.documentfoundation.org/api/units/112354336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.300581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=feda5de6ce2ee0ce", "url": "https://translations.documentfoundation.org/api/units/112354337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.302356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=09bd17144a2840b3", "url": "https://translations.documentfoundation.org/api/units/112354338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.303810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1996c54802875662", "url": "https://translations.documentfoundation.org/api/units/112354339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.305198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0fba83a8e8996c6b", "url": "https://translations.documentfoundation.org/api/units/112354340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.306687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d577f8e77f911193", "url": "https://translations.documentfoundation.org/api/units/112354341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.308187Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fbba2772312916b9", "url": "https://translations.documentfoundation.org/api/units/112354342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.309602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1efcd071ab1b14b1", "url": "https://translations.documentfoundation.org/api/units/112354343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.311100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e2250a50ce626ea2", "url": "https://translations.documentfoundation.org/api/units/112354344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.312557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=581f812ba47732df", "url": "https://translations.documentfoundation.org/api/units/112354345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.313995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6022c680451c23b5", "url": "https://translations.documentfoundation.org/api/units/112354346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.315781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f9f62be519432b41", "url": "https://translations.documentfoundation.org/api/units/112354347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.318621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4853397d611baad1", "url": "https://translations.documentfoundation.org/api/units/112354348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.320460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0ba14c6bb86e1eb4", "url": "https://translations.documentfoundation.org/api/units/112354349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.321715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=69933d89bce47487", "url": "https://translations.documentfoundation.org/api/units/112354350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.322861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9470a1198dcc9da9", "url": "https://translations.documentfoundation.org/api/units/112354351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.323929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ee35d0488da0d23b", "url": "https://translations.documentfoundation.org/api/units/112354352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.325124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354353, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/112354353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.326170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/112354354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.327263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e08fec57a42f4207", "url": "https://translations.documentfoundation.org/api/units/112354355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.328475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112354356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/112354356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:19.329544Z" } ] }{ "count": 8439, "next": "