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/axm/units/?format=api
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Recognizing Names as Addressing" ], "previous_source": "", "target": [ "" ], "id_hash": 7168437723810012455, "content_hash": 7168437723810012455, "location": "address_auto.xhp", "context": "address_auto.xhp\ntit\nhelp.text", "note": "NXy6S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=e37b68213a349d27", "url": "https://translations.documentfoundation.org/api/units/110877851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.085208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -2618259216785182995, "content_hash": -2618259216785182995, "location": "address_auto.xhp", "context": "address_auto.xhp\nbm_id3148797\nhelp.text", "note": "QvKmR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=5baa131d4da06eed", "url": "https://translations.documentfoundation.org/api/units/110877852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.087220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<variable id=\"address_auto\"><link href=\"text/scalc/guide/address_auto.xhp\">Recognizing Names as Addressing</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2843299789716945717, "content_hash": 2843299789716945717, "location": "address_auto.xhp", "context": "address_auto.xhp\nhd_id3148797\nhelp.text", "note": "Jmw9V", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=a7756e1824057b35", "url": "https://translations.documentfoundation.org/api/units/110877853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.089056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -968951528089362314, "content_hash": -968951528089362314, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3152597\nhelp.text", "note": "GgEvz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=728d97b80ba96076", "url": "https://translations.documentfoundation.org/api/units/110877854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.090755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -549976508408085760, "content_hash": -549976508408085760, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3156283\nhelp.text", "note": "jtGBH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=785e17478d86c300", "url": "https://translations.documentfoundation.org/api/units/110877855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.092452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -2273895249157137658, "content_hash": -2273895249157137658, "location": "address_auto.xhp", "context": "address_auto.xhp\npar_id3154512\nhelp.text", "note": "SFAp5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=60718051898a5b06", "url": "https://translations.documentfoundation.org/api/units/110877856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.093781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=64cac519a126ae52", "url": "https://translations.documentfoundation.org/api/units/110877857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.094849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877858, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=f83abcdb2c8c0556", "url": "https://translations.documentfoundation.org/api/units/110877858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.096074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=86f59212f735776b", "url": "https://translations.documentfoundation.org/api/units/110877859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.097133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Deactivating Automatic Changes" ], "previous_source": "", "target": [ "" ], "id_hash": 8632395923015566168, "content_hash": 8632395923015566168, "location": "auto_off.xhp", "context": "auto_off.xhp\ntit\nhelp.text", "note": "EXFye", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=f7cc6e5b07df8358", "url": "https://translations.documentfoundation.org/api/units/110877860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.098203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -5846986168472343833, "content_hash": -5846986168472343833, "location": "auto_off.xhp", "context": "auto_off.xhp\nbm_id3149456\nhelp.text", "note": "ADp2n", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=2edb550ef5956ae7", "url": "https://translations.documentfoundation.org/api/units/110877861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.099219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<variable id=\"auto_off\"><link href=\"text/scalc/guide/auto_off.xhp\">Deactivating Automatic Changes</link> </variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4235799967577302260, "content_hash": 4235799967577302260, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3149456\nhelp.text", "note": "GMvpd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=bac895a0d70e64f4", "url": "https://translations.documentfoundation.org/api/units/110877862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.100495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -3070082387742087208, "content_hash": -3070082387742087208, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3156442\nhelp.text", "note": "4h6m4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=5564e055977327d8", "url": "https://translations.documentfoundation.org/api/units/110877863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.101575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:" ], "previous_source": "", "target": [ "" ], "id_hash": -5802418890751097762, "content_hash": -5802418890751097762, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3145273\nhelp.text", "note": "EnE7s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=2f79aac2eac3c45e", "url": "https://translations.documentfoundation.org/api/units/110877864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.102680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Automatic Text or Number Completion" ], "previous_source": "", "target": [ "" ], "id_hash": 8608010070179227954, "content_hash": 8608010070179227954, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3145748\nhelp.text", "note": "K9vst", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=f775cb8d3804a932", "url": "https://translations.documentfoundation.org/api/units/110877868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.200883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -8962449408600152713, "content_hash": -8962449408600152713, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3154730\nhelp.text", "note": "9mHkN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=039efbbf7afa6577", "url": "https://translations.documentfoundation.org/api/units/110877889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.216956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -8184904390303532280, "content_hash": -8184904390303532280, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3153878\nhelp.text", "note": "rPWCd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=0e6960d28f6c3b08", "url": "https://translations.documentfoundation.org/api/units/110877891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.218606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Automatic Conversion to Date Format" ], "previous_source": "", "target": [ "" ], "id_hash": 1135498632736380953, "content_hash": 1135498632736380953, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3146972\nhelp.text", "note": "8G5gv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=8fc219fd87319819", "url": "https://translations.documentfoundation.org/api/units/110877893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.219817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -8252892676460323771, "content_hash": -8252892676460323771, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3153707\nhelp.text", "note": "JCMv7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=0d77d5d62228dc45", "url": "https://translations.documentfoundation.org/api/units/110877895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.220889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 5519304792624856280, "content_hash": 5519304792624856280, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3159267\nhelp.text", "note": "afuu6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=cc9882776383fcd8", "url": "https://translations.documentfoundation.org/api/units/110877897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.221956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Quotation Marks Replaced by Custom Quotes" ], "previous_source": "", "target": [ "" ], "id_hash": -5408029636462876496, "content_hash": -5408029636462876496, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3150043\nhelp.text", "note": "DzjZv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=34f2d1b2d7d868b0", "url": "https://translations.documentfoundation.org/api/units/110877899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.222995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -8224294324898298414, "content_hash": -8224294324898298414, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3155333\nhelp.text", "note": "GYoEC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=0ddd6fe2bc2d05d2", "url": "https://translations.documentfoundation.org/api/units/110877901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.224048Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Cell Content Always Begins With Uppercase" ], "previous_source": "", "target": [ "" ], "id_hash": -2069375993901916514, "content_hash": -2069375993901916514, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3149565\nhelp.text", "note": "j3GnW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=6348197f60c15e9e", "url": "https://translations.documentfoundation.org/api/units/110877903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.225101Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -1675192992175980331, "content_hash": -1675192992175980331, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3147001\nhelp.text", "note": "qNqbR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=68c084d9632080d5", "url": "https://translations.documentfoundation.org/api/units/110877905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.226160Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Replace Word With Another Word" ], "previous_source": "", "target": [ "" ], "id_hash": 4156665232431107443, "content_hash": 4156665232431107443, "location": "auto_off.xhp", "context": "auto_off.xhp\nhd_id3150345\nhelp.text", "note": "rwz87", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=b9af71018545cd73", "url": "https://translations.documentfoundation.org/api/units/110877907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.227250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -3589245029976640082, "content_hash": -3589245029976640082, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3166425\nhelp.text", "note": "VF6DN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=4e3070a97067f5ae", "url": "https://translations.documentfoundation.org/api/units/110877909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.228316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<link href=\"text/scalc/01/06130000.xhp\">Tools - AutoInput</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5412517964862785325, "content_hash": -5412517964862785325, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3152992\nhelp.text", "note": "HzAWS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=34e2df9673eef8d3", "url": "https://translations.documentfoundation.org/api/units/110877911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.229389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<link href=\"text/shared/01/06040000.xhp\">Tools - AutoCorrect - AutoCorrect Options</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5384184266359523465, "content_hash": -5384184266359523465, "location": "auto_off.xhp", "context": "auto_off.xhp\npar_id3154368\nhelp.text", "note": "v9BGX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=354788efb664b777", "url": "https://translations.documentfoundation.org/api/units/110877913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.230434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Applying AutoFilter" ], "previous_source": "", "target": [ "" ], "id_hash": 2289536664326836908, "content_hash": 2289536664326836908, "location": "autofilter.xhp", "context": "autofilter.xhp\ntit\nhelp.text", "note": "tdzBC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=9fc61177396f12ac", "url": "https://translations.documentfoundation.org/api/units/110877915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.231459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 976662393504721130, "content_hash": 976662393504721130, "location": "autofilter.xhp", "context": "autofilter.xhp\nbm_id3156423\nhelp.text", "note": "uegyb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=8d8dcd45b654e8ea", "url": "https://translations.documentfoundation.org/api/units/110877917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.232494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<variable id=\"autofilter\"><link href=\"text/scalc/guide/autofilter.xhp\">Applying AutoFilter</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3618061451240354204, "content_hash": 3618061451240354204, "location": "autofilter.xhp", "context": "autofilter.xhp\nhd_id3156423\nhelp.text", "note": "ukKtB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=b235efb878b7319c", "url": "https://translations.documentfoundation.org/api/units/110877919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.233595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -5587602563370476555, "content_hash": -5587602563370476555, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3147427\nhelp.text", "note": "7FoJn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=3274d912b03d9bf5", "url": "https://translations.documentfoundation.org/api/units/110877921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.234716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Select the columns you want to use AutoFilter on." ], "previous_source": "", "target": [ "" ], "id_hash": -9060792664524283062, "content_hash": -9060792664524283062, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3152576\nhelp.text", "note": "BCGPe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=02419913e790a34a", "url": "https://translations.documentfoundation.org/api/units/110877923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.235878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -2449247129656864853, "content_hash": -2449247129656864853, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3153157\nhelp.text", "note": "Qk7GY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=5e0286b655a84fab", "url": "https://translations.documentfoundation.org/api/units/110877925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.237012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Run the filter by clicking the drop-down arrow in the column heading and choosing an item." ], "previous_source": "", "target": [ "" ], "id_hash": -2325051793199586362, "content_hash": -2325051793199586362, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3154510\nhelp.text", "note": "dHkYY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=5fbbc1b675f423c6", "url": "https://translations.documentfoundation.org/api/units/110877927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.238140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 1155316773537184929, "content_hash": 1155316773537184929, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3155064\nhelp.text", "note": "FDYaw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=9008827c01bbfca1", "url": "https://translations.documentfoundation.org/api/units/110877929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.239290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 1418742625903829124, "content_hash": 1418742625903829124, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id9216589\nhelp.text", "note": "BTbCP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=93b062e6c4b3e084", "url": "https://translations.documentfoundation.org/api/units/110877931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.240450Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 6782277751909806759, "content_hash": 6782277751909806759, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3153714\nhelp.text", "note": "BXy3D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=de1f7dae6a9e72a7", "url": "https://translations.documentfoundation.org/api/units/110877933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.241557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -5739801971707037703, "content_hash": -5739801971707037703, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3147340\nhelp.text", "note": "x9jTE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=305820847b50b7f9", "url": "https://translations.documentfoundation.org/api/units/110877936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.242670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "To assign different AutoFilters to different sheets, you must first define a database range on each sheet." ], "previous_source": "", "target": [ "" ], "id_hash": 463178554347096841, "content_hash": 463178554347096841, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id4303415\nhelp.text", "note": "mA8cY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=866d8a70ef700b09", "url": "https://translations.documentfoundation.org/api/units/110877938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.243812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": -678949070156672257, "content_hash": -678949070156672257, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3159236\nhelp.text", "note": "tBXAy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=7693e36afcbad2ff", "url": "https://translations.documentfoundation.org/api/units/110877940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.244989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<link href=\"text/scalc/01/12040100.xhp\">Data - Filter - AutoFilter</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -6986457455363203802, "content_hash": -6986457455363203802, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3152985\nhelp.text", "note": "KZJNX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=1f0b1df5ceb25d26", "url": "https://translations.documentfoundation.org/api/units/110877942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.246264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "<link href=\"text/scalc/01/04060106.xhp\">SUBTOTAL</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5809024431850528666, "content_hash": -5809024431850528666, "location": "autofilter.xhp", "context": "autofilter.xhp\npar_id3154484\nhelp.text", "note": "2Dn9i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=2f62330e87fbe066", "url": "https://translations.documentfoundation.org/api/units/110877944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.247403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Using AutoFormat for Tables" ], "previous_source": "", "target": [ "" ], "id_hash": -3123169237320903048, "content_hash": -3123169237320903048, "location": "autoformat.xhp", "context": "autoformat.xhp\ntit\nhelp.text", "note": "XAtNE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=54a846203c0f5678", "url": "https://translations.documentfoundation.org/api/units/110877945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.248407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=59471404dc4284c2", "url": "https://translations.documentfoundation.org/api/units/110877946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.249344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 3009459584530297467, "content_hash": 3009459584530297467, "location": "autoformat.xhp", "context": "autoformat.xhp\nhd_id3155132\nhelp.text", "note": "PYXFN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=a9c3bf8c1dd2b27b", "url": "https://translations.documentfoundation.org/api/units/110877947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.263598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=70433572e7dedb68", "url": "https://translations.documentfoundation.org/api/units/110877953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.266568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": 110877959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=ed715335ee88ad1b", "url": "https://translations.documentfoundation.org/api/units/110877959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.269760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?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": [ "" ], "id_hash": 8805533876727140116, "content_hash": 8805533876727140116, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN106CE\nhelp.text", "note": "jDKjA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=fa338a683bfd4f14", "url": "https://translations.documentfoundation.org/api/units/110877971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.274758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/axm/?format=api", "source": [ "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -2436206387823259970, "content_hash": -2436206387823259970, "location": "autoformat.xhp", "context": "autoformat.xhp\npar_idN106D5\nhelp.text", "note": "6GCsB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 110877975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/axm/?checksum=5e30db32a641cebe", "url": "https://translations.documentfoundation.org/api/units/110877975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:26:56.276753Z" } ] }{ "count": 1558, "next": "