Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=10
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=11", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=9", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8145424c46d6b7ba", "url": "https://translations.documentfoundation.org/api/units/112352807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.054813Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f2d13926dcfcb598", "url": "https://translations.documentfoundation.org/api/units/112352808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.056157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352809, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6b23d49ec80ac7d9", "url": "https://translations.documentfoundation.org/api/units/112352809/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.057699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f3dc64e5e9f70975", "url": "https://translations.documentfoundation.org/api/units/112352810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.059137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=caa5e065e2130424", "url": "https://translations.documentfoundation.org/api/units/112352811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.060614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352812, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c79e285a3c68107d", "url": "https://translations.documentfoundation.org/api/units/112352812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.062021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352813, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a9e2a34274676276", "url": "https://translations.documentfoundation.org/api/units/112352813/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.063563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=14249d5579c296e5", "url": "https://translations.documentfoundation.org/api/units/112352814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.065253Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6ec437bd4edec12b", "url": "https://translations.documentfoundation.org/api/units/112352815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.067608Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352816, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d3c521505745858f", "url": "https://translations.documentfoundation.org/api/units/112352816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.069592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=aaf13fa9dd64ae0d", "url": "https://translations.documentfoundation.org/api/units/112352817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.071417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352818, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3a730be44c0a5293", "url": "https://translations.documentfoundation.org/api/units/112352818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.072625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352819, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a3e9b09459b2189f", "url": "https://translations.documentfoundation.org/api/units/112352819/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.073935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352820, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a318c809e716d4bb", "url": "https://translations.documentfoundation.org/api/units/112352820/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.075055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2d855897e55d0677", "url": "https://translations.documentfoundation.org/api/units/112352821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.076011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5a28c222d17c50ad", "url": "https://translations.documentfoundation.org/api/units/112352822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.078090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352823, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=72aa7ff65482cf15", "url": "https://translations.documentfoundation.org/api/units/112352823/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.079146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ad036cf8e2bcddfb", "url": "https://translations.documentfoundation.org/api/units/112352824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.080092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a30896ffcade2886", "url": "https://translations.documentfoundation.org/api/units/112352825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.081184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5a684a3a2da1d11c", "url": "https://translations.documentfoundation.org/api/units/112352826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.082218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=29386c0479902f49", "url": "https://translations.documentfoundation.org/api/units/112352827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.083255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352828, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5b9ea06eae6749d0", "url": "https://translations.documentfoundation.org/api/units/112352828/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.084421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352829, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b0b48a7dd620a22f", "url": "https://translations.documentfoundation.org/api/units/112352829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.085492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1600fc51a22e255c", "url": "https://translations.documentfoundation.org/api/units/112352830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.086610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=37b7344cd47fe2fd", "url": "https://translations.documentfoundation.org/api/units/112352831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.087655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=51535f669787764d", "url": "https://translations.documentfoundation.org/api/units/112352832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.088751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352833, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f9ac6dcc15776c84", "url": "https://translations.documentfoundation.org/api/units/112352833/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.089793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=925fe89a3dba20f7", "url": "https://translations.documentfoundation.org/api/units/112352834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.090842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f4ad7861bc19e799", "url": "https://translations.documentfoundation.org/api/units/112352835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.091842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352836, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=15195f794609aa29", "url": "https://translations.documentfoundation.org/api/units/112352836/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.093031Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e842ba1171e19cf4", "url": "https://translations.documentfoundation.org/api/units/112352837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.094182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f435675f63737c57", "url": "https://translations.documentfoundation.org/api/units/112352838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.095307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fa15972bf2ff940c", "url": "https://translations.documentfoundation.org/api/units/112352839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.096413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ab56353f26c0154e", "url": "https://translations.documentfoundation.org/api/units/112352840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.097419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5fecc9cffc0443b0", "url": "https://translations.documentfoundation.org/api/units/112352841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.098490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4767ce33d0ff705d", "url": "https://translations.documentfoundation.org/api/units/112352842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.099746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3f1e20952eec89d7", "url": "https://translations.documentfoundation.org/api/units/112352843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.100853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6eebd0b037ba249e", "url": "https://translations.documentfoundation.org/api/units/112352844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.101881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=64d589c96092ca24", "url": "https://translations.documentfoundation.org/api/units/112352845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.102990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ed0ea33259860266", "url": "https://translations.documentfoundation.org/api/units/112352846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.104059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=543e1ff22d2672f5", "url": "https://translations.documentfoundation.org/api/units/112352847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.105141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7c24e6ef50b059e8", "url": "https://translations.documentfoundation.org/api/units/112352848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.106146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eb4eee48b2bdfb6b", "url": "https://translations.documentfoundation.org/api/units/112352849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.107135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=89ebb25d8173d24d", "url": "https://translations.documentfoundation.org/api/units/112352850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.108176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=20d02b4554ae1500", "url": "https://translations.documentfoundation.org/api/units/112352851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.109498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8ae437ab205e3a10", "url": "https://translations.documentfoundation.org/api/units/112352852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.111049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=65b74c0391b811ec", "url": "https://translations.documentfoundation.org/api/units/112352853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.112631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=63c7b42bad88ac95", "url": "https://translations.documentfoundation.org/api/units/112352854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.114062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a4f3303f94540269", "url": "https://translations.documentfoundation.org/api/units/112352855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.115193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112352856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9d819f11acbdd747", "url": "https://translations.documentfoundation.org/api/units/112352856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.116325Z" } ] }{ "count": 8439, "next": "