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=10
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=11", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=9", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/formula_result\">Displays the calculation result or an error message.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 91552262804387770, "content_hash": 91552262804387770, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3150211\nhelp.text", "note": "iGrov", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 451, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110924332/?format=api", "priority": 100, "id": 112105317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=8145424c46d6b7ba", "url": "https://translations.documentfoundation.org/api/units/112105317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.027190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Formula" ], "previous_source": "", "target": [ "" ], "id_hash": 8273456829535401368, "content_hash": 8273456829535401368, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3151304\nhelp.text", "note": "jWE5Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 452, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924364/?format=api", "priority": 100, "id": 112105318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f2d13926dcfcb598", "url": "https://translations.documentfoundation.org/api/units/112105318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.029471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/ed_formula\">Displays the created formula. Type your entries directly, or create the formula using the wizard.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -1503124072185542695, "content_hash": -1503124072185542695, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3149898\nhelp.text", "note": "EsQE7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 453, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110924385/?format=api", "priority": 100, "id": 112105321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6b23d49ec80ac7d9", "url": "https://translations.documentfoundation.org/api/units/112105321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.030507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Back" ], "previous_source": "", "target": [ "" ], "id_hash": 8348658747873626485, "content_hash": 8348658747873626485, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3153249\nhelp.text", "note": "iBGou", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 454, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924419/?format=api", "priority": 100, "id": 112105324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f3dc64e5e9f70975", "url": "https://translations.documentfoundation.org/api/units/112105324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.031599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/back\">Moves the focus back through the formula components, marking them as it does so.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5378952058153141284, "content_hash": 5378952058153141284, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3152869\nhelp.text", "note": "ei34W", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 455, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110924435/?format=api", "priority": 100, "id": 112105326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=caa5e065e2130424", "url": "https://translations.documentfoundation.org/api/units/112105326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.032627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "To select a single function from a complex formula consisting of several functions, double-click the function in the formula window." ], "previous_source": "", "target": [ "" ], "id_hash": 5160606591038787709, "content_hash": 5160606591038787709, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3146966\nhelp.text", "note": "XazZe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 456, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110924441/?format=api", "priority": 100, "id": 112105329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c79e285a3c68107d", "url": "https://translations.documentfoundation.org/api/units/112105329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.033661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Next" ], "previous_source": "", "target": [ "" ], "id_hash": 3018154206107755126, "content_hash": 3018154206107755126, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3155762\nhelp.text", "note": "smGyc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 457, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924470/?format=api", "priority": 100, "id": 112105331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a9e2a34274676276", "url": "https://translations.documentfoundation.org/api/units/112105331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.034977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/next\">Moves forward through the formula components in the formula window.</ahelp> This button can also be used to assign functions to the formula. If you select a function and click the <emph>Next</emph> button, the selection appears in the formula window." ], "previous_source": "", "target": [ "" ], "id_hash": -7771914066494056731, "content_hash": -7771914066494056731, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3149316\nhelp.text", "note": "Eembv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 458, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110924504/?format=api", "priority": 100, "id": 112105332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=14249d5579c296e5", "url": "https://translations.documentfoundation.org/api/units/112105332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.036287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Double-click a function in the selection window to transfer it to the formula window." ], "previous_source": "", "target": [ "" ], "id_hash": -1241806311035846357, "content_hash": -1241806311035846357, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3159262\nhelp.text", "note": "rc9R8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 459, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110924539/?format=api", "priority": 100, "id": 112105334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6ec437bd4edec12b", "url": "https://translations.documentfoundation.org/api/units/112105334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.037722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "OK" ], "previous_source": "", "target": [ "" ], "id_hash": 6036267504505292175, "content_hash": 6036267504505292175, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3150534\nhelp.text", "note": "FNqqJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 460, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924579/?format=api", "priority": 100, "id": 112105337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d3c521505745858f", "url": "https://translations.documentfoundation.org/api/units/112105337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.039817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/ok\">Ends the <emph>Function Wizard</emph>, and transfers the formula to the selected cells.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3094324417776627213, "content_hash": 3094324417776627213, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3153029\nhelp.text", "note": "4urnG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 461, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110924628/?format=api", "priority": 100, "id": 112105340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=aaf13fa9dd64ae0d", "url": "https://translations.documentfoundation.org/api/units/112105340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.042414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Cancel" ], "previous_source": "", "target": [ "" ], "id_hash": -5011648885177036141, "content_hash": -5011648885177036141, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3148745\nhelp.text", "note": "fBUkR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924630/?format=api", "priority": 100, "id": 112105345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3a730be44c0a5293", "url": "https://translations.documentfoundation.org/api/units/112105345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.045121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/formuladialog/cancel\">Closes the dialog without implementing the formula.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 2587793612107552927, "content_hash": 2587793612107552927, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3147402\nhelp.text", "note": "zwoBc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110924665/?format=api", "priority": 100, "id": 112105348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a3e9b09459b2189f", "url": "https://translations.documentfoundation.org/api/units/112105348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.047011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Structure tab" ], "previous_source": "", "target": [ "" ], "id_hash": 2528991135625827515, "content_hash": 2528991135625827515, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3147610\nhelp.text", "note": "mBHTQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110924701/?format=api", "priority": 100, "id": 112105350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a318c809e716d4bb", "url": "https://translations.documentfoundation.org/api/units/112105350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.048603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "On this page, you can view the structure of the function." ], "previous_source": "", "target": [ "" ], "id_hash": -5943246723834116489, "content_hash": -5943246723834116489, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3153122\nhelp.text", "note": "Egchi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110924741/?format=api", "priority": 100, "id": 112105354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=2d855897e55d0677", "url": "https://translations.documentfoundation.org/api/units/112105354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.055252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If you start the <emph>Function Wizard</emph> while the cell cursor is positioned in a cell that already contains a function, the <emph>Structure</emph> tab is opened and shows the composition of the current formula." ], "previous_source": "", "target": [ "" ], "id_hash": -2726716119573573459, "content_hash": -2726716119573573459, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3149350\nhelp.text", "note": "TsXbp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110924774/?format=api", "priority": 100, "id": 112105355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5a28c222d17c50ad", "url": "https://translations.documentfoundation.org/api/units/112105355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.057266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Structure" ], "previous_source": "", "target": [ "" ], "id_hash": -960814874533638379, "content_hash": -960814874533638379, "location": "04060000.xhp", "context": "04060000.xhp\nhd_id3149014\nhelp.text", "note": "bNwhM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 467, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110924817/?format=api", "priority": 100, "id": 112105357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=72aa7ff65482cf15", "url": "https://translations.documentfoundation.org/api/units/112105357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.059574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"formula/ui/structpage/struct\">Displays a hierarchical representation of the current function.</ahelp> You can hide or show the arguments by a click on the plus or minus sign in front." ], "previous_source": "", "target": [ "" ], "id_hash": 3243555972848606715, "content_hash": 3243555972848606715, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3150481\nhelp.text", "note": "WBCn7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110924825/?format=api", "priority": 100, "id": 112105359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ad036cf8e2bcddfb", "url": "https://translations.documentfoundation.org/api/units/112105359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.061332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Blue dots denote correctly entered arguments. Red dots indicate incorrect data types. For example: if the SUM function has one argument entered as text, this is highlighted in red as SUM only permits number entries." ], "previous_source": "", "target": [ "" ], "id_hash": 2524433616505546886, "content_hash": 2524433616505546886, "location": "04060000.xhp", "context": "04060000.xhp\npar_id3148886\nhelp.text", "note": "debaD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110924838/?format=api", "priority": 100, "id": 112105363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a30896ffcade2886", "url": "https://translations.documentfoundation.org/api/units/112105363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.063891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Functions by Category" ], "previous_source": "", "target": [ "" ], "id_hash": -2708833562129215204, "content_hash": -2708833562129215204, "location": "04060100.xhp", "context": "04060100.xhp\ntit\nhelp.text", "note": "Q8EWn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 470, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110924871/?format=api", "priority": 100, "id": 112105366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5a684a3a2da1d11c", "url": "https://translations.documentfoundation.org/api/units/112105366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.066095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>functions;listed by category</bookmark_value> <bookmark_value>categories of functions</bookmark_value> <bookmark_value>list of functions</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -6253129316128772279, "content_hash": -6253129316128772279, "location": "04060100.xhp", "context": "04060100.xhp\nbm_id3148575\nhelp.text", "note": "VZrAg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110924899/?format=api", "priority": 100, "id": 112105368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=29386c0479902f49", "url": "https://translations.documentfoundation.org/api/units/112105368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.068805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<variable id=\"drking\"><link href=\"text/scalc/01/04060100.xhp\">Functions by Category</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -2621481535850198576, "content_hash": -2621481535850198576, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3154944\nhelp.text", "note": "6CyXU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110924917/?format=api", "priority": 100, "id": 112105371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5b9ea06eae6749d0", "url": "https://translations.documentfoundation.org/api/units/112105371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.071550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "This section describes the functions of $[officename] Calc. The various functions are divided into categories in the Function Wizard." ], "previous_source": "", "target": [ "" ], "id_hash": 3509582282696466991, "content_hash": 3509582282696466991, "location": "04060100.xhp", "context": "04060100.xhp\npar_id3149378\nhelp.text", "note": "FanRR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110924936/?format=api", "priority": 100, "id": 112105375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b0b48a7dd620a22f", "url": "https://translations.documentfoundation.org/api/units/112105375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.073786Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060101.xhp\">Database</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7637827540476877476, "content_hash": -7637827540476877476, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3146972\nhelp.text", "note": "W5LYA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110924963/?format=api", "priority": 100, "id": 112105378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=1600fc51a22e255c", "url": "https://translations.documentfoundation.org/api/units/112105378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.075406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060102.xhp\">Date & Time</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5208636939443379459, "content_hash": -5208636939443379459, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3155443\nhelp.text", "note": "ttRtD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110924971/?format=api", "priority": 100, "id": 112105379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=37b7344cd47fe2fd", "url": "https://translations.documentfoundation.org/api/units/112105379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.077329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060103.xhp\">Financial</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -3363239602482088371, "content_hash": -3363239602482088371, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3147339\nhelp.text", "note": "4rXEd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110924981/?format=api", "priority": 100, "id": 112105381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=51535f669787764d", "url": "https://translations.documentfoundation.org/api/units/112105381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.078391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060104.xhp\">Information</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8767503297884417156, "content_hash": 8767503297884417156, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3153963\nhelp.text", "note": "cnnmF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110924993/?format=api", "priority": 100, "id": 112105384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f9ac6dcc15776c84", "url": "https://translations.documentfoundation.org/api/units/112105384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.079506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060105.xhp\">Logical</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 1324032564628431095, "content_hash": 1324032564628431095, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3146316\nhelp.text", "note": "5C7D2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925008/?format=api", "priority": 100, "id": 112105386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=925fe89a3dba20f7", "url": "https://translations.documentfoundation.org/api/units/112105386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.080492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060106.xhp\">Mathematical</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8407508440533559193, "content_hash": 8407508440533559193, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3148485\nhelp.text", "note": "bEJVw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925009/?format=api", "priority": 100, "id": 112105388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f4ad7861bc19e799", "url": "https://translations.documentfoundation.org/api/units/112105388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.081481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060107.xhp\">Array</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7703020713169802711, "content_hash": -7703020713169802711, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3150363\nhelp.text", "note": "qGnQ2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925042/?format=api", "priority": 100, "id": 112105391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=15195f794609aa29", "url": "https://translations.documentfoundation.org/api/units/112105391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.082513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060108.xhp\">Statistical</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 7512771712495230196, "content_hash": 7512771712495230196, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3150208\nhelp.text", "note": "MtGFP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925055/?format=api", "priority": 100, "id": 112105393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e842ba1171e19cf4", "url": "https://translations.documentfoundation.org/api/units/112105393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.083636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8373712741553372247, "content_hash": 8373712741553372247, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3166428\nhelp.text", "note": "97qtM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925069/?format=api", "priority": 100, "id": 112105395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f435675f63737c57", "url": "https://translations.documentfoundation.org/api/units/112105395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.084792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp\">Text</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8797103662154355724, "content_hash": 8797103662154355724, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3145585\nhelp.text", "note": "JeNA3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925077/?format=api", "priority": 100, "id": 112105398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fa15972bf2ff940c", "url": "https://translations.documentfoundation.org/api/units/112105398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.085846Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060111.xhp\">Add-in</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 3122741936977352014, "content_hash": 3122741936977352014, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3156449\nhelp.text", "note": "b5ysX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925101/?format=api", "priority": 100, "id": 112105400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ab56353f26c0154e", "url": "https://translations.documentfoundation.org/api/units/112105400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.086921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<link href=\"text/scalc/01/04060199.xhp\">Operators</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2311250613624355920, "content_hash": -2311250613624355920, "location": "04060100.xhp", "context": "04060100.xhp\npar_id3150715\nhelp.text", "note": "mTLFx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925116/?format=api", "priority": 100, "id": 112105404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5fecc9cffc0443b0", "url": "https://translations.documentfoundation.org/api/units/112105404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.088780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Database Functions" ], "previous_source": "", "target": [ "" ], "id_hash": -4078064215615639459, "content_hash": -4078064215615639459, "location": "04060101.xhp", "context": "04060101.xhp\ntit\nhelp.text", "note": "ENAh9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925132/?format=api", "priority": 100, "id": 112105407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4767ce33d0ff705d", "url": "https://translations.documentfoundation.org/api/units/112105407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.090595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4675263538054526505, "content_hash": -4675263538054526505, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148946\nhelp.text", "note": "ASfzE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110925166/?format=api", "priority": 100, "id": 112105408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3f1e20952eec89d7", "url": "https://translations.documentfoundation.org/api/units/112105408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.092251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Database Functions" ], "previous_source": "", "target": [ "" ], "id_hash": -1230660617887931234, "content_hash": -1230660617887931234, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3148946\nhelp.text", "note": "BX97Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925204/?format=api", "priority": 100, "id": 112105411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6eebd0b037ba249e", "url": "https://translations.documentfoundation.org/api/units/112105411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.094112Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Overview" ], "previous_source": "", "target": [ "" ], "id_hash": -1957506965020947932, "content_hash": -1957506965020947932, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id721616440441374\nhelp.text", "note": "v9KEM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110925245/?format=api", "priority": 100, "id": 112105413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=64d589c96092ca24", "url": "https://translations.documentfoundation.org/api/units/112105413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.096228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<variable id=\"datenbanktext\">The twelve functions in the Database category help you to analyze a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.</variable> The header cell of each column displays the name of the column and that name usually reflects the contents of each cell in that column." ], "previous_source": "", "target": [ "" ], "id_hash": 7858397836453741158, "content_hash": 7858397836453741158, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145173\nhelp.text", "note": "RGkxy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/110925287/?format=api", "priority": 100, "id": 112105417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ed0ea33259860266", "url": "https://translations.documentfoundation.org/api/units/112105417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.098339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The functions in the Database category take three arguments as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -3153047564112727307, "content_hash": -3153047564112727307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id631615842419413\nhelp.text", "note": "8NQZ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110925318/?format=api", "priority": 100, "id": 112105419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=543e1ff22d2672f5", "url": "https://translations.documentfoundation.org/api/units/112105419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.100631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Database</emph>. The cell range of the database." ], "previous_source": "", "target": [ "" ], "id_hash": -277843361464821272, "content_hash": -277843361464821272, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615842549780\nhelp.text", "note": "pmE4Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110925342/?format=api", "priority": 100, "id": 112105422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7c24e6ef50b059e8", "url": "https://translations.documentfoundation.org/api/units/112105422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.102615Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>DatabaseField</emph>. The column containing the data to be used in the function’s calculations." ], "previous_source": "", "target": [ "" ], "id_hash": 7732379606245571435, "content_hash": 7732379606245571435, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615842657372\nhelp.text", "note": "nw3ya", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110925343/?format=api", "priority": 100, "id": 112105425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=eb4eee48b2bdfb6b", "url": "https://translations.documentfoundation.org/api/units/112105425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.106907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>SearchCriteria</emph>. The cell range of a separate area of the spreadsheet containing search criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 714861080541909581, "content_hash": 714861080541909581, "location": "04060101.xhp", "context": "04060101.xhp\npar_id471615842721059\nhelp.text", "note": "D5P4G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110925372/?format=api", "priority": 100, "id": 112105429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=89ebb25d8173d24d", "url": "https://translations.documentfoundation.org/api/units/112105429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.109784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "These arguments are described more fully below." ], "previous_source": "", "target": [ "" ], "id_hash": -6858934655711832832, "content_hash": -6858934655711832832, "location": "04060101.xhp", "context": "04060101.xhp\npar_id101615842794525\nhelp.text", "note": "RT3mc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110925393/?format=api", "priority": 100, "id": 112105432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=20d02b4554ae1500", "url": "https://translations.documentfoundation.org/api/units/112105432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.111659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "All functions have the same outline concept of operation. The first logical step is to use the specified <emph>SearchCriteria</emph> to identify the subset of records in the <emph>Database</emph> that are to be used during subsequent calculations. The second step is to extract the data values and perform the calculations associated with the specific function (average, sum, product, and so on). The values processed are those in the <emph>DatabaseField</emph> column of the selected records." ], "previous_source": "", "target": [ "" ], "id_hash": 784813443191290384, "content_hash": 784813443191290384, "location": "04060101.xhp", "context": "04060101.xhp\npar_id241615842810077\nhelp.text", "note": "ykxDt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/110925416/?format=api", "priority": 100, "id": 112105435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=8ae437ab205e3a10", "url": "https://translations.documentfoundation.org/api/units/112105435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.113512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Calc treats dates and logical values (TRUE and FALSE) as numeric when calculating with these functions." ], "previous_source": "", "target": [ "" ], "id_hash": -1893961540072631828, "content_hash": -1893961540072631828, "location": "04060101.xhp", "context": "04060101.xhp\npar_id981615978852310\nhelp.text", "note": "oErum", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110925432/?format=api", "priority": 100, "id": 112105470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=65b74c0391b811ec", "url": "https://translations.documentfoundation.org/api/units/112105470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.152431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Database Function Arguments" ], "previous_source": "", "target": [ "" ], "id_hash": -2033458607046480747, "content_hash": -2033458607046480747, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id911615888814785\nhelp.text", "note": "qZFoo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110925446/?format=api", "priority": 100, "id": 112105475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=63c7b42bad88ac95", "url": "https://translations.documentfoundation.org/api/units/112105475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.155570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "The following argument definitions apply for all functions in the Database category:" ], "previous_source": "", "target": [ "" ], "id_hash": 2662524854335701609, "content_hash": 2662524854335701609, "location": "04060101.xhp", "context": "04060101.xhp\npar_id911615888833104\nhelp.text", "note": "XzUDg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110925456/?format=api", "priority": 100, "id": 112105478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a4f3303f94540269", "url": "https://translations.documentfoundation.org/api/units/112105478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.158045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Database argument</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 2126155397356967751, "content_hash": 2126155397356967751, "location": "04060101.xhp", "context": "04060101.xhp\npar_id21615889071992\nhelp.text", "note": "EHkEz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925464/?format=api", "priority": 100, "id": 112105481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=9d819f11acbdd747", "url": "https://translations.documentfoundation.org/api/units/112105481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:09:58.161385Z" } ] }