Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=12
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=13", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/units/?format=api&page=11", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Show only the current item</item> button to show only the selected field member. All other field members are hidden in the pivot table." ], "previous_source": "", "target": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Show only the current item</item> button to show only the selected field member. All other field members are hidden in the pivot table." ], "id_hash": 7497645380392457234, "content_hash": 7497645380392457234, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344431\nhelp.text", "note": "SKUBa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110808434/?format=api", "priority": 100, "id": 110808434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e80cfcbfce241412", "url": "https://translations.documentfoundation.org/api/units/110808434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.239611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Hide only the current item</item> button to hide only the selected field member. All other field members are shown in the pivot table." ], "previous_source": "", "target": [ "Select a field member in the pop-up window and click the <item type=\"menuitem\">Hide only the current item</item> button to hide only the selected field member. All other field members are shown in the pivot table." ], "id_hash": -3961528024547314001, "content_hash": -3961528024547314001, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344484\nhelp.text", "note": "BMRWS", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110808492/?format=api", "priority": 100, "id": 110808492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=4905d340311a36af", "url": "https://translations.documentfoundation.org/api/units/110808492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.276508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list." ], "previous_source": "", "target": [ "Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list." ], "id_hash": 6398235513205658305, "content_hash": 6398235513205658305, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344578\nhelp.text", "note": "YyzoD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110808528/?format=api", "priority": 100, "id": 110808528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d8cb194cc9e992c1", "url": "https://translations.documentfoundation.org/api/units/110808528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.293916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To edit the custom sort lists, open <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists." ], "previous_source": "", "target": [ "To edit the custom sort lists, open <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists." ], "id_hash": 6419540318379617403, "content_hash": 6419540318379617403, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344584\nhelp.text", "note": "VmFtw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110808568/?format=api", "priority": 100, "id": 110808568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d916c9e84a50ac7b", "url": "https://translations.documentfoundation.org/api/units/110808568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.313687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner." ], "previous_source": "", "target": [ "The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner." ], "id_hash": 6742025525394214573, "content_hash": 6742025525394214573, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344811\nhelp.text", "note": "fWvXo", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110808617/?format=api", "priority": 100, "id": 110808617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=dd907c7e9bbd0ead", "url": "https://translations.documentfoundation.org/api/units/110808617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.339975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D." ], "previous_source": "", "target": [ "You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D." ], "id_hash": -1902121773667146174, "content_hash": -1902121773667146174, "location": "datapilot_filtertable.xhp", "context": "datapilot_filtertable.xhp\npar_id0720201001344884\nhelp.text", "note": "DBnSP", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110808647/?format=api", "priority": 100, "id": 110808647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=659a4e532108a642", "url": "https://translations.documentfoundation.org/api/units/110808647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.353043Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Formatting Pivot Tables" ], "previous_source": "", "target": [ "Formatting Pivot Tables" ], "id_hash": -872648412438975098, "content_hash": -872648412438975098, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\ntit\nhelp.text", "note": "LYAEi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808710/?format=api", "priority": 100, "id": 110808710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=73e3bae472c42d86", "url": "https://translations.documentfoundation.org/api/units/110808710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.380843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>formatting;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>formatting;pivot tables</bookmark_value>" ], "id_hash": 5188026700518336650, "content_hash": 5188026700518336650, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\nbm_id931656104694657\nhelp.text", "note": "GkCpq", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110808761/?format=api", "priority": 100, "id": 110808761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=c7ff92cbf9a3288a", "url": "https://translations.documentfoundation.org/api/units/110808761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.415894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/guide/datapilot_formatting.xhp\">Formatting Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"h1\"><link href=\"text/scalc/guide/datapilot_formatting.xhp\">Formatting Pivot Tables</link></variable>" ], "id_hash": 3474093815967338189, "content_hash": 3474093815967338189, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\nhd_id341656099297638\nhelp.text", "note": "rsh3f", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110808802/?format=api", "priority": 100, "id": 110808802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b03675eb491d4ecd", "url": "https://translations.documentfoundation.org/api/units/110808802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.429190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can format pivot tables cells using specific cell styles." ], "previous_source": "", "target": [ "You can format pivot tables cells using specific cell styles." ], "id_hash": -5727232335206902169, "content_hash": -5727232335206902169, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id121656099297641\nhelp.text", "note": "aA7AD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110808838/?format=api", "priority": 100, "id": 110808838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3084c88909dc9667", "url": "https://translations.documentfoundation.org/api/units/110808838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.449132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Direct formatting of pivot tables cells is lost when updating or editing the table." ], "previous_source": "", "target": [ "Direct formatting of pivot tables cells is lost when updating or editing the table." ], "id_hash": 5658586114188164395, "content_hash": 5658586114188164395, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id751656100824556\nhelp.text", "note": "V3B9U", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110808869/?format=api", "priority": 100, "id": 110808869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=ce8756172324bd2b", "url": "https://translations.documentfoundation.org/api/units/110808869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.504550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "When creating a pivot table, six new cell styles are added to your document. Format each cell style as needed. The customization of the pivot cell styles will be preserved when updating the pivot table." ], "previous_source": "", "target": [ "When creating a pivot table, six new cell styles are added to your document. Format each cell style as needed. The customization of the pivot cell styles will be preserved when updating the pivot table." ], "id_hash": 3798803674947994890, "content_hash": 3798803674947994890, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id31656100011920\nhelp.text", "note": "BX4Fw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110808890/?format=api", "priority": 100, "id": 110808890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b4b80fd0c0b9450a", "url": "https://translations.documentfoundation.org/api/units/110808890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.525145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "By using cell styles for pivot table formatting, all pivot tables cells in the spreadsheet document will have the same look. In other words, the pivot table cell styles apply to all pivot tables of the document." ], "previous_source": "", "target": [ "By using cell styles for pivot table formatting, all pivot tables cells in the spreadsheet document will have the same look. In other words, the pivot table cell styles apply to all pivot tables of the document." ], "id_hash": -3917237368973713667, "content_hash": -3917237368973713667, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id601656100455727\nhelp.text", "note": "jQyBh", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110808900/?format=api", "priority": 100, "id": 110808900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=49a32d5e096f9efd", "url": "https://translations.documentfoundation.org/api/units/110808900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.537360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The six cell styles are:" ], "previous_source": "", "target": [ "The six cell styles are:" ], "id_hash": 4113550336471712507, "content_hash": 4113550336471712507, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id941656100017412\nhelp.text", "note": "YgaMr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110808934/?format=api", "priority": 100, "id": 110808934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=b916443c8b15c2fb", "url": "https://translations.documentfoundation.org/api/units/110808934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.570958Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Categories" ], "previous_source": "", "target": [ "Pivot Table Categories" ], "id_hash": 7450925993056749863, "content_hash": 7450925993056749863, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id181656100070568\nhelp.text", "note": "cH3xo", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808945/?format=api", "priority": 100, "id": 110808945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e76701b6c7df4927", "url": "https://translations.documentfoundation.org/api/units/110808945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.583221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Corner" ], "previous_source": "", "target": [ "Pivot Table Corner" ], "id_hash": 8492181869213066735, "content_hash": 8492181869213066735, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id781656100074986\nhelp.text", "note": "GznnA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808958/?format=api", "priority": 100, "id": 110808958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f5da4a6aa27525ef", "url": "https://translations.documentfoundation.org/api/units/110808958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.597872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Field" ], "previous_source": "", "target": [ "Pivot Table Field" ], "id_hash": 1218668075300336751, "content_hash": 1218668075300336751, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id311656100079561\nhelp.text", "note": "Y5UBR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808959/?format=api", "priority": 100, "id": 110808959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=90e994285f62b46f", "url": "https://translations.documentfoundation.org/api/units/110808959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.606773Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Result" ], "previous_source": "", "target": [ "Pivot Table Result" ], "id_hash": -3448357393645814961, "content_hash": -3448357393645814961, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id601656100083888\nhelp.text", "note": "a2oFk", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110808982/?format=api", "priority": 100, "id": 110808982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=5024f9387d263b4f", "url": "https://translations.documentfoundation.org/api/units/110808982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.634205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Value" ], "previous_source": "", "target": [ "Pivot Table Value" ], "id_hash": -1313227064782636535, "content_hash": -1313227064782636535, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id521656100088324\nhelp.text", "note": "JvVDa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110809014/?format=api", "priority": 100, "id": 110809014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=6dc67af13e33ba09", "url": "https://translations.documentfoundation.org/api/units/110809014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.651218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Pivot Table Title" ], "previous_source": "", "target": [ "Pivot Table Title" ], "id_hash": -3098112199525796386, "content_hash": -3098112199525796386, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id111656100092437\nhelp.text", "note": "HABWX", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110809047/?format=api", "priority": 100, "id": 110809047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=55014b5e78f5f5de", "url": "https://translations.documentfoundation.org/api/units/110809047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.714070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The number format of these cell styles cannot be changed in the cell style itself; you must format it in the data source." ], "previous_source": "", "target": [ "The number format of these cell styles cannot be changed in the cell style itself; you must format it in the data source." ], "id_hash": -6522752183173044652, "content_hash": -6522752183173044652, "location": "datapilot_formatting.xhp", "context": "datapilot_formatting.xhp\npar_id971656104293716\nhelp.text", "note": "cRb6R", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110809101/?format=api", "priority": 100, "id": 110809101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=257a8772cc112654", "url": "https://translations.documentfoundation.org/api/units/110809101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.741448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Grouping Pivot Tables" ], "previous_source": "", "target": [ "Grouping Pivot Tables" ], "id_hash": -4335655469519626496, "content_hash": -4335655469519626496, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\ntit\nhelp.text", "note": "CeKoE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110809122/?format=api", "priority": 100, "id": 110809122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=43d4a8525ecd9f00", "url": "https://translations.documentfoundation.org/api/units/110809122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.758848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>grouping; pivot tables</bookmark_value><bookmark_value>pivot table function;grouping table entries</bookmark_value><bookmark_value>ungrouping entries in pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>grouping; pivot tables</bookmark_value><bookmark_value>pivot table function;grouping table entries</bookmark_value><bookmark_value>ungrouping entries in pivot tables</bookmark_value>" ], "id_hash": -30881756764189150, "content_hash": -30881756764189150, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\nbm_id4195684\nhelp.text", "note": "Kvc5K", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110809142/?format=api", "priority": 100, "id": 110809142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7f924934b207ce22", "url": "https://translations.documentfoundation.org/api/units/110809142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.769665Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_grouping\"><link href=\"text/scalc/guide/datapilot_grouping.xhp\">Grouping Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_grouping\"><link href=\"text/scalc/guide/datapilot_grouping.xhp\">Grouping Pivot Tables</link></variable>" ], "id_hash": 842687667894254175, "content_hash": 842687667894254175, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10643\nhelp.text", "note": "NEBhF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110809149/?format=api", "priority": 100, "id": 110809149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=8bb1d3f81d707a5f", "url": "https://translations.documentfoundation.org/api/units/110809149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.783513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result." ], "previous_source": "", "target": [ "The resulting pivot table can contain many different entries. By grouping the entries, you can improve the visible result." ], "id_hash": -3903438331949886913, "content_hash": -3903438331949886913, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10661\nhelp.text", "note": "EMuyW", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110809171/?format=api", "priority": 100, "id": 110809171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=49d43384b57bd23f", "url": "https://translations.documentfoundation.org/api/units/110809171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.800144Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Select a cell or range of cells in the pivot table." ], "previous_source": "", "target": [ "Select a cell or range of cells in the pivot table." ], "id_hash": -8236415449389356388, "content_hash": -8236415449389356388, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10667\nhelp.text", "note": "jwZEk", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110809187/?format=api", "priority": 100, "id": 110809187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=0db25fc9849baa9c", "url": "https://translations.documentfoundation.org/api/units/110809187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:05.825188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Choose <emph>Data - Group and Outline - Group</emph>." ], "previous_source": "", "target": [ "Choose <emph>Data - Group and Outline - Group</emph>." ], "id_hash": 6138031007450000332, "content_hash": 6138031007450000332, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN1066B\nhelp.text", "note": "dqrNE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110809229/?format=api", "priority": 100, "id": 110809229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d52eaaae3b63ebcc", "url": "https://translations.documentfoundation.org/api/units/110809229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.254567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two <link href=\"text/scalc/01/12090400.xhp\">Grouping</link> dialogs, either for numeric values, or for date values." ], "previous_source": "", "target": [ "Depending on the format of the selected cells, either a new group field is added to the pivot table, or you see one of the two <link href=\"text/scalc/01/12090400.xhp\">Grouping</link> dialogs, either for numeric values, or for date values." ], "id_hash": 8530320587308899497, "content_hash": 8530320587308899497, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN1066E\nhelp.text", "note": "JwFoj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110809282/?format=api", "priority": 100, "id": 110809282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f661c960eabf9ca9", "url": "https://translations.documentfoundation.org/api/units/110809282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.268988Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The pivot table must be organized in a way that grouping can be applied." ], "previous_source": "", "target": [ "The pivot table must be organized in a way that grouping can be applied." ], "id_hash": 7825656805752664044, "content_hash": 7825656805752664044, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_id3328653\nhelp.text", "note": "smas8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110809345/?format=api", "priority": 100, "id": 110809345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=ec9a516719016fec", "url": "https://translations.documentfoundation.org/api/units/110809345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.289641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>." ], "previous_source": "", "target": [ "To remove a grouping, click inside the group, then choose <emph>Data - Group and Outline - Ungroup</emph>." ], "id_hash": -2586084008307701345, "content_hash": -2586084008307701345, "location": "datapilot_grouping.xhp", "context": "datapilot_grouping.xhp\npar_idN10682\nhelp.text", "note": "QCfxM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110809534/?format=api", "priority": 100, "id": 110809534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=5c1c624bcd80499f", "url": "https://translations.documentfoundation.org/api/units/110809534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.386905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Selecting Pivot Table Output Ranges" ], "previous_source": "", "target": [ "Selecting Pivot Table Output Ranges" ], "id_hash": 2466387850413975974, "content_hash": 2466387850413975974, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\ntit\nhelp.text", "note": "CG8kj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110809572/?format=api", "priority": 100, "id": 110809572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a23a5eaeb643a9a6", "url": "https://translations.documentfoundation.org/api/units/110809572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.406532Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>pivot table function; preventing data overwriting</bookmark_value><bookmark_value>output ranges of pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot table function; preventing data overwriting</bookmark_value><bookmark_value>output ranges of pivot tables</bookmark_value>" ], "id_hash": -5676268997689810682, "content_hash": -5676268997689810682, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\nbm_id3148663\nhelp.text", "note": "Xwk6m", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110809610/?format=api", "priority": 100, "id": 110809610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=3139d76bb722e106", "url": "https://translations.documentfoundation.org/api/units/110809610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.424622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_tipps\"><link href=\"text/scalc/guide/datapilot_tipps.xhp\">Selecting Pivot Table Output Ranges</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_tipps\"><link href=\"text/scalc/guide/datapilot_tipps.xhp\">Selecting Pivot Table Output Ranges</link></variable>" ], "id_hash": 2757068843177979994, "content_hash": 2757068843177979994, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\nhd_id3148663\nhelp.text", "note": "xeirD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110809655/?format=api", "priority": 100, "id": 110809655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=a64313815aebb05a", "url": "https://translations.documentfoundation.org/api/units/110809655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.442570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Click the button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog will be extended." ], "previous_source": "", "target": [ "Click the button <emph>More</emph> in the <emph>Pivot Table</emph> dialog. The dialog will be extended." ], "id_hash": 1881129433481891917, "content_hash": 1881129433481891917, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3154123\nhelp.text", "note": "kikhM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110809700/?format=api", "priority": 100, "id": 110809700, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=9a1b1d40cb38504d", "url": "https://translations.documentfoundation.org/api/units/110809700/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.478545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly." ], "previous_source": "", "target": [ "You can select a named range in which the pivot table is to be created, from the <emph>Results to</emph> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the <emph>Results to</emph> box. You can also click on the appropriate cell to have the coordinates entered accordingly." ], "id_hash": 9082077293261694422, "content_hash": 9082077293261694422, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3153771\nhelp.text", "note": "rRGaZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/110809741/?format=api", "priority": 100, "id": 110809741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=fe0a052de78125d6", "url": "https://translations.documentfoundation.org/api/units/110809741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.497554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If you mark the <emph>Ignore empty rows</emph> check box, they will not be taken into account when the pivot table is created." ], "previous_source": "", "target": [ "If you mark the <emph>Ignore empty rows</emph> check box, they will not be taken into account when the pivot table is created." ], "id_hash": -3345562501342870709, "content_hash": -3345562501342870709, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3146974\nhelp.text", "note": "EHd6K", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110809761/?format=api", "priority": 100, "id": 110809761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=51922ca16d97434b", "url": "https://translations.documentfoundation.org/api/units/110809761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.509629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created." ], "previous_source": "", "target": [ "If the <emph>Identify categories</emph> check box is marked, the categories will be identified by their headings and assigned accordingly when the pivot table is created." ], "id_hash": -191296208716936319, "content_hash": -191296208716936319, "location": "datapilot_tipps.xhp", "context": "datapilot_tipps.xhp\npar_id3145273\nhelp.text", "note": "qRCKc", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110809789/?format=api", "priority": 100, "id": 110809789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=7d58611c988c4b81", "url": "https://translations.documentfoundation.org/api/units/110809789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.529878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Updating Pivot Tables" ], "previous_source": "", "target": [ "Updating Pivot Tables" ], "id_hash": -6788373997742917749, "content_hash": -6788373997742917749, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\ntit\nhelp.text", "note": "6WBqj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110809817/?format=api", "priority": 100, "id": 110809817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=21cad9d0be08f78b", "url": "https://translations.documentfoundation.org/api/units/110809817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.541416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>pivot table import</bookmark_value><bookmark_value>pivot table function; refreshing tables</bookmark_value><bookmark_value>recalculating;pivot tables</bookmark_value><bookmark_value>updating;pivot tables</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>pivot table import</bookmark_value><bookmark_value>pivot table function; refreshing tables</bookmark_value><bookmark_value>recalculating;pivot tables</bookmark_value><bookmark_value>updating;pivot tables</bookmark_value>" ], "id_hash": 3203889524059853912, "content_hash": 3203889524059853912, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\nbm_id3150792\nhelp.text", "note": "8o6oz", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110809852/?format=api", "priority": 100, "id": 110809852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=ac76808c152ed458", "url": "https://translations.documentfoundation.org/api/units/110809852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.558978Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"datapilot_updatetable\"><link href=\"text/scalc/guide/datapilot_updatetable.xhp\">Updating Pivot Tables</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"datapilot_updatetable\"><link href=\"text/scalc/guide/datapilot_updatetable.xhp\">Updating Pivot Tables</link></variable>" ], "id_hash": 7695311688494584509, "content_hash": 7695311688494584509, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\nhd_id3150792\nhelp.text", "note": "SVyQU", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110809891/?format=api", "priority": 100, "id": 110809891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=eacb3d358ca192bd", "url": "https://translations.documentfoundation.org/api/units/110809891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.577566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc." ], "previous_source": "", "target": [ "If the data of the source sheet has been changed, $[officename] recalculates the pivot table. To recalculate the table, choose <emph>Data - Pivot Table - Refresh</emph>. Do the same after you have imported an Excel pivot table into $[officename] Calc." ], "id_hash": 6120207290802278664, "content_hash": 6120207290802278664, "location": "datapilot_updatetable.xhp", "context": "datapilot_updatetable.xhp\npar_id3154684\nhelp.text", "note": "gaKCU", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110809944/?format=api", "priority": 100, "id": 110809944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=d4ef581ad0069108", "url": "https://translations.documentfoundation.org/api/units/110809944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.605586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Importing and Exporting dBASE Files" ], "previous_source": "", "target": [ "Importing and Exporting dBASE Files" ], "id_hash": 7395598904683807561, "content_hash": 7395598904683807561, "location": "dbase_files.xhp", "context": "dbase_files.xhp\ntit\nhelp.text", "note": "kDqTU", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110809955/?format=api", "priority": 100, "id": 110809955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=e6a272052ef24349", "url": "https://translations.documentfoundation.org/api/units/110809955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.615447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<bookmark_value>exporting;spreadsheets to dBASE</bookmark_value> <bookmark_value>importing;dBASE files</bookmark_value> <bookmark_value>dBASE import/export</bookmark_value> <bookmark_value>spreadsheets; importing from/exporting to dBASE files</bookmark_value> <bookmark_value>tables in databases;importing dBASE files</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>exporting;spreadsheets to dBASE</bookmark_value> <bookmark_value>importing;dBASE files</bookmark_value> <bookmark_value>dBASE import/export</bookmark_value> <bookmark_value>spreadsheets; importing from/exporting to dBASE files</bookmark_value> <bookmark_value>tables in databases;importing dBASE files</bookmark_value>" ], "id_hash": -6115726648041509010, "content_hash": -6115726648041509010, "location": "dbase_files.xhp", "context": "dbase_files.xhp\nbm_id1226844\nhelp.text", "note": "DkG3C", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110809975/?format=api", "priority": 100, "id": 110809975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=2b20930420186f6e", "url": "https://translations.documentfoundation.org/api/units/110809975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.632525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "<variable id=\"dbase_files\"><link href=\"text/scalc/guide/dbase_files.xhp\">Importing and Exporting dBASE Files</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"dbase_files\"><link href=\"text/scalc/guide/dbase_files.xhp\">Importing and Exporting dBASE Files</link></variable>" ], "id_hash": 161637248228085591, "content_hash": 161637248228085591, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10738\nhelp.text", "note": "phARr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110810006/?format=api", "priority": 100, "id": 110810006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=823e40388b1b4f57", "url": "https://translations.documentfoundation.org/api/units/110810006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.650363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME." ], "previous_source": "", "target": [ "You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME." ], "id_hash": 1782665680064101011, "content_hash": 1782665680064101011, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10756\nhelp.text", "note": "J3aQ5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/110810024/?format=api", "priority": 100, "id": 110810024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=98bd4cfdb5803a93", "url": "https://translations.documentfoundation.org/api/units/110810024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.667973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "To Import a dBASE File Into a Spreadsheet" ], "previous_source": "", "target": [ "To Import a dBASE File Into a Spreadsheet" ], "id_hash": 8437163193353355654, "content_hash": 8437163193353355654, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10759\nhelp.text", "note": "jVz9V", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110810025/?format=api", "priority": 100, "id": 110810025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=f516d338ebd3c186", "url": "https://translations.documentfoundation.org/api/units/110810025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.676387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Choose <emph>File - Open</emph>." ], "previous_source": "", "target": [ "Choose <emph>File - Open</emph>." ], "id_hash": 1683519698946321679, "content_hash": 1683519698946321679, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10760\nhelp.text", "note": "v3JdV", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110810045/?format=api", "priority": 100, "id": 110810045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=975d103f1c116d0f", "url": "https://translations.documentfoundation.org/api/units/110810045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.695042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Locate the *.dbf file that you want to import." ], "previous_source": "", "target": [ "Locate the *.dbf file that you want to import." ], "id_hash": 411317677609335887, "content_hash": 411317677609335887, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN1071F\nhelp.text", "note": "FmmZC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110810070/?format=api", "priority": 100, "id": 110810070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=85b54b3f9fbe3c4f", "url": "https://translations.documentfoundation.org/api/units/110810070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.711586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "Click <emph>Open</emph>." ], "previous_source": "", "target": [ "Click <emph>Open</emph>." ], "id_hash": -7192977753618697200, "content_hash": -7192977753618697200, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10768\nhelp.text", "note": "cBR6P", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110810102/?format=api", "priority": 100, "id": 110810102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=1c2d68d7d6453410", "url": "https://translations.documentfoundation.org/api/units/110810102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.733418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "source": [ "The <emph>Import dBASE files</emph> dialog opens." ], "previous_source": "", "target": [ "The <emph>Import dBASE files</emph> dialog opens." ], "id_hash": -2029065530847235774, "content_hash": -2029065530847235774, "location": "dbase_files.xhp", "context": "dbase_files.xhp\npar_idN10730\nhelp.text", "note": "WQGdy", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110810123/?format=api", "priority": 100, "id": 110810123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en/?checksum=63d74fa66fdc7142", "url": "https://translations.documentfoundation.org/api/units/110810123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:25:06.746192Z" } ] }{ "count": 1558, "next": "