Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=10
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=11", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=9", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8145424c46d6b7ba", "url": "https://translations.documentfoundation.org/api/units/112428758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.034975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f2d13926dcfcb598", "url": "https://translations.documentfoundation.org/api/units/112428759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.035883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6b23d49ec80ac7d9", "url": "https://translations.documentfoundation.org/api/units/112428760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.036934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f3dc64e5e9f70975", "url": "https://translations.documentfoundation.org/api/units/112428761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.037890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=caa5e065e2130424", "url": "https://translations.documentfoundation.org/api/units/112428762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.038803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c79e285a3c68107d", "url": "https://translations.documentfoundation.org/api/units/112428763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.039744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a9e2a34274676276", "url": "https://translations.documentfoundation.org/api/units/112428764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.040642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=14249d5579c296e5", "url": "https://translations.documentfoundation.org/api/units/112428765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.041539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6ec437bd4edec12b", "url": "https://translations.documentfoundation.org/api/units/112428766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.042458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d3c521505745858f", "url": "https://translations.documentfoundation.org/api/units/112428767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.043351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=aaf13fa9dd64ae0d", "url": "https://translations.documentfoundation.org/api/units/112428768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.044317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3a730be44c0a5293", "url": "https://translations.documentfoundation.org/api/units/112428769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.045305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a3e9b09459b2189f", "url": "https://translations.documentfoundation.org/api/units/112428770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.046277Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a318c809e716d4bb", "url": "https://translations.documentfoundation.org/api/units/112428771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.047365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2d855897e55d0677", "url": "https://translations.documentfoundation.org/api/units/112428772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.048309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a28c222d17c50ad", "url": "https://translations.documentfoundation.org/api/units/112428773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.049269Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=72aa7ff65482cf15", "url": "https://translations.documentfoundation.org/api/units/112428774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.050248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ad036cf8e2bcddfb", "url": "https://translations.documentfoundation.org/api/units/112428775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.051257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a30896ffcade2886", "url": "https://translations.documentfoundation.org/api/units/112428776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.052267Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a684a3a2da1d11c", "url": "https://translations.documentfoundation.org/api/units/112428777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.053254Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=29386c0479902f49", "url": "https://translations.documentfoundation.org/api/units/112428778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.054203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5b9ea06eae6749d0", "url": "https://translations.documentfoundation.org/api/units/112428779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.055192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b0b48a7dd620a22f", "url": "https://translations.documentfoundation.org/api/units/112428780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.056176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1600fc51a22e255c", "url": "https://translations.documentfoundation.org/api/units/112428781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.057313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=37b7344cd47fe2fd", "url": "https://translations.documentfoundation.org/api/units/112428782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.058572Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=51535f669787764d", "url": "https://translations.documentfoundation.org/api/units/112428783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.060190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f9ac6dcc15776c84", "url": "https://translations.documentfoundation.org/api/units/112428784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.061779Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=925fe89a3dba20f7", "url": "https://translations.documentfoundation.org/api/units/112428785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.063668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f4ad7861bc19e799", "url": "https://translations.documentfoundation.org/api/units/112428786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.065747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=15195f794609aa29", "url": "https://translations.documentfoundation.org/api/units/112428787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.067483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e842ba1171e19cf4", "url": "https://translations.documentfoundation.org/api/units/112428788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.068604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f435675f63737c57", "url": "https://translations.documentfoundation.org/api/units/112428789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.069605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fa15972bf2ff940c", "url": "https://translations.documentfoundation.org/api/units/112428790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.070671Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ab56353f26c0154e", "url": "https://translations.documentfoundation.org/api/units/112428791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.071719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5fecc9cffc0443b0", "url": "https://translations.documentfoundation.org/api/units/112428792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.072782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4767ce33d0ff705d", "url": "https://translations.documentfoundation.org/api/units/112428793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.074152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3f1e20952eec89d7", "url": "https://translations.documentfoundation.org/api/units/112428794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.075769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6eebd0b037ba249e", "url": "https://translations.documentfoundation.org/api/units/112428795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.077494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=64d589c96092ca24", "url": "https://translations.documentfoundation.org/api/units/112428796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.079216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ed0ea33259860266", "url": "https://translations.documentfoundation.org/api/units/112428797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.080526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=543e1ff22d2672f5", "url": "https://translations.documentfoundation.org/api/units/112428798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.081839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7c24e6ef50b059e8", "url": "https://translations.documentfoundation.org/api/units/112428799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.083172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eb4eee48b2bdfb6b", "url": "https://translations.documentfoundation.org/api/units/112428800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.084556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=89ebb25d8173d24d", "url": "https://translations.documentfoundation.org/api/units/112428801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.085815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=20d02b4554ae1500", "url": "https://translations.documentfoundation.org/api/units/112428802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.087429Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8ae437ab205e3a10", "url": "https://translations.documentfoundation.org/api/units/112428803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.089083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=65b74c0391b811ec", "url": "https://translations.documentfoundation.org/api/units/112428804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.090986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=63c7b42bad88ac95", "url": "https://translations.documentfoundation.org/api/units/112428805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.092712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a4f3303f94540269", "url": "https://translations.documentfoundation.org/api/units/112428806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.093921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112428807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9d819f11acbdd747", "url": "https://translations.documentfoundation.org/api/units/112428807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:03.095141Z" } ] }