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_GB/units/?format=api
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Recognizing Names as Addressing" ], "previous_source": "", "target": [ "Recognising Names as Addressing" ], "id_hash": 7168437723810012455, "content_hash": 7168437723810012455, "location": "address_auto.xhp", "context": "address_auto.xhp\ntit\nhelp.text", "note": "NXy6S", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110789266/?format=api", "priority": 100, "id": 111099699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=e37b68213a349d27", "url": "https://translations.documentfoundation.org/api/units/111099699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.178476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>automatic addressing in tables</bookmark_value> <bookmark_value>natural language addressing</bookmark_value> <bookmark_value>formulas; using row/column labels</bookmark_value> <bookmark_value>text in cells; as addressing</bookmark_value> <bookmark_value>addressing; automatic</bookmark_value> <bookmark_value>name recognition on/off</bookmark_value> <bookmark_value>row headers;using in formulas</bookmark_value> <bookmark_value>column headers;using in formulas</bookmark_value> <bookmark_value>columns; finding labels automatically</bookmark_value> <bookmark_value>rows; finding labels automatically</bookmark_value> <bookmark_value>recognizing; column and row labels</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>automatic addressing in tables</bookmark_value> <bookmark_value>natural language addressing</bookmark_value> <bookmark_value>formulae; using row/column labels</bookmark_value><bookmark_value>text in cells; as addressing</bookmark_value> <bookmark_value>addressing; automatic</bookmark_value> <bookmark_value>name recognition on/off</bookmark_value> <bookmark_value>row headers;using in formulae</bookmark_value> <bookmark_value>column headers;using in formulae</bookmark_value> <bookmark_value>columns; finding labels automatically</bookmark_value> <bookmark_value>rows; finding labels automatically</bookmark_value> <bookmark_value>recognising; column and row labels</bookmark_value>" ], "id_hash": -2618259216785182995, "content_hash": -2618259216785182995, "location": "address_auto.xhp", "context": "address_auto.xhp\nbm_id3148797\nhelp.text", "note": "QvKmR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/110789322/?format=api", "priority": 100, "id": 111099703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=5baa131d4da06eed", "url": "https://translations.documentfoundation.org/api/units/111099703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.179978Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<variable id=\"address_auto\"><link href=\"text/scalc/guide/address_auto.xhp\">Recognizing Names as Addressing</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"address_auto\"><link href=\"text/scalc/guide/address_auto.xhp\">Recognising Names as Addressing</link></variable>" ], "id_hash": 2843299789716945717, "content_hash": 2843299789716945717, "location": "address_auto.xhp", "context": "address_auto.xhp\nhd_id3148797\nhelp.text", "note": "Jmw9V", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110789374/?format=api", "priority": 100, "id": 111099706, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=a7756e1824057b35", "url": "https://translations.documentfoundation.org/api/units/111099706/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.181822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "You can use cells with text to refer to the rows or to the columns that contain the cells." ], "previous_source": "", "target": [ "You can use cells with text to refer to the rows or to the columns that contain the cells." ], "id_hash": -968951528089362314, "content_hash": -968951528089362314, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3152597\nhelp.text", "note": "GgEvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110789419/?format=api", "priority": 100, "id": 111099709, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=728d97b80ba96076", "url": "https://translations.documentfoundation.org/api/units/111099709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.183259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<image id=\"img_id3154942\" src=\"media/helpimg/names_as_addressing.png\" width=\"5.408cm\" height=\"2.212cm\" localize=\"true\"><alt id=\"alt_id3154942\">Example spreadsheet</alt></image>" ], "previous_source": "", "target": [ "<image id=\"img_id3154942\" src=\"media/helpimg/names_as_addressing.png\" width=\"5.408cm\" height=\"2.212cm\" localize=\"true\"><alt id=\"alt_id3154942\">Example spreadsheet</alt></image>" ], "id_hash": -549976508408085760, "content_hash": -549976508408085760, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3156283\nhelp.text", "note": "jtGBH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110789474/?format=api", "priority": 100, "id": 111099713, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=785e17478d86c300", "url": "https://translations.documentfoundation.org/api/units/111099713/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.184729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "In the example spreadsheet, you can use the string <item type=\"literal\">'Column One'</item> in a formula to refer to the cell range <item type=\"literal\">B3</item> to <item type=\"literal\">B5</item>, or <item type=\"literal\">'Column Two'</item> for the cell range <item type=\"literal\">C2</item> to <item type=\"literal\">C5</item>. You can also use <item type=\"literal\">'Row One'</item> for the cell range <item type=\"literal\">B3</item> to <item type=\"literal\">D3</item>, or <item type=\"literal\">'Row Two'</item> for the cell range <item type=\"literal\">B4</item> to <item type=\"literal\">D4</item>. The result of a formula that uses a cell name, for example, <item type=\"literal\">SUM('Column One')</item>, is 600." ], "previous_source": "", "target": [ "In the example spreadsheet, you can use the string <item type=\"literal\">'Column One'</item> in a formula to refer to the cell range <item type=\"literal\">B3</item> to <item type=\"literal\">B5</item>, or <item type=\"literal\">'Column Two'</item> for the cell range <item type=\"literal\">C2</item> to <item type=\"literal\">C5</item>. You can also use <item type=\"literal\">'Row One'</item> for the cell range <item type=\"literal\">B3</item> to <item type=\"literal\">D3</item>, or <item type=\"literal\">'Row Two'</item> for the cell range <item type=\"literal\">B4</item> to <item type=\"literal\">D4</item>. The result of a formula that uses a cell name, for example, <item type=\"literal\">SUM('Column One')</item>, is 600." ], "id_hash": -2273895249157137658, "content_hash": -2273895249157137658, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3154512\nhelp.text", "note": "SFAp5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 85, "source_unit": "https://translations.documentfoundation.org/api/units/110789523/?format=api", "priority": 100, "id": 111099717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=60718051898a5b06", "url": "https://translations.documentfoundation.org/api/units/111099717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.186333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Automatically finding labels is a legacy feature and deactivated by default as it can produce nondeterministic behavior depending on actual document content. To turn this function on, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Calculate</emph> and mark the <emph>Automatically find column and row labels</emph> check box." ], "previous_source": "", "target": [ "" ], "id_hash": -1960537973897908654, "content_hash": -1960537973897908654, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3155443\nhelp.text", "note": "xYcEr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/110789551/?format=api", "priority": 100, "id": 111099720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=64cac519a126ae52", "url": "https://translations.documentfoundation.org/api/units/111099720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.188007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Using defined labels instead is always possible and behaves similar but in a defined way." ], "previous_source": "", "target": [ "" ], "id_hash": 8663444482731803990, "content_hash": 8663444482731803990, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3155444\nhelp.text", "note": "Q9Nee", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110789589/?format=api", "priority": 100, "id": 111099723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=f83abcdb2c8c0556", "url": "https://translations.documentfoundation.org/api/units/111099723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.189377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "If you enter a label name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must double it, for example, <item type=\"literal\">'Harry''s Bar'</item>." ], "previous_source": "", "target": [ "" ], "id_hash": 501467543676221291, "content_hash": 501467543676221291, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3149210\nhelp.text", "note": "ZuesG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110789637/?format=api", "priority": 100, "id": 111099726, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=86f59212f735776b", "url": "https://translations.documentfoundation.org/api/units/111099726/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.190611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Deactivating Automatic Changes" ], "previous_source": "", "target": [ "Deactivating Automatic Changes" ], "id_hash": 8632395923015566168, "content_hash": 8632395923015566168, "location": "auto_off.xhp", "context": "auto_off.xhp\ntit\nhelp.text", "note": "EXFye", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110789669/?format=api", "priority": 100, "id": 111099729, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=f7cc6e5b07df8358", "url": "https://translations.documentfoundation.org/api/units/111099729/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.192184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>deactivating; automatic changes</bookmark_value> <bookmark_value>tables; deactivating automatic changes in</bookmark_value> <bookmark_value>AutoInput function on/off</bookmark_value> <bookmark_value>text in cells;AutoInput function</bookmark_value> <bookmark_value>cells; AutoInput function of text</bookmark_value> <bookmark_value>input support in spreadsheets</bookmark_value> <bookmark_value>changing; input in cells</bookmark_value> <bookmark_value>AutoCorrect function;cell contents</bookmark_value> <bookmark_value>cell input;AutoInput function</bookmark_value> <bookmark_value>lowercase letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>capital letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>date formats;avoiding conversion to</bookmark_value> <bookmark_value>number completion on/off</bookmark_value> <bookmark_value>text completion on/off</bookmark_value> <bookmark_value>word completion on/off</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>deactivating; automatic changes</bookmark_value> <bookmark_value>tables; deactivating automatic changes in</bookmark_value> <bookmark_value>AutoInput function on/off</bookmark_value> <bookmark_value>text in cells;AutoInput function</bookmark_value> <bookmark_value>cells; AutoInput function of text</bookmark_value> <bookmark_value>input support in spreadsheets</bookmark_value> <bookmark_value>changing; input in cells</bookmark_value> <bookmark_value>AutoCorrect function;cell contents</bookmark_value> <bookmark_value>cell input;AutoInput function</bookmark_value> <bookmark_value>lowercase letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>capital letters;AutoInput function (in cells)</bookmark_value> <bookmark_value>date formats;avoiding conversion to</bookmark_value> <bookmark_value>number completion on/off</bookmark_value> <bookmark_value>text completion on/off</bookmark_value> <bookmark_value>word completion on/off</bookmark_value>" ], "id_hash": -5846986168472343833, "content_hash": -5846986168472343833, "location": "auto_off.xhp", "context": "auto_off.xhp\nbm_id3149456\nhelp.text", "note": "ADp2n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 57, "source_unit": "https://translations.documentfoundation.org/api/units/110789703/?format=api", "priority": 100, "id": 111099732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=2edb550ef5956ae7", "url": "https://translations.documentfoundation.org/api/units/111099732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.193855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<variable id=\"auto_off\"><link href=\"text/scalc/guide/auto_off.xhp\">Deactivating Automatic Changes</link> </variable>" ], "previous_source": "", "target": [ "<variable id=\"auto_off\"><link href=\"text/scalc/guide/auto_off.xhp\">Deactivating Automatic Changes</link> </variable>" ], "id_hash": 4235799967577302260, "content_hash": 4235799967577302260, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3149456\nhelp.text", "note": "GMvpd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110789740/?format=api", "priority": 100, "id": 111099735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=bac895a0d70e64f4", "url": "https://translations.documentfoundation.org/api/units/111099735/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.196030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z." ], "previous_source": "", "target": [ "By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z." ], "id_hash": -3070082387742087208, "content_hash": -3070082387742087208, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3156442\nhelp.text", "note": "4h6m4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110789779/?format=api", "priority": 100, "id": 111099741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=5564e055977327d8", "url": "https://translations.documentfoundation.org/api/units/111099741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.197948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:" ], "previous_source": "", "target": [ "The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:" ], "id_hash": -5802418890751097762, "content_hash": -5802418890751097762, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3145273\nhelp.text", "note": "EnE7s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110789811/?format=api", "priority": 100, "id": 111099744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=2f79aac2eac3c45e", "url": "https://translations.documentfoundation.org/api/units/111099744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.199588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Automatic Text or Number Completion" ], "previous_source": "", "target": [ "Automatic Text or Number Completion" ], "id_hash": 8608010070179227954, "content_hash": 8608010070179227954, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3145748\nhelp.text", "note": "K9vst", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110789851/?format=api", "priority": 100, "id": 111099748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=f775cb8d3804a932", "url": "https://translations.documentfoundation.org/api/units/111099748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.201074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>." ], "previous_source": "", "target": [ "When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>." ], "id_hash": -8962449408600152713, "content_hash": -8962449408600152713, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3154730\nhelp.text", "note": "9mHkN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110789872/?format=api", "priority": 100, "id": 111099751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=039efbbf7afa6577", "url": "https://translations.documentfoundation.org/api/units/111099751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.202704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "To turn the AutoInput on and off, set or remove the check mark in front of <link href=\"text/scalc/01/06130000.xhp\"><emph>Tools - AutoInput</emph></link>." ], "previous_source": "", "target": [ "To turn the AutoInput on and off, set or remove the check mark in front of <link href=\"text/scalc/01/06130000.xhp\"><emph>Tools - AutoInput</emph></link>." ], "id_hash": -8184904390303532280, "content_hash": -8184904390303532280, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3153878\nhelp.text", "note": "rPWCd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110789930/?format=api", "priority": 100, "id": 111099754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=0e6960d28f6c3b08", "url": "https://translations.documentfoundation.org/api/units/111099754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.204566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Automatic Conversion to Date Format" ], "previous_source": "", "target": [ "Automatic Conversion to Date Format" ], "id_hash": 1135498632736380953, "content_hash": 1135498632736380953, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3146972\nhelp.text", "note": "8G5gv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110789966/?format=api", "priority": 100, "id": 111099758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=8fc219fd87319819", "url": "https://translations.documentfoundation.org/api/units/111099758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:37.206149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "$[officename] Calc automatically converts certain entries to dates. For example, the entry <emph>1.1</emph> may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell." ], "previous_source": "", "target": [ "$[officename] Calc automatically converts certain entries to dates. For example, the entry <emph>1/1</emph> may be interpreted as 1st January of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell." ], "id_hash": -8252892676460323771, "content_hash": -8252892676460323771, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3153707\nhelp.text", "note": "JCMv7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/110789997/?format=api", "priority": 100, "id": 111099763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=0d77d5d62228dc45", "url": "https://translations.documentfoundation.org/api/units/111099763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.094954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell." ], "previous_source": "", "target": [ "To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell." ], "id_hash": 5519304792624856280, "content_hash": 5519304792624856280, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3159267\nhelp.text", "note": "afuu6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110790048/?format=api", "priority": 100, "id": 111099768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=cc9882776383fcd8", "url": "https://translations.documentfoundation.org/api/units/111099768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.098331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Quotation Marks Replaced by Custom Quotes" ], "previous_source": "", "target": [ "Quotation Marks Replaced by Custom Quotes" ], "id_hash": -5408029636462876496, "content_hash": -5408029636462876496, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3150043\nhelp.text", "note": "DzjZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110790082/?format=api", "priority": 100, "id": 111099772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=34f2d1b2d7d868b0", "url": "https://translations.documentfoundation.org/api/units/111099772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.100845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Choose <emph>Tools - AutoCorrect - AutoCorrect Options</emph>. Go to the <emph>Localized Options</emph> tab and unmark <emph>Replace</emph>." ], "previous_source": "", "target": [ "Choose <emph>Tools - AutoCorrect - AutoCorrect Options</emph>. Go to the <emph>Localised Options</emph> tab and unmark <emph>Replace</emph>." ], "id_hash": -8224294324898298414, "content_hash": -8224294324898298414, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3155333\nhelp.text", "note": "GYoEC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110790110/?format=api", "priority": 100, "id": 111099776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=0ddd6fe2bc2d05d2", "url": "https://translations.documentfoundation.org/api/units/111099776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.103042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Cell Content Always Begins With Uppercase" ], "previous_source": "", "target": [ "Cell Content Always Begins With Upper-case" ], "id_hash": -2069375993901916514, "content_hash": -2069375993901916514, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3149565\nhelp.text", "note": "j3GnW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110790146/?format=api", "priority": 100, "id": 111099785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=6348197f60c15e9e", "url": "https://translations.documentfoundation.org/api/units/111099785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.107756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type=\"menuitem\">Options</item> tab. Unmark <item type=\"menuitem\">Capitalize first letter of every sentence</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type=\"menuitem\">Options</item> tab. Unmark <item type=\"menuitem\">Capitalise first letter of every sentence</item>." ], "id_hash": -1675192992175980331, "content_hash": -1675192992175980331, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3147001\nhelp.text", "note": "qNqbR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110790209/?format=api", "priority": 100, "id": 111099788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=68c084d9632080d5", "url": "https://translations.documentfoundation.org/api/units/111099788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.233555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Replace Word With Another Word" ], "previous_source": "", "target": [ "Replace Word With Another Word" ], "id_hash": 4156665232431107443, "content_hash": 4156665232431107443, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3150345\nhelp.text", "note": "rwz87", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110790254/?format=api", "priority": 100, "id": 111099794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=b9af71018545cd73", "url": "https://translations.documentfoundation.org/api/units/111099794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.398411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type=\"menuitem\">Replace</item> tab. Select the word pair and click <item type=\"menuitem\">Delete</item>." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Tools - AutoCorrect - AutoCorrect Options</item>. Go to the <item type=\"menuitem\">Replace</item> tab. Select the word pair and click <item type=\"menuitem\">Delete</item>." ], "id_hash": -3589245029976640082, "content_hash": -3589245029976640082, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3166425\nhelp.text", "note": "VF6DN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110790293/?format=api", "priority": 100, "id": 111099800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=4e3070a97067f5ae", "url": "https://translations.documentfoundation.org/api/units/111099800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.404165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<link href=\"text/scalc/01/06130000.xhp\">Tools - AutoInput</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/06130000.xhp\">Tools - AutoInput</link>" ], "id_hash": -5412517964862785325, "content_hash": -5412517964862785325, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3152992\nhelp.text", "note": "HzAWS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110790338/?format=api", "priority": 100, "id": 111099806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=34e2df9673eef8d3", "url": "https://translations.documentfoundation.org/api/units/111099806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.407207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<link href=\"text/shared/01/06040000.xhp\">Tools - AutoCorrect - AutoCorrect Options</link>" ], "previous_source": "", "target": [ "<link href=\"text/shared/01/06040000.xhp\">Tools - AutoCorrect - AutoCorrect Options</link>" ], "id_hash": -5384184266359523465, "content_hash": -5384184266359523465, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3154368\nhelp.text", "note": "v9BGX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110790379/?format=api", "priority": 100, "id": 111099812, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=354788efb664b777", "url": "https://translations.documentfoundation.org/api/units/111099812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.409648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Applying AutoFilter" ], "previous_source": "", "target": [ "Applying AutoFilter" ], "id_hash": 2289536664326836908, "content_hash": 2289536664326836908, "location": "autofilter.xhp", "context": "autofilter.xhp\ntit\nhelp.text", "note": "tdzBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110790425/?format=api", "priority": 100, "id": 111099821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=9fc61177396f12ac", "url": "https://translations.documentfoundation.org/api/units/111099821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.414201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>filters, see also AutoFilter function</bookmark_value> <bookmark_value>AutoFilter function;applying</bookmark_value> <bookmark_value>sheets; filter values</bookmark_value> <bookmark_value>numbers; filter sheets</bookmark_value> <bookmark_value>columns; AutoFilter function</bookmark_value> <bookmark_value>drop-down menus in sheet columns</bookmark_value> <bookmark_value>database ranges; AutoFilter function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>filters, see also AutoFilter function</bookmark_value><bookmark_value>AutoFilter function;applying</bookmark_value><bookmark_value>sheets; filter values</bookmark_value><bookmark_value>numbers; filter sheets</bookmark_value><bookmark_value>columns; AutoFilter function</bookmark_value><bookmark_value>drop-down menus in sheet columns</bookmark_value><bookmark_value>database ranges; AutoFilter function</bookmark_value>" ], "id_hash": 976662393504721130, "content_hash": 976662393504721130, "location": "autofilter.xhp", "context": "autofilter.xhp\nbm_id3156423\nhelp.text", "note": "uegyb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110790468/?format=api", "priority": 100, "id": 111099827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=8d8dcd45b654e8ea", "url": "https://translations.documentfoundation.org/api/units/111099827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.576400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<variable id=\"autofilter\"><link href=\"text/scalc/guide/autofilter.xhp\">Applying AutoFilter</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"autofilter\"><link href=\"text/scalc/guide/autofilter.xhp\">Applying AutoFilter</link></variable>" ], "id_hash": 3618061451240354204, "content_hash": 3618061451240354204, "location": "autofilter.xhp", "context": "autofilter.xhp\nhd_id3156423\nhelp.text", "note": "ukKtB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110790510/?format=api", "priority": 100, "id": 111099831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=b235efb878b7319c", "url": "https://translations.documentfoundation.org/api/units/111099831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.580771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "The <emph>AutoFilter</emph> function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed." ], "previous_source": "", "target": [ "The <emph>AutoFilter</emph> function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed." ], "id_hash": -5587602563370476555, "content_hash": -5587602563370476555, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3147427\nhelp.text", "note": "7FoJn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110790551/?format=api", "priority": 100, "id": 111099838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=3274d912b03d9bf5", "url": "https://translations.documentfoundation.org/api/units/111099838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.590729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Select the columns you want to use AutoFilter on." ], "previous_source": "", "target": [ "Select the columns you want to use AutoFilter on." ], "id_hash": -9060792664524283062, "content_hash": -9060792664524283062, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3152576\nhelp.text", "note": "BCGPe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110790660/?format=api", "priority": 100, "id": 111099844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=02419913e790a34a", "url": "https://translations.documentfoundation.org/api/units/111099844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.596692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Choose <emph>Data - Filter - AutoFilter</emph>. The combo box arrows are visible in the first row of the range selected." ], "previous_source": "", "target": [ "Choose <emph>Data - Filter - AutoFilter</emph>. The combo box arrows are visible in the first row of the range selected." ], "id_hash": -2449247129656864853, "content_hash": -2449247129656864853, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3153157\nhelp.text", "note": "Qk7GY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110790690/?format=api", "priority": 100, "id": 111099847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=5e0286b655a84fab", "url": "https://translations.documentfoundation.org/api/units/111099847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:38.600826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Run the filter by clicking the drop-down arrow in the column heading and choosing an item." ], "previous_source": "", "target": [ "Run the filter by clicking the drop-down arrow in the column heading and choosing an item." ], "id_hash": -2325051793199586362, "content_hash": -2325051793199586362, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3154510\nhelp.text", "note": "dHkYY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110790753/?format=api", "priority": 100, "id": 111099853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=5fbbc1b675f423c6", "url": "https://translations.documentfoundation.org/api/units/111099853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.308060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Only those rows whose contents meet the filter criteria are displayed. The other rows are filtered. You can see if rows have been filtered from the discontinuous row numbers. The column that has been used for the filter is identified by a different color for the arrow button." ], "previous_source": "", "target": [ "Only those rows whose contents meet the filter criteria are displayed. The other rows are filtered. You can see if rows have been filtered from the discontinuous row numbers. The column that has been used for the filter is identified by a different arrow button colour." ], "id_hash": 1155316773537184929, "content_hash": 1155316773537184929, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3155064\nhelp.text", "note": "FDYaw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110790800/?format=api", "priority": 100, "id": 111099857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=9008827c01bbfca1", "url": "https://translations.documentfoundation.org/api/units/111099857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.311439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data." ], "previous_source": "", "target": [ "When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data." ], "id_hash": 1418742625903829124, "content_hash": 1418742625903829124, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id9216589\nhelp.text", "note": "BTbCP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110790836/?format=api", "priority": 100, "id": 111099864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=93b062e6c4b3e084", "url": "https://translations.documentfoundation.org/api/units/111099864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.316053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "To display all records again, select the <emph>all</emph> entry in the AutoFilter combo box. If you choose <emph>Standard</emph>, the <item type=\"menuitem\">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose \"Top 10\" to display the highest 10 values only." ], "previous_source": "", "target": [ "To display all records again, select the <emph>all</emph> entry in the AutoFilter combo box. If you choose <emph>Standard</emph>, the <item type=\"menuitem\">Standard Filter</item> dialogue box appears, allowing you to set up a standard filter. Choose \"Top 10\" to display the highest 10 values only." ], "id_hash": 6782277751909806759, "content_hash": 6782277751909806759, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3153714\nhelp.text", "note": "BXy3D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/110790886/?format=api", "priority": 100, "id": 111099870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=de1f7dae6a9e72a7", "url": "https://translations.documentfoundation.org/api/units/111099870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.320632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>." ], "previous_source": "", "target": [ "To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>." ], "id_hash": -5739801971707037703, "content_hash": -5739801971707037703, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3147340\nhelp.text", "note": "x9jTE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110790932/?format=api", "priority": 100, "id": 111099871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=305820847b50b7f9", "url": "https://translations.documentfoundation.org/api/units/111099871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.323002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "To assign different AutoFilters to different sheets, you must first define a database range on each sheet." ], "previous_source": "", "target": [ "To assign different AutoFilters to different sheets, you must first define a database range on each sheet." ], "id_hash": 463178554347096841, "content_hash": 463178554347096841, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id4303415\nhelp.text", "note": "mA8cY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110790976/?format=api", "priority": 100, "id": 111099872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=866d8a70ef700b09", "url": "https://translations.documentfoundation.org/api/units/111099872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.325208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href=\"text/scalc/01/04060106.xhp\">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account." ], "previous_source": "", "target": [ "The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href=\"text/scalc/01/04060106.xhp\">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account." ], "id_hash": -678949070156672257, "content_hash": -678949070156672257, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3159236\nhelp.text", "note": "tBXAy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 57, "source_unit": "https://translations.documentfoundation.org/api/units/110791003/?format=api", "priority": 100, "id": 111099874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=7693e36afcbad2ff", "url": "https://translations.documentfoundation.org/api/units/111099874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.327161Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<link href=\"text/scalc/01/12040100.xhp\">Data - Filter - AutoFilter</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/12040100.xhp\">Data - Filter - AutoFilter</link>" ], "id_hash": -6986457455363203802, "content_hash": -6986457455363203802, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3152985\nhelp.text", "note": "KZJNX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110791043/?format=api", "priority": 100, "id": 111099876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=1f0b1df5ceb25d26", "url": "https://translations.documentfoundation.org/api/units/111099876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.329255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<link href=\"text/scalc/01/04060106.xhp\">SUBTOTAL</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060106.xhp\">SUBTOTAL</link>" ], "id_hash": -5809024431850528666, "content_hash": -5809024431850528666, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3154484\nhelp.text", "note": "2Dn9i", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110791101/?format=api", "priority": 100, "id": 111099883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=2f62330e87fbe066", "url": "https://translations.documentfoundation.org/api/units/111099883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.413621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Using AutoFormat for Tables" ], "previous_source": "", "target": [ "Using AutoFormat for Tables" ], "id_hash": -3123169237320903048, "content_hash": -3123169237320903048, "location": "autoformat.xhp", "context": "autoformat.xhp\ntit\nhelp.text", "note": "XAtNE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110791160/?format=api", "priority": 100, "id": 111099898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=54a846203c0f5678", "url": "https://translations.documentfoundation.org/api/units/111099898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.430629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<bookmark_value>tables; AutoFormat</bookmark_value> <bookmark_value>AutoFormat cell ranges</bookmark_value> <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2790239433024961342, "content_hash": -2790239433024961342, "location": "autoformat.xhp", "context": "autoformat.xhp\nbm_id3155132\nhelp.text", "note": "V4grY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110791211/?format=api", "priority": 100, "id": 111099908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=59471404dc4284c2", "url": "https://translations.documentfoundation.org/api/units/111099908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.438016Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\">Applying Automatic Formatting to a Selected Cell Range</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\">Applying Automatic Formatting to a Selected Cell Range</link></variable>" ], "id_hash": 3009459584530297467, "content_hash": 3009459584530297467, "location": "autoformat.xhp", "context": "autoformat.xhp\nhd_id3155132\nhelp.text", "note": "PYXFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110791248/?format=api", "priority": 100, "id": 111099910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=a9c3bf8c1dd2b27b", "url": "https://translations.documentfoundation.org/api/units/111099910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.440208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Use the AutoFormat feature to quickly apply a format to a selected cell range." ], "previous_source": "", "target": [ "" ], "id_hash": -1134003913534547096, "content_hash": -1134003913534547096, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_id3149401\nhelp.text", "note": "7xexA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110791290/?format=api", "priority": 100, "id": 111099917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=70433572e7dedb68", "url": "https://translations.documentfoundation.org/api/units/111099917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.445539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Applying an AutoFormat to a Selected Cell Range" ], "previous_source": "", "target": [ "" ], "id_hash": 7886175913602755867, "content_hash": 7886175913602755867, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN10702\nhelp.text", "note": "rA9iM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110791346/?format=api", "priority": 100, "id": 111099922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=ed715335ee88ad1b", "url": "https://translations.documentfoundation.org/api/units/111099922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.447529Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Select the range of cells to which the AutoFormat style is to be applied. The range must be at least 3 columns and 3 rows in size." ], "previous_source": "", "target": [ "Select the range of cells to which the AutoFormat style is to be applied. The range must be at least 3 columns and 3 rows in size." ], "id_hash": 8805533876727140116, "content_hash": 8805533876727140116, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN106CE\nhelp.text", "note": "jDKjA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110791388/?format=api", "priority": 100, "id": 111099927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=fa338a683bfd4f14", "url": "https://translations.documentfoundation.org/api/units/111099927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.449394Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en_GB/?format=api", "source": [ "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialog." ], "previous_source": "", "target": [ "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialogue box." ], "id_hash": -2436206387823259970, "content_hash": -2436206387823259970, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN106D5\nhelp.text", "note": "6GCsB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110791418/?format=api", "priority": 100, "id": 111099930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/en_GB/?checksum=5e30db32a641cebe", "url": "https://translations.documentfoundation.org/api/units/111099930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:33:39.451151Z" } ] }