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=8
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=9", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=7", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "For example, if the language is set to \"Default\" and you are using a german locale setting, the currency format will be \"1.234,00 €\". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format \"$ English (US)\" from the <item type=\"menuitem\">Format</item> list box , you will get the following format: \"$ 1.234,00\". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting." ], "previous_source": "", "target": [ "For example, if the language is set to \"Default\" and you are using a German locale setting, the currency format will be \"1.234,00 €\". A dot-on-the-line is used after the thousand digits and a comma before the decimal places. If you now select the subordinate currency format \"$ English (US)\" from the <item type=\"menuitem\">Format</item> list box, you will get the following format: \"$ 1.234,00\". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting." ], "id_hash": -6926324213646934264, "content_hash": -6926324213646934264, "location": "currency_format.xhp", "context": "currency_format.xhp\npar_id3150749\nhelp.text", "note": "7b98J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 99, "source_unit": "https://translations.documentfoundation.org/api/units/24936895/?format=api", "priority": 100, "id": 1952183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1fe0c0d32e633f08", "url": "https://translations.documentfoundation.org/api/units/1952183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.241448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If, under <item type=\"menuitem\">Language</item>, you convert the cells to \"English (US)\", the English-language locale setting is also transferred and the default currency format is now \"$ 1,234.00\"." ], "previous_source": "", "target": [ "If, under <item type=\"menuitem\">Language</item>, you convert the cells to \"English (US)\", the English-language locale setting is also transferred and the default currency format is now \"$ 1,234.00\"." ], "id_hash": 7309778055375444582, "content_hash": 7309778055375444582, "location": "currency_format.xhp", "context": "currency_format.xhp\npar_id3145640\nhelp.text", "note": "MNnnJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936896/?format=api", "priority": 100, "id": 1952184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e5718c6999995a66", "url": "https://translations.documentfoundation.org/api/units/1952184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.254581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Defining Database Ranges" ], "previous_source": "", "target": [ "Defining Database Ranges" ], "id_hash": 8161635055328480313, "content_hash": 8161635055328480313, "location": "database_define.xhp", "context": "database_define.xhp\ntit\nhelp.text", "note": "QoTwd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936898/?format=api", "priority": 100, "id": 1952186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f143f3d7333acc39", "url": "https://translations.documentfoundation.org/api/units/1952186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.279952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>tables; database ranges</bookmark_value> <bookmark_value>database ranges; defining</bookmark_value> <bookmark_value>ranges; defining database ranges</bookmark_value> <bookmark_value>defining;database ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>tables; database ranges</bookmark_value><bookmark_value>database ranges; defining</bookmark_value><bookmark_value>ranges; defining database ranges</bookmark_value><bookmark_value>defining;database ranges</bookmark_value>" ], "id_hash": -3601115479747594988, "content_hash": -3601115479747594988, "location": "database_define.xhp", "context": "database_define.xhp\nbm_id3154758\nhelp.text", "note": "vjEu6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936899/?format=api", "priority": 100, "id": 1952187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4e06448cfa7bf514", "url": "https://translations.documentfoundation.org/api/units/1952187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.291759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database." ], "previous_source": "", "target": [ "You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database." ], "id_hash": -6147964892927180623, "content_hash": -6147964892927180623, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3153768\nhelp.text", "note": "4BdV5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/24936901/?format=api", "priority": 100, "id": 1952189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2aae0a80d180c0b1", "url": "https://translations.documentfoundation.org/api/units/1952189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.318312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the %PRODUCTNAME Data Sources view." ], "previous_source": "", "target": [ "You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the %PRODUCTNAME Data Sources view." ], "id_hash": -6972678064157051446, "content_hash": -6972678064157051446, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3145801\nhelp.text", "note": "YkmRD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24936902/?format=api", "priority": 100, "id": 1952190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1f3c123e54c2b5ca", "url": "https://translations.documentfoundation.org/api/units/1952190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.330384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To define a database range" ], "previous_source": "", "target": [ "To Define a Database Range" ], "id_hash": -4980107857182101692, "content_hash": -4980107857182101692, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10648\nhelp.text", "note": "7A9DZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 470, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936903/?format=api", "priority": 100, "id": 1952191, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3ae31a4a25876f44", "url": "https://translations.documentfoundation.org/api/units/1952191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.342948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Select the range of cells that you want to define as a database range." ], "previous_source": "", "target": [ "Select the range of cells that you want to define as a database range." ], "id_hash": -5716380299882385718, "content_hash": -5716380299882385718, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3155064\nhelp.text", "note": "ViixK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936904/?format=api", "priority": 100, "id": 1952192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=30ab566768782eca", "url": "https://translations.documentfoundation.org/api/units/1952192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.356790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Define Range</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Define Range</item>." ], "id_hash": -8718462659865829421, "content_hash": -8718462659865829421, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10654\nhelp.text", "note": "koZRd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936905/?format=api", "priority": 100, "id": 1952193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0701cc673b309fd3", "url": "https://translations.documentfoundation.org/api/units/1952193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.369387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Name</emph> box, enter a name for the database range." ], "previous_source": "", "target": [ "In the <emph>Name</emph> box, enter a name for the database range." ], "id_hash": 365860580262899119, "content_hash": 365860580262899119, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3153715\nhelp.text", "note": "C4Pvr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936906/?format=api", "priority": 100, "id": 1952194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=8513cc4263e36daf", "url": "https://translations.documentfoundation.org/api/units/1952194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.379407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click <emph>More</emph>." ], "previous_source": "", "target": [ "Click <emph>More</emph>." ], "id_hash": -3797940598461728499, "content_hash": -3797940598461728499, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN1066A\nhelp.text", "note": "2X6GR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936907/?format=api", "priority": 100, "id": 1952195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4b4b0125e6a7790d", "url": "https://translations.documentfoundation.org/api/units/1952195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.390478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Specify the options for the database range." ], "previous_source": "", "target": [ "Specify the options for the database range." ], "id_hash": -8982738920191813812, "content_hash": -8982738920191813812, "location": "database_define.xhp", "context": "database_define.xhp\npar_id3154253\nhelp.text", "note": "zp2Nx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936908/?format=api", "priority": 100, "id": 1952196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0356e68b6fe4174c", "url": "https://translations.documentfoundation.org/api/units/1952196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.402382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Click <emph>OK</emph>." ], "id_hash": 6797402938266597101, "content_hash": 6797402938266597101, "location": "database_define.xhp", "context": "database_define.xhp\npar_idN10675\nhelp.text", "note": "gDERf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936909/?format=api", "priority": 100, "id": 1952197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=de5539f54a93b6ed", "url": "https://translations.documentfoundation.org/api/units/1952197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.412757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Filtering Cell Ranges" ], "previous_source": "", "target": [ "Filtering Cell Ranges" ], "id_hash": 7455717594612681674, "content_hash": 7455717594612681674, "location": "database_filter.xhp", "context": "database_filter.xhp\ntit\nhelp.text", "note": "q4WSq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936910/?format=api", "priority": 100, "id": 1952198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e77807a67484cbca", "url": "https://translations.documentfoundation.org/api/units/1952198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.424357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>cell ranges;applying/removing filters</bookmark_value> <bookmark_value>filtering;cell ranges/database ranges</bookmark_value> <bookmark_value>database ranges;applying/removing filters</bookmark_value> <bookmark_value>removing;cell range filters</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>cell ranges;applying/removing filters</bookmark_value><bookmark_value>filtering;cell ranges/database ranges</bookmark_value><bookmark_value>database ranges;applying/removing filters</bookmark_value><bookmark_value>removing;cell range filters</bookmark_value>" ], "id_hash": 8596340142817540448, "content_hash": 8596340142817540448, "location": "database_filter.xhp", "context": "database_filter.xhp\nbm_id3153541\nhelp.text", "note": "DERXE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936911/?format=api", "priority": 100, "id": 1952199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f74c55d08511f960", "url": "https://translations.documentfoundation.org/api/units/1952199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.436258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells." ], "previous_source": "", "target": [ "You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells." ], "id_hash": -4490544092738168518, "content_hash": -4490544092738168518, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3145069\nhelp.text", "note": "4znQt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/24936913/?format=api", "priority": 100, "id": 1952201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=41ae61f0881cd93a", "url": "https://translations.documentfoundation.org/api/units/1952201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.461286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To Apply a Standard Filter to a Cell Range" ], "previous_source": "", "target": [ "To Apply a Standard Filter to a Cell Range" ], "id_hash": 5578512712961670346, "content_hash": 5578512712961670346, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10682\nhelp.text", "note": "e7DZH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936914/?format=api", "priority": 100, "id": 1952202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cd6adbc19714bcca", "url": "https://translations.documentfoundation.org/api/units/1952202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.474111Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click in a cell range." ], "previous_source": "", "target": [ "Click in a cell range." ], "id_hash": -781988736639477845, "content_hash": -781988736639477845, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3150398\nhelp.text", "note": "SiEGx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936915/?format=api", "priority": 100, "id": 1952203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7525d1631e3f57ab", "url": "https://translations.documentfoundation.org/api/units/1952203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.486395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - More Filters - Standard Filter</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - More Filters - Standard Filter</item>." ], "id_hash": 5808399452450022911, "content_hash": 5808399452450022911, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10693\nhelp.text", "note": "WG4wc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936916/?format=api", "priority": 100, "id": 1952204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d09b94871cdb65ff", "url": "https://translations.documentfoundation.org/api/units/1952204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.499329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "In the <emph>Standard Filter</emph> dialog, specify the filter options that you want." ], "previous_source": "", "target": [ "In the <emph>Standard Filter</emph> dialogue box, specify the filter options that you want." ], "id_hash": 1534539389418284111, "content_hash": 1534539389418284111, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3156422\nhelp.text", "note": "Hxxpj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936917/?format=api", "priority": 100, "id": 1952205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=954bc771c01f244f", "url": "https://translations.documentfoundation.org/api/units/1952205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.512213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Click <emph>OK</emph>." ], "id_hash": 7457560869786805481, "content_hash": 7457560869786805481, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106A5\nhelp.text", "note": "vcg5k", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936918/?format=api", "priority": 100, "id": 1952206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e77e9419667ee4e9", "url": "https://translations.documentfoundation.org/api/units/1952206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.524430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The records that match the filter options that you specified are shown." ], "previous_source": "", "target": [ "The records that match the filter options that you specified are shown." ], "id_hash": -242174767239507446, "content_hash": -242174767239507446, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153143\nhelp.text", "note": "qmFD9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936919/?format=api", "priority": 100, "id": 1952207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7ca39f551120520a", "url": "https://translations.documentfoundation.org/api/units/1952207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.536691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To Apply an AutoFilter to a Cell Range" ], "previous_source": "", "target": [ "To Apply an AutoFilter to a Cell Range" ], "id_hash": -8482260120029773788, "content_hash": -8482260120029773788, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153728\nhelp.text", "note": "zUCBf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936920/?format=api", "priority": 100, "id": 1952208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0a48f55c9d29c024", "url": "https://translations.documentfoundation.org/api/units/1952208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.548537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click in a cell range or a database range." ], "previous_source": "", "target": [ "Click in a cell range or a database range." ], "id_hash": -7248638314472881967, "content_hash": -7248638314472881967, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3144764\nhelp.text", "note": "tqAMd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936921/?format=api", "priority": 100, "id": 1952209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1b67a9dba08ec0d1", "url": "https://translations.documentfoundation.org/api/units/1952209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.560661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If you want to apply multiple AutoFilters to the same sheet, you must first define database ranges, then apply the AutoFilters to the database ranges." ], "previous_source": "", "target": [ "If you want to apply multiple AutoFilters to the same sheet, you must first define database ranges, then apply the AutoFilters to the database ranges." ], "id_hash": -14938434316189351, "content_hash": -14938434316189351, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id9303872\nhelp.text", "note": "EFRDW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24936922/?format=api", "priority": 100, "id": 1952210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7fcaed92b9154159", "url": "https://translations.documentfoundation.org/api/units/1952210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.573239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - AutoFilter</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - AutoFilter</item>." ], "id_hash": 3378529364349136589, "content_hash": 3378529364349136589, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3154944\nhelp.text", "note": "ayGC2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936923/?format=api", "priority": 100, "id": 1952211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=aee2f28e8141aecd", "url": "https://translations.documentfoundation.org/api/units/1952211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.588729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "An arrow button is added to the head of each column in the database range." ], "previous_source": "", "target": [ "An arrow button is added to the head of each column in the database range." ], "id_hash": 1785195128466246270, "content_hash": 1785195128466246270, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106DB\nhelp.text", "note": "8jfFs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936924/?format=api", "priority": 100, "id": 1952212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=98c64982cefd0a7e", "url": "https://translations.documentfoundation.org/api/units/1952212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.599824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click the arrow button in the column that contains the value or string that you want to set as the filter criteria." ], "previous_source": "", "target": [ "Click the arrow button in the column that contains the value or string that you want to set as the filter criteria." ], "id_hash": -7524984236917080831, "content_hash": -7524984236917080831, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_id3153878\nhelp.text", "note": "buscD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24936925/?format=api", "priority": 100, "id": 1952213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1791e2b4a224bd01", "url": "https://translations.documentfoundation.org/api/units/1952213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.611722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Select the value or string that you want to use as the filter criteria." ], "previous_source": "", "target": [ "Select the value or string that you want to use as the filter criteria." ], "id_hash": -6159115828387426799, "content_hash": -6159115828387426799, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN10749\nhelp.text", "note": "vFUzG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936926/?format=api", "priority": 100, "id": 1952214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2a866cc9567b4e11", "url": "https://translations.documentfoundation.org/api/units/1952214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.623313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The records that match the filter criteria that you selected are shown." ], "previous_source": "", "target": [ "The records that match the filter criteria that you selected are shown." ], "id_hash": 2406891623540612906, "content_hash": 2406891623540612906, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN1074C\nhelp.text", "note": "H4Cqe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936927/?format=api", "priority": 100, "id": 1952215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a166ff2dea005f2a", "url": "https://translations.documentfoundation.org/api/units/1952215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.636025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "To Remove a Filter From a Cell Range" ], "previous_source": "", "target": [ "To Remove a Filter From a Cell Range" ], "id_hash": -4190959145163739741, "content_hash": -4190959145163739741, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106E8\nhelp.text", "note": "fkmqA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936928/?format=api", "priority": 100, "id": 1952216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=45d6b8dcb4572da3", "url": "https://translations.documentfoundation.org/api/units/1952216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.649061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click in a filtered cell range." ], "previous_source": "", "target": [ "Click in a filtered cell range." ], "id_hash": 5281635393044491942, "content_hash": 5281635393044491942, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN1075C\nhelp.text", "note": "85fDm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936929/?format=api", "priority": 100, "id": 1952217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c94c23681b8c2ea6", "url": "https://translations.documentfoundation.org/api/units/1952217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.663431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Filter - Reset Filter</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Filter - Reset Filter</item>." ], "id_hash": -1143336285952618008, "content_hash": -1143336285952618008, "location": "database_filter.xhp", "context": "database_filter.xhp\npar_idN106EC\nhelp.text", "note": "H7icE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936930/?format=api", "priority": 100, "id": 1952218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=70220db4a0fad1e8", "url": "https://translations.documentfoundation.org/api/units/1952218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.678225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Sorting Data" ], "previous_source": "", "target": [ "Sorting Data" ], "id_hash": -1678035711575406533, "content_hash": -1678035711575406533, "location": "database_sort.xhp", "context": "database_sort.xhp\ntit\nhelp.text", "note": "ueLu8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936932/?format=api", "priority": 100, "id": 1952220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=68b66b693320c83b", "url": "https://translations.documentfoundation.org/api/units/1952220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.714569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>database ranges; sorting</bookmark_value> <bookmark_value>sorting; database ranges</bookmark_value> <bookmark_value>data;sorting in databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>database ranges; sorting</bookmark_value><bookmark_value>sorting; database ranges</bookmark_value><bookmark_value>data;sorting in databases</bookmark_value>" ], "id_hash": 1824297674026058534, "content_hash": 1824297674026058534, "location": "database_sort.xhp", "context": "database_sort.xhp\nbm_id3150767\nhelp.text", "note": "qvJdv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936933/?format=api", "priority": 100, "id": 1952221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=99513511a8e50326", "url": "https://translations.documentfoundation.org/api/units/1952221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.728062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click in a database range." ], "previous_source": "", "target": [ "Click in a database range." ], "id_hash": -6892889147954750633, "content_hash": -6892889147954750633, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id3145751\nhelp.text", "note": "vddXD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936935/?format=api", "priority": 100, "id": 1952223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=205789d70c031b57", "url": "https://translations.documentfoundation.org/api/units/1952223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.752621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted." ], "previous_source": "", "target": [ "If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted." ], "id_hash": -7684388754638796622, "content_hash": -7684388754638796622, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121549\nhelp.text", "note": "BjSBG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936936/?format=api", "priority": 100, "id": 1952224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=155b91242bbf88b2", "url": "https://translations.documentfoundation.org/api/units/1952224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.763775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Sort</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Sort</item>." ], "id_hash": -6575395747031862181, "content_hash": -6575395747031862181, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN10635\nhelp.text", "note": "LpURK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936937/?format=api", "priority": 100, "id": 1952225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=24bf8067f08d345b", "url": "https://translations.documentfoundation.org/api/units/1952225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.774789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The range of cells that will get sorted is shown in inverted colors." ], "previous_source": "", "target": [ "The range of cells that will get sorted is shown in inverted colours." ], "id_hash": -8960912715893032440, "content_hash": -8960912715893032440, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_id121020081121547\nhelp.text", "note": "t46AF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936938/?format=api", "priority": 100, "id": 1952226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=03a4715ca1ea3a08", "url": "https://translations.documentfoundation.org/api/units/1952226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.786334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Click <emph>OK</emph>." ], "id_hash": 7116653827745536730, "content_hash": 7116653827745536730, "location": "database_sort.xhp", "context": "database_sort.xhp\npar_idN1063D\nhelp.text", "note": "dxfCa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936940/?format=api", "priority": 100, "id": 1952228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e2c36ef360325ada", "url": "https://translations.documentfoundation.org/api/units/1952228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.812841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Pivot Table" ], "previous_source": "", "target": [ "Pivot Table" ], "id_hash": 634472502535055328, "content_hash": 634472502535055328, "location": "datapilot.xhp", "context": "datapilot.xhp\ntit\nhelp.text", "note": "zsSK8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936942/?format=api", "priority": 100, "id": 1952230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=88ce1961255ae7e0", "url": "https://translations.documentfoundation.org/api/units/1952230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.836152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>pivot table function; introduction</bookmark_value><bookmark_value>DataPilot, see pivot table function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot table function; introduction</bookmark_value><bookmark_value>DataPilot, see pivot table function</bookmark_value>" ], "id_hash": 208459899671545873, "content_hash": 208459899671545873, "location": "datapilot.xhp", "context": "datapilot.xhp\nbm_id3150448\nhelp.text", "note": "q3UkA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936943/?format=api", "priority": 100, "id": 1952231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=82e4992c9dd60811", "url": "https://translations.documentfoundation.org/api/units/1952231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.847003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports." ], "previous_source": "", "target": [ "The <emph>pivot table</emph> (formerly known as <emph>DataPilot</emph>) allows you to combine, compare, and analyse large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports." ], "id_hash": -2698616069608549419, "content_hash": -2698616069608549419, "location": "datapilot.xhp", "context": "datapilot.xhp\npar_id3156024\nhelp.text", "note": "X3qFY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24936945/?format=api", "priority": 100, "id": 1952233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5a8c96fb89d253d5", "url": "https://translations.documentfoundation.org/api/units/1952233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.871131Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Creating Pivot Tables" ], "previous_source": "", "target": [ "Creating Pivot Tables" ], "id_hash": 7178156368634310857, "content_hash": 7178156368634310857, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\ntit\nhelp.text", "note": "cGChV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936947/?format=api", "priority": 100, "id": 1952235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e39def2f8ea7f0c9", "url": "https://translations.documentfoundation.org/api/units/1952235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.896258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>pivot tables</bookmark_value> <bookmark_value>pivot table function; calling up and applying</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot tables</bookmark_value> <bookmark_value>pivot table function; calling up and applying</bookmark_value>" ], "id_hash": -7880776485035476364, "content_hash": -7880776485035476364, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\nbm_id3148491\nhelp.text", "note": "kEK57", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936948/?format=api", "priority": 100, "id": 1952236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=12a1db8a7f357a74", "url": "https://translations.documentfoundation.org/api/units/1952236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.905544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Position the cursor within a range of cells containing values, row and column headings." ], "previous_source": "", "target": [ "Position the cursor within a range of cells containing values, row and column headings." ], "id_hash": 4946745694602108261, "content_hash": 4946745694602108261, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156023\nhelp.text", "note": "qrneD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936950/?format=api", "priority": 100, "id": 1952238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c4a65f0010f39d65", "url": "https://translations.documentfoundation.org/api/units/1952238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.928097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Drag the desired buttons into one of the four areas." ], "previous_source": "", "target": [ "Drag the desired buttons into one of the four areas." ], "id_hash": 7476088695115802925, "content_hash": 7476088695115802925, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150868\nhelp.text", "note": "XR8Sd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936952/?format=api", "priority": 100, "id": 1952240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e7c0670ee5b0e92d", "url": "https://translations.documentfoundation.org/api/units/1952240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.949029Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data." ], "previous_source": "", "target": [ "If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data." ], "id_hash": 1622151538385423318, "content_hash": 1622151538385423318, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3154011\nhelp.text", "note": "vFX84", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936954/?format=api", "priority": 100, "id": 1952242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=96830a3ac9510bd6", "url": "https://translations.documentfoundation.org/api/units/1952242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.972360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Use the <item type=\"menuitem\">Data Field</item> dialog to select the calculations to be used for the data. To make a multiple selection, press the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while clicking the desired calculation." ], "previous_source": "", "target": [ "Use the <item type=\"menuitem\">Data Field</item> dialog to select the calculations to be used for the data. To make a multiple selection, press the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key while clicking the desired calculation." ], "id_hash": -7996044650938525023, "content_hash": -7996044650938525023, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3156286\nhelp.text", "note": "PAuDC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24936956/?format=api", "priority": 100, "id": 1952244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=110857c13ca59aa1", "url": "https://translations.documentfoundation.org/api/units/1952244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:45.994196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse." ], "previous_source": "", "target": [ "The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse." ], "id_hash": -4781468655574914518, "content_hash": -4781468655574914518, "location": "datapilot_createtable.xhp", "context": "datapilot_createtable.xhp\npar_id3150329\nhelp.text", "note": "AniFD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936957/?format=api", "priority": 100, "id": 1952245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3da4cf974fcaea2a", "url": "https://translations.documentfoundation.org/api/units/1952245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:46.005874Z" } ] }{ "count": 1559, "next": "