Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=24
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=25", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=23", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/25118383/?format=api", "priority": 100, "id": 24739821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c40603b005d84fbf", "url": "https://translations.documentfoundation.org/api/units/24739821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-12-17T14:17:45.207599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href=\"text/shared/optionen/01060900.xhp\">Formula options page</link>." ], "previous_source": "", "target": [ "The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on <link href=\"text/shared/optionen/01060900.xhp\">Formula options page</link>." ], "id_hash": 5635765534138239972, "content_hash": 5635765534138239972, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id3147383\nhelp.text", "note": "7thQw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/25119166/?format=api", "priority": 100, "id": 24839067, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ce3642e4cbb30be4", "url": "https://translations.documentfoundation.org/api/units/24839067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-01-17T19:17:54.103140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function." ], "previous_source": "", "target": [ "The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function." ], "id_hash": 6549582188000742820, "content_hash": 6549582188000742820, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id891567607263849\nhelp.text", "note": "MLL7F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/25119381/?format=api", "priority": 100, "id": 24861851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=dae4ca4c7f028da4", "url": "https://translations.documentfoundation.org/api/units/24861851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-02-10T20:29:49.186945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">what-if sheet area</alt></image>" ], "previous_source": "", "target": [ "<image id=\"img_id1621753\" src=\"media/helpimg/what-if.png\"><alt id=\"alt_id1621753\">what-if sheet area</alt></image>" ], "id_hash": 8700810810400914435, "content_hash": 8700810810400914435, "location": "multioperation.xhp", "context": "multioperation.xhp\npar_id6478774\nhelp.text", "note": "vdeBS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/25134521/?format=api", "priority": 100, "id": 25134539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f8bf7d554bd33c03", "url": "https://translations.documentfoundation.org/api/units/25134539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-02-27T14:14:29.505820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Using Subtotals Tool" ], "previous_source": "", "target": [ "Using Subtotals Tool" ], "id_hash": 7533233722582203021, "content_hash": 7533233722582203021, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\ntit\nhelp.text", "note": "jQ6bn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1337, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/25237671/?format=api", "priority": 100, "id": 25238012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e88b6c286c817a8d", "url": "https://translations.documentfoundation.org/api/units/25238012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.977832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>subtotals;using subtotals tool</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>subtotals;using subtotals tool</bookmark_value>" ], "id_hash": 3949916786312185341, "content_hash": 3949916786312185341, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nbm_id521585182060496\nhelp.text", "note": "aKjYH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1338, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/25237673/?format=api", "priority": 100, "id": 25238013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b6d0ec63bc7d85fd", "url": "https://translations.documentfoundation.org/api/units/25238013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.979188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Using the Subtotals tool" ], "previous_source": "", "target": [ "Using the Subtotals tool" ], "id_hash": 3708895243280421151, "content_hash": 3708895243280421151, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id891585177511329\nhelp.text", "note": "NEkbi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/25237679/?format=api", "priority": 100, "id": 25238016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b378a492bcdd911f", "url": "https://translations.documentfoundation.org/api/units/25238016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.983075Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To insert subtotal values into a worksheet:" ], "previous_source": "", "target": [ "To insert subtotal values into a worksheet:" ], "id_hash": -6503939318800028129, "content_hash": -6503939318800028129, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id91585177517697\nhelp.text", "note": "kwLkR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/25237681/?format=api", "priority": 100, "id": 25238017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=25bd5da61e3a6e1f", "url": "https://translations.documentfoundation.org/api/units/25238017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.984339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range." ], "previous_source": "", "target": [ "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range." ], "id_hash": 1676165077590547897, "content_hash": 1676165077590547897, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id241585177550504\nhelp.text", "note": "DKZ3o", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1343, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/25237683/?format=api", "priority": 100, "id": 25238018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9742ef41e2b31db9", "url": "https://translations.documentfoundation.org/api/units/25238018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.985603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Subtotal outline" ], "previous_source": "", "target": [ "Subtotal outline" ], "id_hash": 6090414715338233155, "content_hash": 6090414715338233155, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id211585178799496\nhelp.text", "note": "iMTer", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/25237699/?format=api", "priority": 100, "id": 25238026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d4857fea4a8c1543", "url": "https://translations.documentfoundation.org/api/units/25238026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:03.998196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. This outline represents the hierarchical structure of your subtotals, and can be used to hide or show data at different levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators, denoted by plus <emph>(+)</emph> and minus <emph>(-)</emph> signs." ], "previous_source": "", "target": [ "When you use the Subtotals tool, Calc inserts an outline to the left of the row number column. This outline represents the hierarchical structure of your subtotals, and can be used to hide or show data at different levels in the hierarchy using the numbered column indicators at the top of the outline or the group indicators, denoted by plus <emph>(+)</emph> and minus <emph>(-)</emph> signs." ], "id_hash": -568020531173484, "content_hash": -568020531173484, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id841585178819108\nhelp.text", "note": "35yNv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1352, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/25237701/?format=api", "priority": 100, "id": 25238027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7ffdfb636a03a794", "url": "https://translations.documentfoundation.org/api/units/25238027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:04.000646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data." ], "previous_source": "", "target": [ "This feature is useful if you have many subtotals, as you can simply hide low-level details, such as individual entries, to produce a high-level summary of your data." ], "id_hash": -7505542518909688937, "content_hash": -7505542518909688937, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id371585181820075\nhelp.text", "note": "EhreW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1353, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/25237703/?format=api", "priority": 100, "id": 25238028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=17d6f4d859cc2397", "url": "https://translations.documentfoundation.org/api/units/25238028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-03-31T09:19:04.002670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog." ], "previous_source": "", "target": [ "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialogue box." ], "id_hash": -6297832789348154293, "content_hash": -6297832789348154293, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id421585177574387\nhelp.text", "note": "QiBqE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/25361596/?format=api", "priority": 100, "id": 25361748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=28999a720818844b", "url": "https://translations.documentfoundation.org/api/units/25361748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.504143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column." ], "previous_source": "", "target": [ "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column." ], "id_hash": -6353680389445522381, "content_hash": -6353680389445522381, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id41585177608508\nhelp.text", "note": "BwAst", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/25361598/?format=api", "priority": 100, "id": 25361749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=27d331595abbec33", "url": "https://translations.documentfoundation.org/api/units/25361749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.506270Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals." ], "previous_source": "", "target": [ "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals." ], "id_hash": 5461938802686026943, "content_hash": 5461938802686026943, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id451585177625978\nhelp.text", "note": "QmNL9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/25361600/?format=api", "priority": 100, "id": 25361750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cbccb4670705e4bf", "url": "https://translations.documentfoundation.org/api/units/25361750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.507691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4." ], "previous_source": "", "target": [ "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4." ], "id_hash": 3549048077078569758, "content_hash": 3549048077078569758, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id661585177644535\nhelp.text", "note": "CQ9km", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/25361602/?format=api", "priority": 100, "id": 25361751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b140c06c250d231e", "url": "https://translations.documentfoundation.org/api/units/25361751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.509085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page." ], "previous_source": "", "target": [ "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page." ], "id_hash": 2291410142773376334, "content_hash": 2291410142773376334, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id351585177661529\nhelp.text", "note": "3eTTE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1348, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/25361604/?format=api", "priority": 100, "id": 25361752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9fccb9626abbf54e", "url": "https://translations.documentfoundation.org/api/units/25361752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.510494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”." ], "previous_source": "", "target": [ "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”." ], "id_hash": 2159292982110408392, "content_hash": 2159292982110408392, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id511585177679372\nhelp.text", "note": "6GLDr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/25361606/?format=api", "priority": 100, "id": 25361753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9df75986dcaf4ec8", "url": "https://translations.documentfoundation.org/api/units/25361753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.512076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range." ], "previous_source": "", "target": [ "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range." ], "id_hash": 3137595891275628965, "content_hash": 3137595891275628965, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id301585177698777\nhelp.text", "note": "HDB52", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/25361608/?format=api", "priority": 100, "id": 25361754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ab8afad6e43581a5", "url": "https://translations.documentfoundation.org/api/units/25361754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.513467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To turn off outlines, choose <menuitem>Data - Group and Outline - Remove Outline</menuitem>. To reinstate them, choose <menuitem>Data - Group and Outline - AutoOutline</menuitem>." ], "previous_source": "", "target": [ "To turn off outlines, choose <menuitem>Data - Group and Outline - Remove Outline</menuitem>. To reinstate them, choose <menuitem>Data - Group and Outline - AutoOutline</menuitem>." ], "id_hash": 8904710006161034039, "content_hash": 8904710006161034039, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id161585178829165\nhelp.text", "note": "C97jN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/25361610/?format=api", "priority": 100, "id": 25361755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=fb93e29249184b37", "url": "https://translations.documentfoundation.org/api/units/25361755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-04-27T14:50:10.515021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <emph>Filter</emph> box" ], "previous_source": "", "target": [ "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <emph>Filter</emph> box" ], "id_hash": 4340216753632992001, "content_hash": 4340216753632992001, "location": "csv_files.xhp", "context": "csv_files.xhp\npar_idN108A5\nhelp.text", "note": "DQq7Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 409, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/25534830/?format=api", "priority": 100, "id": 25534868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=bc3b8c24587e5b01", "url": "https://translations.documentfoundation.org/api/units/25534868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-06-29T11:50:30.046117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Filter</emph> box, select \"Text CSV\"." ], "previous_source": "", "target": [ "In the <emph>Filter</emph> box, select \"Text CSV\"." ], "id_hash": -3893382888196213841, "content_hash": -3893382888196213841, "location": "csv_files.xhp", "context": "csv_files.xhp\npar_idN1090D\nhelp.text", "note": "EDhEz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 423, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/25534832/?format=api", "priority": 100, "id": 25534869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=49f7ece4267af3af", "url": "https://translations.documentfoundation.org/api/units/25534869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-06-29T11:50:30.048669Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>spreadsheets; backgrounds</bookmark_value><bookmark_value>backgrounds;cell ranges</bookmark_value><bookmark_value>tables; backgrounds</bookmark_value><bookmark_value>cells; backgrounds</bookmark_value><bookmark_value>rows, see also cells</bookmark_value><bookmark_value>columns, see also cells</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>spreadsheets; backgrounds</bookmark_value><bookmark_value>backgrounds;cell ranges</bookmark_value><bookmark_value>tables; backgrounds</bookmark_value><bookmark_value>cells; backgrounds</bookmark_value><bookmark_value>rows, see also cells</bookmark_value><bookmark_value>columns, see also cells</bookmark_value>" ], "id_hash": -7887410446915615841, "content_hash": -7887410446915615841, "location": "background.xhp", "context": "background.xhp\nbm_id3149346\nhelp.text", "note": "PE8wQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 66, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/35448470/?format=api", "priority": 100, "id": 35449039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=128a49fce1e3c39f", "url": "https://translations.documentfoundation.org/api/units/35449039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-10-27T13:40:57.738101Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. These symbols are included in searches when the Formatted Display search option is activated." ], "previous_source": "", "target": [ "Cell contents can be formatted in different ways. For example, a number can be formatted as a currency, to be displayed with a currency symbol. These symbols are included in searches when the Formatted Display search option is activated." ], "id_hash": 1378078491271801845, "content_hash": 1378078491271801845, "location": "finding.xhp", "context": "finding.xhp\npar_id3163853\nhelp.text", "note": "FMaXJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 665, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/35448478/?format=api", "priority": 100, "id": 35449043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=931feb1620dcabf5", "url": "https://translations.documentfoundation.org/api/units/35449043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-10-27T13:40:57.837044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <menuitem>Tools - Macros - Edit Macros</menuitem>." ], "previous_source": "", "target": [ "" ], "id_hash": -8738067899725167142, "content_hash": -8738067899725167142, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148456\nhelp.text", "note": "PfDpb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1434, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/35750441/?format=api", "priority": 100, "id": 35750555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=06bc258a9da345da", "url": "https://translations.documentfoundation.org/api/units/35750555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.777721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You will now see the Basic IDE." ], "previous_source": "", "target": [ "" ], "id_hash": 2164351164243756283, "content_hash": 2164351164243756283, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3154510\nhelp.text", "note": "N4uB4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/35750443/?format=api", "priority": 100, "id": 35750556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9e0951eaa9f3c4fb", "url": "https://translations.documentfoundation.org/api/units/35750556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.780525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the Object Catalog window, double-click on the module where you want to store your macro." ], "previous_source": "", "target": [ "" ], "id_hash": -4868472982260398586, "content_hash": -4868472982260398586, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id651603905832952\nhelp.text", "note": "jXhZH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1436, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/35750445/?format=api", "priority": 100, "id": 35750557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3c6fb59dedc84606", "url": "https://translations.documentfoundation.org/api/units/35750557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.782797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Your function is automatically saved in the selected module and is now available. If you apply the function in a Calc document that is to be used on another computer, you can copy the function to the Calc document as described in the next section." ], "previous_source": "", "target": [ "" ], "id_hash": -1618214778792234398, "content_hash": -1618214778792234398, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3150043\nhelp.text", "note": "nWiEx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1439, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/35750447/?format=api", "priority": 100, "id": 35750558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=698af23b7bcd3262", "url": "https://translations.documentfoundation.org/api/units/35750558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.788826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <menuitem>Tools - Macros - Organize Macros - Basic</menuitem>." ], "previous_source": "", "target": [ "Choose <menuitem>Tools - Macros - Organise Macros - Basic</menuitem>." ], "id_hash": -7108779031549721253, "content_hash": -7108779031549721253, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3150304\nhelp.text", "note": "FiJEi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1443, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/35750449/?format=api", "priority": 100, "id": 35750559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1d588b227dbbc55b", "url": "https://translations.documentfoundation.org/api/units/35750559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.797016Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <menuitem>Tools - Macros - Organize Macros - Basic</menuitem> ." ], "previous_source": "", "target": [ "Choose <menuitem>Tools - Macros - Organise Macros - Basic</menuitem> ." ], "id_hash": 8517532025872751160, "content_hash": 8517532025872751160, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3150517\nhelp.text", "note": "rYyws", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1447, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/35750451/?format=api", "priority": 100, "id": 35750560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f6345a3fed289a38", "url": "https://translations.documentfoundation.org/api/units/35750560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-11-03T14:06:58.805258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">View - Freeze Rows and Columns</item>." ], "previous_source": "", "target": [ "" ], "id_hash": -1338173655184767692, "content_hash": -1338173655184767692, "location": "line_fix.xhp", "context": "line_fix.xhp\npar_id3156286\nhelp.text", "note": "Ly3Ez", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 872, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/35783010/?format=api", "priority": 100, "id": 35783067, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=6d6dda268aed0534", "url": "https://translations.documentfoundation.org/api/units/35783067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-01T12:12:01.573571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To deactivate, choose <item type=\"menuitem\">View - Freeze Rows and Columns</item> again." ], "previous_source": "", "target": [ "" ], "id_hash": 1422255886221588993, "content_hash": 1422255886221588993, "location": "line_fix.xhp", "context": "line_fix.xhp\npar_id3151073\nhelp.text", "note": "Exqyb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 873, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/35783012/?format=api", "priority": 100, "id": 35783068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=93bcde316df23a01", "url": "https://translations.documentfoundation.org/api/units/35783068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-01T12:12:01.576073Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Setting sheet names is an important feature to produce readable and understandable spreadsheets documents." ], "previous_source": "", "target": [ "" ], "id_hash": 5025711155935405782, "content_hash": 5025711155935405782, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id701519308848244\nhelp.text", "note": "zEnG4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1227, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/35790510/?format=api", "priority": 100, "id": 35790900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c5bee9ab413f66d6", "url": "https://translations.documentfoundation.org/api/units/35790900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.885726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To rename a sheet in your document:" ], "previous_source": "", "target": [ "" ], "id_hash": 4228818704829464792, "content_hash": 4228818704829464792, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id471607437423400\nhelp.text", "note": "rMuCd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1229, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/35790512/?format=api", "priority": 100, "id": 35790901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=baafc834f0e340d8", "url": "https://translations.documentfoundation.org/api/units/35790901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.890407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Double-click the sheet tab or open its context menu and choose <menuitem>Rename Sheet</menuitem>. A dialog box appears where you can enter a new name." ], "previous_source": "", "target": [ "Double-click the sheet tab or open its context menu and choose <menuitem>Rename Sheet</menuitem>. A dialogue box appears where you can enter a new name." ], "id_hash": -7789083530586621168, "content_hash": -7789083530586621168, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id3146976\nhelp.text", "note": "99JMV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1230, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/35790514/?format=api", "priority": 100, "id": 35790902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=13e79dcc1989fb10", "url": "https://translations.documentfoundation.org/api/units/35790902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.892733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Sheet Naming Restrictions" ], "previous_source": "", "target": [ "" ], "id_hash": 1939883387502329290, "content_hash": 1939883387502329290, "location": "rename_table.xhp", "context": "rename_table.xhp\nhd_id541607437294635\nhelp.text", "note": "VDtVj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1234, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/35790516/?format=api", "priority": 100, "id": 35790903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9aebd9a9b9c1fdca", "url": "https://translations.documentfoundation.org/api/units/35790903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.901135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "colon <literal>:</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": 3664074778937617630, "content_hash": 3664074778937617630, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id090920081050281\nhelp.text", "note": "GW256", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1236, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/35790518/?format=api", "priority": 100, "id": 35790904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b2d968992d0b6cde", "url": "https://translations.documentfoundation.org/api/units/35790904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.905840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "back slash <literal>\\</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": 3637833413759517198, "content_hash": 3637833413759517198, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id0909200810502897\nhelp.text", "note": "a2JXE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1237, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/35790520/?format=api", "priority": 100, "id": 35790905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b27c2e373b2ec20e", "url": "https://translations.documentfoundation.org/api/units/35790905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.908594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "forward slash <literal>/</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": 8183294228505815281, "content_hash": 8183294228505815281, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id090920081050299\nhelp.text", "note": "mkHAC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1238, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/35790522/?format=api", "priority": 100, "id": 35790906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f190e6be6e97e8f1", "url": "https://translations.documentfoundation.org/api/units/35790906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.911365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "question mark <literal>?</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": 1566759416744583977, "content_hash": 1566759416744583977, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id0909200810502913\nhelp.text", "note": "V9Z6i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1239, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/35790524/?format=api", "priority": 100, "id": 35790907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=95be3f63738f2329", "url": "https://translations.documentfoundation.org/api/units/35790907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.913704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "asterisk <literal>*</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": -7108447397395319160, "content_hash": -7108447397395319160, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id090920081050298\nhelp.text", "note": "42B5r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1240, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/35790526/?format=api", "priority": 100, "id": 35790908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1d59b8c115b3b688", "url": "https://translations.documentfoundation.org/api/units/35790908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.915801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "left square bracket <literal>[</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": -4270229100679493296, "content_hash": -4270229100679493296, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id0909200810502969\nhelp.text", "note": "sAMTR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1241, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/35790528/?format=api", "priority": 100, "id": 35790909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=44bd1941f0768950", "url": "https://translations.documentfoundation.org/api/units/35790909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.917869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "right square bracket <literal>]</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": 5403507268658454556, "content_hash": 5403507268658454556, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id0909200810502910\nhelp.text", "note": "32rAi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1242, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/35790530/?format=api", "priority": 100, "id": 35790910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cafd1d3b59a0e01c", "url": "https://translations.documentfoundation.org/api/units/35790910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.919899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "single quote <literal>'</literal> as the first or last character of the name" ], "previous_source": "", "target": [ "" ], "id_hash": -5237003266249067801, "content_hash": -5237003266249067801, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id0909200810502971\nhelp.text", "note": "ESD5B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1243, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/35790532/?format=api", "priority": 100, "id": 35790911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=37526d46b3a9f2e7", "url": "https://translations.documentfoundation.org/api/units/35790911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.921964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The single quote is Unicode <literal>U+0027</literal>, also known as <literal>apostrophe</literal>. Other single-quote characters, similar to <literal>apostrophe</literal>, are allowed, such as <literal>ʼ</literal> <literal>‛</literal> and <literal>‚</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 6209452499550136586, "content_hash": 6209452499550136586, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id761607437686157\nhelp.text", "note": "36nvo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1244, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/35790534/?format=api", "priority": 100, "id": 35790912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d62c68263558e90a", "url": "https://translations.documentfoundation.org/api/units/35790912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.924018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Using a Default Prefix for Sheet Names" ], "previous_source": "", "target": [ "" ], "id_hash": 5471025478881541636, "content_hash": 5471025478881541636, "location": "rename_table.xhp", "context": "rename_table.xhp\nhd_id251607438968588\nhelp.text", "note": "DMm29", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1245, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/35790536/?format=api", "priority": 100, "id": 35790913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cbecfcafb1d87e04", "url": "https://translations.documentfoundation.org/api/units/35790913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.926141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You can set a prefix for the names of new sheets you create. Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Defaults</menuitem> and enter the prefix name in <emph>Prefix name for new worksheet</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 7098701769172685043, "content_hash": 7098701769172685043, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id81519309108908\nhelp.text", "note": "MEc8r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1246, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/35790538/?format=api", "priority": 100, "id": 35790914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e283a7a605f990f3", "url": "https://translations.documentfoundation.org/api/units/35790914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.928511Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Referencing Sheet Names with Special Characters" ], "previous_source": "", "target": [ "" ], "id_hash": 4208140378969717101, "content_hash": 4208140378969717101, "location": "rename_table.xhp", "context": "rename_table.xhp\nhd_id821607437571713\nhelp.text", "note": "Ev9Ae", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1247, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/35790540/?format=api", "priority": 100, "id": 35790915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ba6651610577b96d", "url": "https://translations.documentfoundation.org/api/units/35790915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.931099Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In cell references, a sheet name must be enclosed in single quotes <literal>'</literal> when the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes)." ], "previous_source": "", "target": [ "" ], "id_hash": 5087795171748113480, "content_hash": 5087795171748113480, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id090920081050307\nhelp.text", "note": "BAZ4z", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1248, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/35790542/?format=api", "priority": 100, "id": 35790916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c69b7ac09dfe6c48", "url": "https://translations.documentfoundation.org/api/units/35790916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.934000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "For example, you want to reference the <literal>cell A1</literal> on a sheet named <literal>This year's sheet</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 6956824807927447618, "content_hash": 6956824807927447618, "location": "rename_table.xhp", "context": "rename_table.xhp\npar_id321519307869857\nhelp.text", "note": "ZjbDT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1249, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/35790544/?format=api", "priority": 100, "id": 35790917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e08b9b4dd1240042", "url": "https://translations.documentfoundation.org/api/units/35790917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2020-12-14T15:04:50.936917Z" } ] }{ "count": 1559, "next": "