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/he/units/?format=api&page=27
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/units/?format=api&page=28", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/units/?format=api&page=26", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<link href=\"text/scalc/01/06050000.xhp\">Creating Scenarios</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 2250133394351343223, "content_hash": 2250133394351343223, "location": "scenario.xhp", "context": "scenario.xhp\npar_id3154484\nhelp.text", "note": "tZ3Es", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1301, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834071/?format=api", "priority": 100, "id": 111268236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9f3a1466838e4677", "url": "https://translations.documentfoundation.org/api/units/111268236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.827899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Applying Sort Lists" ], "previous_source": "", "target": [ "Applying Sort Lists" ], "id_hash": 2782619448798829863, "content_hash": 2782619448798829863, "location": "sorted_list.xhp", "context": "sorted_list.xhp\ntit\nhelp.text", "note": "AG6Vf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1302, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834098/?format=api", "priority": 100, "id": 111268241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a69dd9a54ebf5d27", "url": "https://translations.documentfoundation.org/api/units/111268241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.829554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<bookmark_value>filling;customized lists</bookmark_value><bookmark_value>sort lists;applying</bookmark_value><bookmark_value>defining;sort lists</bookmark_value><bookmark_value>geometric lists</bookmark_value><bookmark_value>arithmetic lists</bookmark_value><bookmark_value>series;sort lists</bookmark_value><bookmark_value>lists; user-defined</bookmark_value><bookmark_value>customized lists</bookmark_value>" ], "previous_source": "", "target": [ "\\<bookmark_value\\>filling;customized lists\\</bookmark_value\\>\\<bookmark_value\\>sort lists;applying\\</bookmark_value\\>\\<bookmark_value\\>applying;sort lists\\</bookmark_value\\>\\<bookmark_value\\>defining;sort lists\\</bookmark_value\\>\\<bookmark_value\\>geometric lists\\</bookmark_value\\>\\<bookmark_value\\>arithmetic lists\\</bookmark_value\\>\\<bookmark_value\\>series;sort lists\\</bookmark_value\\>\\<bookmark_value\\>lists; user-defined\\</bookmark_value\\>\\<bookmark_value\\>customized lists\\</bookmark_value\\>" ], "id_hash": -4842831399431973213, "content_hash": -4842831399431973213, "location": "sorted_list.xhp", "context": "sorted_list.xhp\nbm_id3150870\nhelp.text", "note": "tWAqX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1303, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110834136/?format=api", "priority": 100, "id": 111268250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=3ccace8029bfd6a3", "url": "https://translations.documentfoundation.org/api/units/111268250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.832167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<variable id=\"sorted_list\"><link href=\"text/scalc/guide/sorted_list.xhp\">Applying Sort Lists</link> </variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -8678436004188644317, "content_hash": -8678436004188644317, "location": "sorted_list.xhp", "context": "sorted_list.xhp\nhd_id3150870\nhelp.text", "note": "486Qk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110834152/?format=api", "priority": 100, "id": 111268258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=0790006f3c601c23", "url": "https://translations.documentfoundation.org/api/units/111268258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.834811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items." ], "previous_source": "", "target": [ "Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items." ], "id_hash": -6846691957918148021, "content_hash": -6846691957918148021, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3159154\nhelp.text", "note": "oMwuD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1305, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110834201/?format=api", "priority": 100, "id": 111268265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=20fba9f089c3da4b", "url": "https://translations.documentfoundation.org/api/units/111268265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.836252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "For example, enter the text \"Jan\" or \"January\" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months." ], "previous_source": "", "target": [ "For example, enter the text \"Jan\" or \"January\" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months." ], "id_hash": 2065353311408610424, "content_hash": 2065353311408610424, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3148645\nhelp.text", "note": "BEsCh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1306, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110834252/?format=api", "priority": 100, "id": 111268272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9ca99be4de2fdc78", "url": "https://translations.documentfoundation.org/api/units/111268272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.838337Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values." ], "previous_source": "", "target": [ "" ], "id_hash": 1162809071561114065, "content_hash": 1162809071561114065, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id2367931\nhelp.text", "note": "Eay9F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110834330/?format=api", "priority": 100, "id": 111268282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=902320b0940081d1", "url": "https://translations.documentfoundation.org/api/units/111268282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.840961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "The predefined series can be found under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse." ], "previous_source": "", "target": [ "" ], "id_hash": 4586192166671034918, "content_hash": 4586192166671034918, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3152577\nhelp.text", "note": "YPryW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1308, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/110834461/?format=api", "priority": 100, "id": 111268290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=bfa56d7a161b2a26", "url": "https://translations.documentfoundation.org/api/units/111268290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.842587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<link href=\"text/shared/optionen/01060400.xhp\">Sort lists</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2070885226499949407, "content_hash": -2070885226499949407, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3147434\nhelp.text", "note": "vnpQt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834518/?format=api", "priority": 100, "id": 111268296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=6342bcdbc7ddbca1", "url": "https://translations.documentfoundation.org/api/units/111268296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.844309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Applying Advanced Filters" ], "previous_source": "", "target": [ "" ], "id_hash": -3660555054599967222, "content_hash": -3660555054599967222, "location": "specialfilter.xhp", "context": "specialfilter.xhp\ntit\nhelp.text", "note": "6GdiT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834591/?format=api", "priority": 100, "id": 111268301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4d33189281ceee0a", "url": "https://translations.documentfoundation.org/api/units/111268301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.845616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" ], "previous_source": "", "target": [ "\\<bookmark_value\\>filters;defining advanced filters \\</bookmark_value\\>\\<bookmark_value\\>applying;advanced filters\\</bookmark_value\\>\\<bookmark_value\\>defining; advanced filters\\</bookmark_value\\>\\<bookmark_value\\>database ranges; advanced filters\\</bookmark_value\\>" ], "id_hash": 7117808451965716241, "content_hash": 7117808451965716241, "location": "specialfilter.xhp", "context": "specialfilter.xhp\nbm_id3148798\nhelp.text", "note": "Gy5TZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1311, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110834635/?format=api", "priority": 100, "id": 111268307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e2c7891346b08711", "url": "https://translations.documentfoundation.org/api/units/111268307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.847011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\">Applying Advanced Filters</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -4981866055637895193, "content_hash": -4981866055637895193, "location": "specialfilter.xhp", "context": "specialfilter.xhp\nhd_id3148798\nhelp.text", "note": "nzLyA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110834691/?format=api", "priority": 100, "id": 111268313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=3adcdb37ab2077e7", "url": "https://translations.documentfoundation.org/api/units/111268313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.849301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR." ], "previous_source": "", "target": [ "Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR." ], "id_hash": 2387400062211336893, "content_hash": 2387400062211336893, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3145785\nhelp.text", "note": "tYuAi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1313, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110834753/?format=api", "priority": 100, "id": 111268319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a121bfb524da2abd", "url": "https://translations.documentfoundation.org/api/units/111268319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.851073Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Once you have created a filter matrix, select the sheet ranges to be filtered. Open the <emph>Advanced Filter</emph> dialog by choosing <menuitem>Data - More Filters - Advanced Filter</menuitem>, and define the filter conditions." ], "previous_source": "", "target": [ "" ], "id_hash": -6844686386953263484, "content_hash": -6844686386953263484, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153142\nhelp.text", "note": "73DhZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1314, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110834819/?format=api", "priority": 100, "id": 111268328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=2102c9feeab2e684", "url": "https://translations.documentfoundation.org/api/units/111268328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.853625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the <menuitem>Format - Rows - Show</menuitem> command." ], "previous_source": "", "target": [ "" ], "id_hash": -5620549649644658119, "content_hash": -5620549649644658119, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153726\nhelp.text", "note": "2F7wd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/110834858/?format=api", "priority": 100, "id": 111268334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=31ffcbdf627be239", "url": "https://translations.documentfoundation.org/api/units/111268334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.855003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "" ], "id_hash": -112470937908647374, "content_hash": -112470937908647374, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149664\nhelp.text", "note": "Sn4mJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110834951/?format=api", "priority": 100, "id": 111268341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=7e706c4722666a32", "url": "https://translations.documentfoundation.org/api/units/111268341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.856564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Load a spreadsheet with a large number of records. We are using a fictional <emph>Turnover</emph> document, but you can just as easily use any other document. The document has the following layout:" ], "previous_source": "", "target": [ "Load a spreadsheet with a large number of records. We are using a fictional \\<emph\\>Turnover\\</emph\\> document, but you can just as easily use any other document. The document has the following layout:" ], "id_hash": -3998392825886884412, "content_hash": -3998392825886884412, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147427\nhelp.text", "note": "UFqRd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1317, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110834995/?format=api", "priority": 100, "id": 111268346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4882dae8c48abdc4", "url": "https://translations.documentfoundation.org/api/units/111268346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.857881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Month" ], "previous_source": "", "target": [ "Month" ], "id_hash": 2891455976044999883, "content_hash": 2891455976044999883, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3159239\nhelp.text", "note": "KiEAY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1318, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835034/?format=api", "priority": 100, "id": 111268355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a82083e3ffd7b4cb", "url": "https://translations.documentfoundation.org/api/units/111268355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.860570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Standard" ], "previous_source": "", "target": [ "Standard" ], "id_hash": -5842489461672849589, "content_hash": -5842489461672849589, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150086\nhelp.text", "note": "zvwPF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1319, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835085/?format=api", "priority": 100, "id": 111268363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=2eeb4eca1906cf4b", "url": "https://translations.documentfoundation.org/api/units/111268363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.862636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Business" ], "previous_source": "", "target": [ "Business" ], "id_hash": -2616753681549536744, "content_hash": -2616753681549536744, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150202\nhelp.text", "note": "FgLfE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1320, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835098/?format=api", "priority": 100, "id": 111268370, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=5baf6c640a8b5218", "url": "https://translations.documentfoundation.org/api/units/111268370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.864387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Luxury" ], "previous_source": "", "target": [ "Luxury" ], "id_hash": 11081334254114949, "content_hash": 11081334254114949, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150883\nhelp.text", "note": "v3Dfi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1321, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835126/?format=api", "priority": 100, "id": 111268379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=80275e6a2fda9885", "url": "https://translations.documentfoundation.org/api/units/111268379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.866551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Suite" ], "previous_source": "", "target": [ "Suite" ], "id_hash": -1449357622872119712, "content_hash": -1449357622872119712, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3152987\nhelp.text", "note": "4BrQp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1322, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835152/?format=api", "priority": 100, "id": 111268387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=6be2d8ebc833e660", "url": "https://translations.documentfoundation.org/api/units/111268387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.868836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "January" ], "previous_source": "", "target": [ "January" ], "id_hash": 5533564376090591052, "content_hash": 5533564376090591052, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3148839\nhelp.text", "note": "KT7sj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835184/?format=api", "priority": 100, "id": 111268395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=cccb2b7b62a2bf4c", "url": "https://translations.documentfoundation.org/api/units/111268395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.870915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "February" ], "previous_source": "", "target": [ "February" ], "id_hash": 5329516219354473778, "content_hash": 5329516219354473778, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149900\nhelp.text", "note": "USDDe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835399/?format=api", "priority": 100, "id": 111268401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=c9f63ec3b74e6532", "url": "https://translations.documentfoundation.org/api/units/111268401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.872435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "March" ], "previous_source": "", "target": [ "March" ], "id_hash": 1605806199289126873, "content_hash": 1605806199289126873, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147250\nhelp.text", "note": "88qLX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1325, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835444/?format=api", "priority": 100, "id": 111268408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9648f83af6bf9fd9", "url": "https://translations.documentfoundation.org/api/units/111268408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.873904Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "and so on..." ], "previous_source": "", "target": [ "and so on..." ], "id_hash": -1548848217751534148, "content_hash": -1548848217751534148, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3151391\nhelp.text", "note": "sbbpY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1326, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110835493/?format=api", "priority": 100, "id": 111268415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=6a8162c089ec45bc", "url": "https://translations.documentfoundation.org/api/units/111268415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.875807Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on." ], "previous_source": "", "target": [ "Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on." ], "id_hash": -2378213447471280303, "content_hash": -2378213447471280303, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147300\nhelp.text", "note": "e5jJ9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1327, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110835514/?format=api", "priority": 100, "id": 111268424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=5efee378476acf51", "url": "https://translations.documentfoundation.org/api/units/111268424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.878134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Month" ], "previous_source": "", "target": [ "Month" ], "id_hash": -1033504986130264121, "content_hash": -1033504986130264121, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150693\nhelp.text", "note": "VHUHq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1328, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835556/?format=api", "priority": 100, "id": 111268431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=71a840b0dc1c4fc7", "url": "https://translations.documentfoundation.org/api/units/111268431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:51.879994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Standard" ], "previous_source": "", "target": [ "Standard" ], "id_hash": -5010097898375563567, "content_hash": -5010097898375563567, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147475\nhelp.text", "note": "fX6Uo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835613/?format=api", "priority": 100, "id": 111268437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=3a788e818d64b6d1", "url": "https://translations.documentfoundation.org/api/units/111268437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.907036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Business" ], "previous_source": "", "target": [ "Business" ], "id_hash": 6915852544870314165, "content_hash": 6915852544870314165, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3154846\nhelp.text", "note": "kQ8ZZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1330, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835685/?format=api", "priority": 100, "id": 111268442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=dffa0b3f6ff9f0b5", "url": "https://translations.documentfoundation.org/api/units/111268442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.919710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Luxury" ], "previous_source": "", "target": [ "Luxury" ], "id_hash": 2602737318262423109, "content_hash": 2602737318262423109, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153082\nhelp.text", "note": "cZBpH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1331, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835697/?format=api", "priority": 100, "id": 111268449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a41ec7cd12af3e45", "url": "https://translations.documentfoundation.org/api/units/111268449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.922763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Suite" ], "previous_source": "", "target": [ "Suite" ], "id_hash": 3115261982357523362, "content_hash": 3115261982357523362, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149506\nhelp.text", "note": "eo2EN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1332, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835919/?format=api", "priority": 100, "id": 111268464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=ab3ba24480b30ba2", "url": "https://translations.documentfoundation.org/api/units/111268464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.927878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "January" ], "previous_source": "", "target": [ "January" ], "id_hash": -6161606621156287619, "content_hash": -6161606621156287619, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149956\nhelp.text", "note": "CAjJZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835969/?format=api", "priority": 100, "id": 111268470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=2a7d936c7448db7d", "url": "https://translations.documentfoundation.org/api/units/111268470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.930516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Specify that only rows which either have the value <literal>January</literal> in the <emph>Month</emph> cells OR a value of under 160000 in the <emph>Standard</emph> cells will be displayed." ], "previous_source": "", "target": [ "" ], "id_hash": 4300422702191999635, "content_hash": 4300422702191999635, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153566\nhelp.text", "note": "GTvgG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110836032/?format=api", "priority": 100, "id": 111268475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=bbae2ba9bc2dfa93", "url": "https://translations.documentfoundation.org/api/units/111268475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.932661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Choose <menuitem>Data - More Filters - Advanced Filter</menuitem>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view." ], "previous_source": "", "target": [ "" ], "id_hash": 5334272711115131498, "content_hash": 5334272711115131498, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147372\nhelp.text", "note": "ApUpg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110836105/?format=api", "priority": 100, "id": 111268487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=ca0724c4c113ca6a", "url": "https://translations.documentfoundation.org/api/units/111268487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.936134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Using Subtotals Tool" ], "previous_source": "", "target": [ "" ], "id_hash": 7533233722582203021, "content_hash": 7533233722582203021, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\ntit\nhelp.text", "note": "jQ6bn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110836142/?format=api", "priority": 100, "id": 111268506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e88b6c286c817a8d", "url": "https://translations.documentfoundation.org/api/units/111268506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.943127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<bookmark_value>subtotals;using subtotals tool</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3949916786312185341, "content_hash": 3949916786312185341, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nbm_id521585182060496\nhelp.text", "note": "aKjYH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1337, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110836161/?format=api", "priority": 100, "id": 111268512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b6d0ec63bc7d85fd", "url": "https://translations.documentfoundation.org/api/units/111268512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.945500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<variable id=\"subtotaltoolh1\"><link href=\"text/scalc/guide/subtotaltool.xhp\">Using Subtotal Tool</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 82873423559425778, "content_hash": 82873423559425778, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id631585177069332\nhelp.text", "note": "e7TMf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1338, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110836211/?format=api", "priority": 100, "id": 111268518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=81266cf08c947ef2", "url": "https://translations.documentfoundation.org/api/units/111268518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.947489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Calc offers the Subtotals tool as a more comprehensive alternative to the <link href=\"text/scalc/01/04060106.xhp#Section12\">SUBTOTAL function</link>. In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can create subtotals for up to three arrays arranged in labeled columns. It also groups subtotals by category and sorts them automatically, thereby eliminating the need to apply AutoFilters and filter categories by hand." ], "previous_source": "", "target": [ "" ], "id_hash": -1797926882289676209, "content_hash": -1797926882289676209, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id301585177069332\nhelp.text", "note": "FEwcj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/110836256/?format=api", "priority": 100, "id": 111268523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=670c7b06c0ff904f", "url": "https://translations.documentfoundation.org/api/units/111268523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.949251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Using the Subtotals tool" ], "previous_source": "", "target": [ "" ], "id_hash": 3708895243280421151, "content_hash": 3708895243280421151, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id891585177511329\nhelp.text", "note": "NEkbi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110836284/?format=api", "priority": 100, "id": 111268528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b378a492bcdd911f", "url": "https://translations.documentfoundation.org/api/units/111268528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.950826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "To insert subtotal values into a worksheet:" ], "previous_source": "", "target": [ "" ], "id_hash": -6503939318800028129, "content_hash": -6503939318800028129, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id91585177517697\nhelp.text", "note": "kwLkR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110836354/?format=api", "priority": 100, "id": 111268533, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=25bd5da61e3a6e1f", "url": "https://translations.documentfoundation.org/api/units/111268533/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.952553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range." ], "previous_source": "", "target": [ "" ], "id_hash": 1676165077590547897, "content_hash": 1676165077590547897, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id241585177550504\nhelp.text", "note": "DKZ3o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110836408/?format=api", "priority": 100, "id": 111268536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9742ef41e2b31db9", "url": "https://translations.documentfoundation.org/api/units/111268536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.953871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -6297832789348154293, "content_hash": -6297832789348154293, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id421585177574387\nhelp.text", "note": "QiBqE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1343, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110836461/?format=api", "priority": 100, "id": 111268539, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=28999a720818844b", "url": "https://translations.documentfoundation.org/api/units/111268539/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.955218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column." ], "previous_source": "", "target": [ "" ], "id_hash": -6353680389445522381, "content_hash": -6353680389445522381, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id41585177608508\nhelp.text", "note": "BwAst", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110836494/?format=api", "priority": 100, "id": 111268543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=27d331595abbec33", "url": "https://translations.documentfoundation.org/api/units/111268543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.956528Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals." ], "previous_source": "", "target": [ "" ], "id_hash": 5461938802686026943, "content_hash": 5461938802686026943, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id451585177625978\nhelp.text", "note": "QmNL9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110836532/?format=api", "priority": 100, "id": 111268547, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=cbccb4670705e4bf", "url": "https://translations.documentfoundation.org/api/units/111268547/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.957916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4." ], "previous_source": "", "target": [ "" ], "id_hash": 3549048077078569758, "content_hash": 3549048077078569758, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id661585177644535\nhelp.text", "note": "CQ9km", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110836587/?format=api", "priority": 100, "id": 111268551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b140c06c250d231e", "url": "https://translations.documentfoundation.org/api/units/111268551/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.959615Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page." ], "previous_source": "", "target": [ "" ], "id_hash": 2291410142773376334, "content_hash": 2291410142773376334, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id351585177661529\nhelp.text", "note": "3eTTE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110836639/?format=api", "priority": 100, "id": 111268553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9fccb9626abbf54e", "url": "https://translations.documentfoundation.org/api/units/111268553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.960807Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”." ], "previous_source": "", "target": [ "" ], "id_hash": 2159292982110408392, "content_hash": 2159292982110408392, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id511585177679372\nhelp.text", "note": "6GLDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1348, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/110836708/?format=api", "priority": 100, "id": 111268557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9df75986dcaf4ec8", "url": "https://translations.documentfoundation.org/api/units/111268557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.962170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range." ], "previous_source": "", "target": [ "" ], "id_hash": 3137595891275628965, "content_hash": 3137595891275628965, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id301585177698777\nhelp.text", "note": "HDB52", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110836768/?format=api", "priority": 100, "id": 111268561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=ab8afad6e43581a5", "url": "https://translations.documentfoundation.org/api/units/111268561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.963494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Subtotal outline" ], "previous_source": "", "target": [ "" ], "id_hash": 6090414715338233155, "content_hash": 6090414715338233155, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id211585178799496\nhelp.text", "note": "iMTer", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110836817/?format=api", "priority": 100, "id": 111268564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=d4857fea4a8c1543", "url": "https://translations.documentfoundation.org/api/units/111268564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:52.964794Z" } ] }{ "count": 1558, "next": "