Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=30
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=31", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=29", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1." ], "previous_source": "", "target": [ "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1." ], "id_hash": 8918437824977058734, "content_hash": 8918437824977058734, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148606\nhelp.text", "note": "WtG8F", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1451, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110840460/?format=api", "priority": 100, "id": 110840460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=fbc4a7f32d2a3bae", "url": "https://translations.documentfoundation.org/api/units/110840460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.508476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Set the cursor in another cell and enter the following:" ], "previous_source": "", "target": [ "Set the cursor in another cell and enter the following:" ], "id_hash": 2198067963557638580, "content_hash": 2198067963557638580, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3156019\nhelp.text", "note": "TTo2C", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1452, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110840476/?format=api", "priority": 100, "id": 110840476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9e811b2ac004f1b4", "url": "https://translations.documentfoundation.org/api/units/110840476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.522291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The function is evaluated and you will see the result in the selected cell." ], "previous_source": "", "target": [ "The function is evaluated and you will see the result in the selected cell." ], "id_hash": 1572304949163719896, "content_hash": 1572304949163719896, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3146776\nhelp.text", "note": "frbse", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1453, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110840488/?format=api", "priority": 100, "id": 110840488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=95d1f305557dfcd8", "url": "https://translations.documentfoundation.org/api/units/110840488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.539602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Validity of Cell Contents" ], "previous_source": "", "target": [ "Validity of Cell Contents" ], "id_hash": -5406900885798361441, "content_hash": -5406900885798361441, "location": "validity.xhp", "context": "validity.xhp\ntit\nhelp.text", "note": "Un4f7", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1454, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110840516/?format=api", "priority": 100, "id": 110840516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=34f6d44a963e669f", "url": "https://translations.documentfoundation.org/api/units/110840516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.563219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>values; limiting on input</bookmark_value><bookmark_value>limits; specifying value limits on input</bookmark_value><bookmark_value>permitted cell contents</bookmark_value><bookmark_value>data validity</bookmark_value><bookmark_value>validity</bookmark_value><bookmark_value>cells; validity</bookmark_value><bookmark_value>error messages; defining for incorrect input</bookmark_value><bookmark_value>actions in case of incorrect input</bookmark_value><bookmark_value>Help tips; defining text for cell input</bookmark_value><bookmark_value>comments;help text for cells</bookmark_value><bookmark_value>cells; defining input help</bookmark_value><bookmark_value>macros; running when incorrect input</bookmark_value><bookmark_value>data; validity check</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>values; limiting on input</bookmark_value><bookmark_value>limits; specifying value limits on input</bookmark_value><bookmark_value>permitted cell contents</bookmark_value><bookmark_value>data validity</bookmark_value><bookmark_value>validity</bookmark_value><bookmark_value>cells; validity</bookmark_value><bookmark_value>error messages; defining for incorrect input</bookmark_value><bookmark_value>actions in case of incorrect input</bookmark_value><bookmark_value>Help tips; defining text for cell input</bookmark_value><bookmark_value>comments;help text for cells</bookmark_value><bookmark_value>cells; defining input help</bookmark_value><bookmark_value>macros; running when incorrect input</bookmark_value><bookmark_value>data; validity check</bookmark_value>" ], "id_hash": -3913397662873863939, "content_hash": -3913397662873863939, "location": "validity.xhp", "context": "validity.xhp\nbm_id3156442\nhelp.text", "note": "N5T5g", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1455, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110840537/?format=api", "priority": 100, "id": 110840537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=49b0d18f478f38fd", "url": "https://translations.documentfoundation.org/api/units/110840537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.582655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"validity\"><link href=\"text/scalc/guide/validity.xhp\">Validity of Cell Contents</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"validity\"><link href=\"text/scalc/guide/validity.xhp\">Validity of Cell Contents</link></variable>" ], "id_hash": -8114333094218069397, "content_hash": -8114333094218069397, "location": "validity.xhp", "context": "validity.xhp\nhd_id3156442\nhelp.text", "note": "GAC8Q", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1456, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110840557/?format=api", "priority": 100, "id": 110840557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0f64190ad9ef8a6b", "url": "https://translations.documentfoundation.org/api/units/110840557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.593925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected." ], "previous_source": "", "target": [ "For each cell, you can define entries to be valid. Invalid entries to a cell will be rejected." ], "id_hash": -1023926637891208331, "content_hash": -1023926637891208331, "location": "validity.xhp", "context": "validity.xhp\npar_id3156283\nhelp.text", "note": "XgWFZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1457, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110840593/?format=api", "priority": 100, "id": 110840593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=71ca4825d86f3b75", "url": "https://translations.documentfoundation.org/api/units/110840593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.624383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect." ], "previous_source": "", "target": [ "The validity rule is activated when a new value is entered. If an invalid value has already been inserted into the cell, or if you insert a value in the cell either with drag-and-drop or by copying and pasting, the validity rule will not take effect." ], "id_hash": 2820331663557058441, "content_hash": 2820331663557058441, "location": "validity.xhp", "context": "validity.xhp\npar_id3145252\nhelp.text", "note": "cbHnL", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1458, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/110840612/?format=api", "priority": 100, "id": 110840612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a723d4b48b1adf89", "url": "https://translations.documentfoundation.org/api/units/110840612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.643992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href=\"text/scalc/01/06030800.xhp\"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values." ], "previous_source": "", "target": [ "You can choose <emph>Tools - Detective</emph> at any time and choose the command <link href=\"text/scalc/01/06030800.xhp\"><emph>Mark Invalid Data</emph></link> to display which cells contain invalid values." ], "id_hash": 4388874902227895597, "content_hash": 4388874902227895597, "location": "validity.xhp", "context": "validity.xhp\npar_id5174718\nhelp.text", "note": "N7bP8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1459, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110840643/?format=api", "priority": 100, "id": 110840643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bce86a7866ebc52d", "url": "https://translations.documentfoundation.org/api/units/110840643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.670188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Using Cell Contents Validity" ], "previous_source": "", "target": [ "Using Cell Contents Validity" ], "id_hash": 3900175137952680994, "content_hash": 3900175137952680994, "location": "validity.xhp", "context": "validity.xhp\nhd_id3155603\nhelp.text", "note": "vExqw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1460, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110840657/?format=api", "priority": 100, "id": 110840657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b620349fbb7acc22", "url": "https://translations.documentfoundation.org/api/units/110840657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.681345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select the cells for which you want to define a new validity rule." ], "previous_source": "", "target": [ "Select the cells for which you want to define a new validity rule." ], "id_hash": 8382514029992670019, "content_hash": 8382514029992670019, "location": "validity.xhp", "context": "validity.xhp\npar_id3155959\nhelp.text", "note": "vPWZE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1461, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110840683/?format=api", "priority": 100, "id": 110840683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f454ac190a70f343", "url": "https://translations.documentfoundation.org/api/units/110840683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.697457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Validity</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Validity</item>." ], "id_hash": 4680582892264813311, "content_hash": 4680582892264813311, "location": "validity.xhp", "context": "validity.xhp\npar_id3148837\nhelp.text", "note": "Rxqr5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110840703/?format=api", "priority": 100, "id": 110840703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c0f4c5577b36f2ff", "url": "https://translations.documentfoundation.org/api/units/110840703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.710615Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "On the <emph>Criteria</emph> tab page, enter the conditions for new values entered into cells." ], "previous_source": "", "target": [ "On the <emph>Criteria</emph> tab page, enter the conditions for new values entered into cells." ], "id_hash": 32299817226532278, "content_hash": 32299817226532278, "location": "validity.xhp", "context": "validity.xhp\npar_id3156020\nhelp.text", "note": "BCtiM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110840724/?format=api", "priority": 100, "id": 110840724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=8072c0833c18f5b6", "url": "https://translations.documentfoundation.org/api/units/110840724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.725287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "In the <emph>Allow</emph> field, select an option." ], "previous_source": "", "target": [ "In the <emph>Allow</emph> field, select an option." ], "id_hash": 5051350773992525740, "content_hash": 5051350773992525740, "location": "validity.xhp", "context": "validity.xhp\npar_id3159208\nhelp.text", "note": "6t74m", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110840744/?format=api", "priority": 100, "id": 110840744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c61a00c407b80fac", "url": "https://translations.documentfoundation.org/api/units/110840744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.738529Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If you select \"Whole Numbers\", values such as \"12.5\" are not allowed. Choosing \"Date\" allows date information both in the local date format as well as in the form of a <link href=\"text/sbasic/shared/03030101.xhp\">serial date</link>. Similarly, the \"Time\" condition permits time values such as \"12:00\" or serial time numbers. \"Text Length\" stipulates that cells are allowed to contain text only." ], "previous_source": "", "target": [ "If you select \"Whole Numbers\", values such as \"12.5\" are not allowed. Choosing \"Date\" allows date information both in the local date format as well as in the form of a <link href=\"text/sbasic/shared/03030101.xhp\">serial date</link>. Similarly, the \"Time\" condition permits time values such as \"12:00\" or serial time numbers. \"Text Length\" stipulates that cells are allowed to contain text only." ], "id_hash": 7345764367389693467, "content_hash": 7345764367389693467, "location": "validity.xhp", "context": "validity.xhp\npar_id3153011\nhelp.text", "note": "xDJjD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110840782/?format=api", "priority": 100, "id": 110840782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e5f165c5c9fc161b", "url": "https://translations.documentfoundation.org/api/units/110840782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.772919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select \"List\" to enter a list of valid entries." ], "previous_source": "", "target": [ "Select \"List\" to enter a list of valid entries." ], "id_hash": 5996058908768466292, "content_hash": 5996058908768466292, "location": "validity.xhp", "context": "validity.xhp\npar_id9224829\nhelp.text", "note": "qGjDb", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110840797/?format=api", "priority": 100, "id": 110840797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d33647cf1d75f574", "url": "https://translations.documentfoundation.org/api/units/110840797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.789372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select the next condition under <emph>Data</emph>. According to what you choose, additional options will be selectable." ], "previous_source": "", "target": [ "Select the next condition under <emph>Data</emph>. According to what you choose, additional options will be selectable." ], "id_hash": -5622913325092808003, "content_hash": -5622913325092808003, "location": "validity.xhp", "context": "validity.xhp\npar_id3149317\nhelp.text", "note": "JB7oA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1467, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110840817/?format=api", "priority": 100, "id": 110840817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=31f7661f4f085abd", "url": "https://translations.documentfoundation.org/api/units/110840817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.803580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "After you have determined the conditions for cell validity, you can use the other two tab pages to create message boxes:" ], "previous_source": "", "target": [ "After you have determined the conditions for cell validity, you can use the other two tab pages to create message boxes:" ], "id_hash": -8044108844742353312, "content_hash": -8044108844742353312, "location": "validity.xhp", "context": "validity.xhp\npar_id3151389\nhelp.text", "note": "KD7kV", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110840852/?format=api", "priority": 100, "id": 110840852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=105d95a00e8dde60", "url": "https://translations.documentfoundation.org/api/units/110840852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.823154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "On the <emph>Input Help</emph> tab page, enter the title and the text of the tip, which will then be displayed if the cell is selected." ], "previous_source": "", "target": [ "On the <emph>Input Help</emph> tab page, enter the title and the text of the tip, which will then be displayed if the cell is selected." ], "id_hash": -6601479030083520039, "content_hash": -6601479030083520039, "location": "validity.xhp", "context": "validity.xhp\npar_id3159261\nhelp.text", "note": "6aBi5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110840874/?format=api", "priority": 100, "id": 110840874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2462d5cc5bae79d9", "url": "https://translations.documentfoundation.org/api/units/110840874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.837809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "On the <emph>Error Alert</emph> tab page, select the action to be carried out in the event of an error." ], "previous_source": "", "target": [ "On the <emph>Error Alert</emph> tab page, select the action to be carried out in the event of an error." ], "id_hash": -8326001045519251532, "content_hash": -8326001045519251532, "location": "validity.xhp", "context": "validity.xhp\npar_id3156396\nhelp.text", "note": "U3y7G", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1470, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110840896/?format=api", "priority": 100, "id": 110840896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0c741a29824b47b4", "url": "https://translations.documentfoundation.org/api/units/110840896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.850243Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If you select \"Stop\" as the action, invalid entries are not accepted, and the previous cell contents are retained." ], "previous_source": "", "target": [ "If you select \"Stop\" as the action, invalid entries are not accepted, and the previous cell contents are retained." ], "id_hash": 7595747377443534355, "content_hash": 7595747377443534355, "location": "validity.xhp", "context": "validity.xhp\npar_id3147416\nhelp.text", "note": "JDuqF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110840915/?format=api", "priority": 100, "id": 110840915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e96983feec207613", "url": "https://translations.documentfoundation.org/api/units/110840915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.867097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select \"Warning\" or \"Information\" to display a dialog in which the entry can either be canceled or accepted." ], "previous_source": "", "target": [ "Select \"Warning\" or \"Information\" to display a dialog in which the entry can either be canceled or accepted." ], "id_hash": -3602323770549602976, "content_hash": -3602323770549602976, "location": "validity.xhp", "context": "validity.xhp\npar_id3150033\nhelp.text", "note": "FeWnd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110840929/?format=api", "priority": 100, "id": 110840929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4e01f99dda71f560", "url": "https://translations.documentfoundation.org/api/units/110840929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.879955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If you select \"Macro\", then by using the <emph>Browse</emph> button you can specify a macro to be run in the event of an error." ], "previous_source": "", "target": [ "If you select \"Macro\", then by using the <emph>Browse</emph> button you can specify a macro to be run in the event of an error." ], "id_hash": -7436576105795830117, "content_hash": -7436576105795830117, "location": "validity.xhp", "context": "validity.xhp\npar_id3149947\nhelp.text", "note": "9aCdk", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110840961/?format=api", "priority": 100, "id": 110840961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=18cbf96eb4e1be9b", "url": "https://translations.documentfoundation.org/api/units/110840961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.904055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To display the error message, select <link href=\"text/scalc/01/12120300.xhp\">Show error message when invalid values are entered</link>." ], "previous_source": "", "target": [ "To display the error message, select <link href=\"text/scalc/01/12120300.xhp\">Show error message when invalid values are entered</link>." ], "id_hash": -3928435818597722203, "content_hash": -3928435818597722203, "location": "validity.xhp", "context": "validity.xhp\npar_id3149011\nhelp.text", "note": "eiEtj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110840995/?format=api", "priority": 100, "id": 110840995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=497b646fcd8fd7a5", "url": "https://translations.documentfoundation.org/api/units/110840995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.921407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "After changing the action for a cell on the <emph>Error Alert</emph> tab page and closing the dialog with OK, you must first select another cell before the change takes effect." ], "previous_source": "", "target": [ "After changing the action for a cell on the <emph>Error Alert</emph> tab page and closing the dialog with OK, you must first select another cell before the change takes effect." ], "id_hash": 3073007378140170962, "content_hash": 3073007378140170962, "location": "validity.xhp", "context": "validity.xhp\npar_id3148586\nhelp.text", "note": "VTfnE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110841041/?format=api", "priority": 100, "id": 110841041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=aaa583edce330ad2", "url": "https://translations.documentfoundation.org/api/units/110841041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.947453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<link href=\"text/scalc/01/12120000.xhp\">Data - Validity</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/12120000.xhp\">Data - Validity</link>" ], "id_hash": -6433725026642040206, "content_hash": -6433725026642040206, "location": "validity.xhp", "context": "validity.xhp\npar_id3154805\nhelp.text", "note": "PpEfP", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110841078/?format=api", "priority": 100, "id": 110841078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=26b6d12cf475ea72", "url": "https://translations.documentfoundation.org/api/units/110841078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.960944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Naming Cells" ], "previous_source": "", "target": [ "Naming Cells" ], "id_hash": 2447709771474022857, "content_hash": 2447709771474022857, "location": "value_with_name.xhp", "context": "value_with_name.xhp\ntit\nhelp.text", "note": "cEdPu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110841119/?format=api", "priority": 100, "id": 110841119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a1f8031191f631c9", "url": "https://translations.documentfoundation.org/api/units/110841119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.976295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>cells; defining names</bookmark_value> <bookmark_value>names; defining for cells</bookmark_value> <bookmark_value>values; defining names</bookmark_value> <bookmark_value>constants definition</bookmark_value> <bookmark_value>variables; defining names</bookmark_value> <bookmark_value>cell ranges; defining names</bookmark_value> <bookmark_value>defining;names for cell ranges</bookmark_value> <bookmark_value>formulas; defining names</bookmark_value> <bookmark_value>addressing; by defined names</bookmark_value> <bookmark_value>cell names; defining/addressing</bookmark_value> <bookmark_value>references; by defined names</bookmark_value> <bookmark_value>allowed cell names</bookmark_value> <bookmark_value>renaming;cells</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>cells; defining names</bookmark_value> <bookmark_value>names; defining for cells</bookmark_value> <bookmark_value>values; defining names</bookmark_value> <bookmark_value>constants definition</bookmark_value> <bookmark_value>variables; defining names</bookmark_value> <bookmark_value>cell ranges; defining names</bookmark_value> <bookmark_value>defining;names for cell ranges</bookmark_value> <bookmark_value>formulas; defining names</bookmark_value> <bookmark_value>addressing; by defined names</bookmark_value> <bookmark_value>cell names; defining/addressing</bookmark_value> <bookmark_value>references; by defined names</bookmark_value> <bookmark_value>allowed cell names</bookmark_value> <bookmark_value>renaming;cells</bookmark_value>" ], "id_hash": -409338067973107191, "content_hash": -409338067973107191, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nbm_id3147434\nhelp.text", "note": "DGAwD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110841156/?format=api", "priority": 100, "id": 110841156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7a51bd32296b1209", "url": "https://translations.documentfoundation.org/api/units/110841156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:05.990326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"value_with_name\"><link href=\"text/scalc/guide/value_with_name.xhp\">Naming Cells</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"value_with_name\"><link href=\"text/scalc/guide/value_with_name.xhp\">Naming Cells</link></variable>" ], "id_hash": 4262294370165344629, "content_hash": 4262294370165344629, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id3147434\nhelp.text", "note": "vT4C3", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110841190/?format=api", "priority": 100, "id": 110841190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bb26b625a5da4975", "url": "https://translations.documentfoundation.org/api/units/110841190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.015147Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Allowed names" ], "previous_source": "", "target": [ "Allowed names" ], "id_hash": -244379193096465288, "content_hash": -244379193096465288, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id4391918\nhelp.text", "note": "EyNmi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110841221/?format=api", "priority": 100, "id": 110841221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7c9bca6b2cfd1478", "url": "https://translations.documentfoundation.org/api/units/110841221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.026985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character." ], "previous_source": "", "target": [ "Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character." ], "id_hash": -3084365872648043522, "content_hash": -3084365872648043522, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id2129581\nhelp.text", "note": "MECFu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110841252/?format=api", "priority": 100, "id": 110841252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=553221949b79c3fe", "url": "https://translations.documentfoundation.org/api/units/110841252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.040654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Allowed special characters:" ], "previous_source": "", "target": [ "Allowed special characters:" ], "id_hash": 6626427312520721695, "content_hash": 6626427312520721695, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id1120029\nhelp.text", "note": "GztrF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110841278/?format=api", "priority": 100, "id": 110841278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=dbf5cc884cbe751f", "url": "https://translations.documentfoundation.org/api/units/110841278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.052191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "underline (_)" ], "previous_source": "", "target": [ "underline (_)" ], "id_hash": -1053212889508042268, "content_hash": -1053212889508042268, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3362224\nhelp.text", "note": "4VANL", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110841322/?format=api", "priority": 100, "id": 110841322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/110841322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.080414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell." ], "previous_source": "", "target": [ "Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell." ], "id_hash": 6661512041254287758, "content_hash": 6661512041254287758, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id328989\nhelp.text", "note": "BvnNt", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110841345/?format=api", "priority": 100, "id": 110841345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/110841345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.091490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information." ], "previous_source": "", "target": [ "Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information." ], "id_hash": 4901609298986553279, "content_hash": 4901609298986553279, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id32898987\nhelp.text", "note": "ufHkJ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110841394/?format=api", "priority": 100, "id": 110841394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c40603b005d84fbf", "url": "https://translations.documentfoundation.org/api/units/110841394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.117891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents." ], "previous_source": "", "target": [ "Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents." ], "id_hash": -3862959233821167010, "content_hash": -3862959233821167010, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id4769737\nhelp.text", "note": "6piLZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110841427/?format=api", "priority": 100, "id": 110841427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4a64030b2e46325e", "url": "https://translations.documentfoundation.org/api/units/110841427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.132720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Naming cells and formulas" ], "previous_source": "", "target": [ "Naming cells and formulas" ], "id_hash": 1905302747077356412, "content_hash": 1905302747077356412, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id1226233\nhelp.text", "note": "ci2B9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110841462/?format=api", "priority": 100, "id": 110841462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/110841462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.148726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as \"=SUM(Start)\". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces." ], "previous_source": "", "target": [ "A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as \"=SUM(Start)\". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces." ], "id_hash": -1484430074523089168, "content_hash": -1484430074523089168, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5489364\nhelp.text", "note": "FPo7Y", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/110841498/?format=api", "priority": 100, "id": 110841498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/110841498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.161348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "For example, it is much easier to read a formula for sales tax if you can write \"= Amount * Tax_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"Tax_rate.\"" ], "previous_source": "", "target": [ "For example, it is much easier to read a formula for sales tax if you can write \"= Amount * Tax_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"Tax_rate.\"" ], "id_hash": -399800468479881712, "content_hash": -399800468479881712, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id953398\nhelp.text", "note": "aZZC8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110841529/?format=api", "priority": 100, "id": 110841529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/110841529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.172300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names," ], "previous_source": "", "target": [ "Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names," ], "id_hash": 5827339612856761597, "content_hash": 5827339612856761597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id4889675\nhelp.text", "note": "LViNz", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110841558/?format=api", "priority": 100, "id": 110841558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/110841558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.189113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears." ], "previous_source": "", "target": [ "Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears." ], "id_hash": -8630882832493047597, "content_hash": -8630882832493047597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3153954\nhelp.text", "note": "UNzu6", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110841627/?format=api", "priority": 100, "id": 110841627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/110841627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.220358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog." ], "previous_source": "", "target": [ "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog." ], "id_hash": -2987755555787780700, "content_hash": -2987755555787780700, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3156283\nhelp.text", "note": "XRBXG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110841648/?format=api", "priority": 100, "id": 110841648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/110841648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.231013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells." ], "previous_source": "", "target": [ "You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells." ], "id_hash": 5640040777354047699, "content_hash": 5640040777354047699, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5774101\nhelp.text", "note": "wehKd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110841695/?format=api", "priority": 100, "id": 110841695, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/110841695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.256294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If you type the name in a formula, after the first few characters entered you will see the entire name as a tip." ], "previous_source": "", "target": [ "If you type the name in a formula, after the first few characters entered you will see the entire name as a tip." ], "id_hash": -6183046363094129229, "content_hash": -6183046363094129229, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154942\nhelp.text", "note": "3sCdF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110841720/?format=api", "priority": 100, "id": 110841720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/110841720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.268396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Press the Enter key in order to accept the name from the tip." ], "previous_source": "", "target": [ "Press the Enter key in order to accept the name from the tip." ], "id_hash": -5008415895440623148, "content_hash": -5008415895440623148, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154510\nhelp.text", "note": "SgWa3", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110841743/?format=api", "priority": 100, "id": 110841743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/110841743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.278545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If more than one name starts with the same characters, you can scroll forward through all the names using the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab keys</keycode> and backward using the <keycode>Shift +</keycode> <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab</keycode> keys." ], "previous_source": "", "target": [ "If more than one name starts with the same characters, you can scroll forward through all the names using the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab keys</keycode> and backward using the <keycode>Shift +</keycode> <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline> <keycode>+ Tab</keycode> keys." ], "id_hash": -6286604723378817479, "content_hash": -6286604723378817479, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3150749\nhelp.text", "note": "dGV3u", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110841765/?format=api", "priority": 100, "id": 110841765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=28c17e4fdbb67639", "url": "https://translations.documentfoundation.org/api/units/110841765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.288705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<link href=\"text/scalc/01/04070100.xhp\">Sheet - Named Ranges and Expressions - Define</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04070100.xhp\">Sheet - Named Ranges and Expressions - Define</link>" ], "id_hash": -253104689169574628, "content_hash": -253104689169574628, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3153711\nhelp.text", "note": "j7cYG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110841798/?format=api", "priority": 100, "id": 110841798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7c7ccaa04f0fd51c", "url": "https://translations.documentfoundation.org/api/units/110841798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.304939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Inserting External Data in Table (WebQuery)" ], "previous_source": "", "target": [ "Inserting External Data in Table (WebQuery)" ], "id_hash": 4395953768542974508, "content_hash": 4395953768542974508, "location": "webquery.xhp", "context": "webquery.xhp\ntit\nhelp.text", "note": "tT8Ku", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110841836/?format=api", "priority": 100, "id": 110841836, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/110841836/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.317898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>HTML WebQuery</bookmark_value><bookmark_value>ranges; inserting in tables</bookmark_value><bookmark_value>external data; inserting</bookmark_value><bookmark_value>tables; inserting external data</bookmark_value><bookmark_value>web pages; importing data</bookmark_value><bookmark_value>WebQuery filter</bookmark_value><bookmark_value>inserting; external data</bookmark_value><bookmark_value>data sources; external data</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HTML WebQuery</bookmark_value><bookmark_value>ranges; inserting in tables</bookmark_value><bookmark_value>external data; inserting</bookmark_value><bookmark_value>tables; inserting external data</bookmark_value><bookmark_value>web pages; importing data</bookmark_value><bookmark_value>WebQuery filter</bookmark_value><bookmark_value>inserting; external data</bookmark_value><bookmark_value>data sources; external data</bookmark_value>" ], "id_hash": 6483911236528808730, "content_hash": 6483911236528808730, "location": "webquery.xhp", "context": "webquery.xhp\nbm_id3154346\nhelp.text", "note": "eaFpE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110841897/?format=api", "priority": 100, "id": 110841897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/110841897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.342003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"webquery\"><link href=\"text/scalc/guide/webquery.xhp\">Inserting External Data in Table (WebQuery)</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"webquery\"><link href=\"text/scalc/guide/webquery.xhp\">Inserting External Data in Table (WebQuery)</link></variable>" ], "id_hash": 5741077766394041052, "content_hash": 5741077766394041052, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3125863\nhelp.text", "note": "LzMwA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110841933/?format=api", "priority": 100, "id": 110841933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=cfac67cf9dcf52dc", "url": "https://translations.documentfoundation.org/api/units/110841933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:06.357747Z" } ] }