Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=17
{ "count": 4173, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=18", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=16", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>selection</emph>: An optional range that is initially selected when the dialog is displayed." ], "previous_source": "", "target": [ "" ], "id_hash": -772716012594369538, "content_hash": -772716012594369538, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id781592234124502\nhelp.text", "note": "Yyn74", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310145/?format=api", "priority": 100, "id": 111008006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=7546c2e16d0e6bfe", "url": "https://translations.documentfoundation.org/api/units/111008006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.415759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>singlecell</emph>: When <literal>True</literal> (default) only single-cell selection is allowed. When <literal>False</literal> range selection is allowed." ], "previous_source": "", "target": [ "" ], "id_hash": -2672483793505925648, "content_hash": -2672483793505925648, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id971592234138989\nhelp.text", "note": "zo7VK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110310159/?format=api", "priority": 100, "id": 111008008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=5ae96e26341745f0", "url": "https://translations.documentfoundation.org/api/units/111008008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.417624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>closeafterselect</emph>: When <literal>True</literal> (default) the dialog is closed immediately after the selection is made. When <literal>False</literal> the user can change the selection as many times as needed and then manually close the dialog." ], "previous_source": "", "target": [ "" ], "id_hash": 7070702548455325174, "content_hash": 7070702548455325174, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id321592234150345\nhelp.text", "note": "SqEWv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110310171/?format=api", "priority": 100, "id": 111008012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e2202e817120fdf6", "url": "https://translations.documentfoundation.org/api/units/111008012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.419369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Returns the input string after substituting its token characters by their values in a given range." ], "previous_source": "", "target": [ "" ], "id_hash": -7664163340564043173, "content_hash": -7664163340564043173, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id51592233503441\nhelp.text", "note": "yDiCm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110310184/?format=api", "priority": 100, "id": 111008014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=15a36c0c591bea5b", "url": "https://translations.documentfoundation.org/api/units/111008014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.421132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This method does not change the current selection." ], "previous_source": "", "target": [ "" ], "id_hash": 4322555184839872433, "content_hash": 4322555184839872433, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id551637936596521\nhelp.text", "note": "Qu4DK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310194/?format=api", "priority": 100, "id": 111008019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=bbfccd09ea674fb1", "url": "https://translations.documentfoundation.org/api/units/111008019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.422935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This method can be used to quickly extract specific parts of a range name, such as the sheet name or first cell column and row, and use them to compose a new range address." ], "previous_source": "", "target": [ "" ], "id_hash": -8457728853191797017, "content_hash": -8457728853191797017, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id171637938442558\nhelp.text", "note": "eEqCY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110310206/?format=api", "priority": 100, "id": 111008022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0aa01c6b42ee56e7", "url": "https://translations.documentfoundation.org/api/units/111008022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.424818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>inputstr</emph>: The string containing the tokens that will be replaced by the corresponding values in <literal>range</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 8049703205507295953, "content_hash": 8049703205507295953, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id901592233506232\nhelp.text", "note": "RAAVz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110310222/?format=api", "priority": 100, "id": 111008025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=efb64a6a8f95ead1", "url": "https://translations.documentfoundation.org/api/units/111008025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.426682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>range</emph>: A <literal>RangeName</literal> from which values will be extracted. If it contains a sheet name, the sheet must exist." ], "previous_source": "", "target": [ "" ], "id_hash": -1505090280811823016, "content_hash": -1505090280811823016, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id781592234161102\nhelp.text", "note": "NJdUy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110310235/?format=api", "priority": 100, "id": 111008029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=6b1cd85d29518058", "url": "https://translations.documentfoundation.org/api/units/111008029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.428631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>tokencharacter</emph>: Character used to identify tokens. By default \"%\" is the token character. The following tokens are accepted:" ], "previous_source": "", "target": [ "" ], "id_hash": -1262427081020030448, "content_hash": -1262427081020030448, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id971592234102889\nhelp.text", "note": "BgCCD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110310248/?format=api", "priority": 100, "id": 111008032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=6e7af54228f7c210", "url": "https://translations.documentfoundation.org/api/units/111008032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.430500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>%S</emph> - The sheet name containing the range, including single quotes when necessary." ], "previous_source": "", "target": [ "" ], "id_hash": 3553713159558029133, "content_hash": 3553713159558029133, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id261637943912156\nhelp.text", "note": "WTDwR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310264/?format=api", "priority": 100, "id": 111008035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b151534a4d165f4d", "url": "https://translations.documentfoundation.org/api/units/111008035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.432440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>%R1</emph> - The row number of the top left cell of the range." ], "previous_source": "", "target": [ "" ], "id_hash": 6985934078092301069, "content_hash": 6985934078092301069, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id441637943912380\nhelp.text", "note": "YHLeU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310273/?format=api", "priority": 100, "id": 111008036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e0f30607ecfcd30d", "url": "https://translations.documentfoundation.org/api/units/111008036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.434295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>%C1</emph> - The column letter of the top left cell of the range." ], "previous_source": "", "target": [ "" ], "id_hash": -6138695907082954712, "content_hash": -6138695907082954712, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id521637943912620\nhelp.text", "note": "joJi7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310276/?format=api", "priority": 100, "id": 111008042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=2acef898c22d1828", "url": "https://translations.documentfoundation.org/api/units/111008042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.443110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>%R2</emph> - The row number of the bottom right cell of the range." ], "previous_source": "", "target": [ "" ], "id_hash": -3451105947192940017, "content_hash": -3451105947192940017, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id371637943912860\nhelp.text", "note": "YAfmV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310278/?format=api", "priority": 100, "id": 111008045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=501b356cff53aa0f", "url": "https://translations.documentfoundation.org/api/units/111008045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.445090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>%C2</emph> - The column letter of the bottom right cell of the range." ], "previous_source": "", "target": [ "" ], "id_hash": -6315260021637654584, "content_hash": -6315260021637654584, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id291637943913116\nhelp.text", "note": "imuBD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310280/?format=api", "priority": 100, "id": 111008047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=285bb078520fd7c8", "url": "https://translations.documentfoundation.org/api/units/111008047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.446965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The example below extracts each element of the <literal>RangeName</literal> defined in <literal>sRange</literal> and uses them to compose a message." ], "previous_source": "", "target": [ "" ], "id_hash": -8177503027787853903, "content_hash": -8177503027787853903, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id941637943467476\nhelp.text", "note": "gpmpG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110310282/?format=api", "priority": 100, "id": 111008049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0e83ac528f060fb1", "url": "https://translations.documentfoundation.org/api/units/111008049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.448850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The <literal>Printf</literal> method can be combined with <literal>SetFormula</literal> to create formulas over multiple cells. For instance, consider a table with numeric values in the range \"A1:E10\" from which formulas are to be created to sum the values in each row and place the results in the range \"F1:F10\":" ], "previous_source": "", "target": [ "" ], "id_hash": 584309989269109366, "content_hash": 584309989269109366, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id241637944350648\nhelp.text", "note": "nbJ59", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110310284/?format=api", "priority": 100, "id": 111008050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=881be2d6e518fa76", "url": "https://translations.documentfoundation.org/api/units/111008050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.450868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Note the use of the \"$\" character" ], "previous_source": "", "target": [ "" ], "id_hash": -2679351647309045175, "content_hash": -2679351647309045175, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id371637944971921\nhelp.text", "note": "foAvd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310286/?format=api", "priority": 100, "id": 111008053, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=5ad107df61c96249", "url": "https://translations.documentfoundation.org/api/units/111008053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.452865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This method sends the contents of the given sheet to the default printer or to the printer defined by the <literal>SetPrinter</literal> method of the <literal>Document</literal> service." ], "previous_source": "", "target": [ "" ], "id_hash": 7406122946862284736, "content_hash": 7406122946862284736, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id156589200121138\nhelp.text", "note": "wBpRw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110310288/?format=api", "priority": 100, "id": 111008055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e6c7d594b2987fc0", "url": "https://translations.documentfoundation.org/api/units/111008055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.454814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Returns <literal>True</literal> if the sheet was successfully printed." ], "previous_source": "", "target": [ "" ], "id_hash": -8107400784741370944, "content_hash": -8107400784741370944, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id981611169416934\nhelp.text", "note": "BaDL9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310290/?format=api", "priority": 100, "id": 111008070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0f7cb9f0edc473c0", "url": "https://translations.documentfoundation.org/api/units/111008070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.504538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>sheetname</emph>: The sheet to print, default is the active sheet." ], "previous_source": "", "target": [ "" ], "id_hash": -1922559714937778685, "content_hash": -1922559714937778685, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id368519200121646\nhelp.text", "note": "CnNEC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 820, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110310292/?format=api", "priority": 100, "id": 111008073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=6551b2201ba84e03", "url": "https://translations.documentfoundation.org/api/units/111008073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.508634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages." ], "previous_source": "", "target": [ "" ], "id_hash": 9201432209263343104, "content_hash": 9201432209263343104, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211635436910093\nhelp.text", "note": "xk3k3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110310361/?format=api", "priority": 100, "id": 111008075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=ffb20dd7d1fab600", "url": "https://translations.documentfoundation.org/api/units/111008075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.511022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>copies</emph>: The number of copies. Default is 1." ], "previous_source": "", "target": [ "" ], "id_hash": -6702369392375306802, "content_hash": -6702369392375306802, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id141635436912146\nhelp.text", "note": "DBFDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310385/?format=api", "priority": 100, "id": 111008077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=22fc668c5e04e5ce", "url": "https://translations.documentfoundation.org/api/units/111008077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.513048Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Removes duplicate rows from a specified range. The comparison to determine if a given row is a duplicate is done based on a subset of columns in the range." ], "previous_source": "", "target": [ "" ], "id_hash": -8992493490692007524, "content_hash": -8992493490692007524, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id661591699086251\nhelp.text", "note": "64f3B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110310405/?format=api", "priority": 100, "id": 111008080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=03343ed0824a599c", "url": "https://translations.documentfoundation.org/api/units/111008080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.514853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This method returns a string containing the resulting range." ], "previous_source": "", "target": [ "" ], "id_hash": 5242790425679825518, "content_hash": 5242790425679825518, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id111674511007536\nhelp.text", "note": "2Fj4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110310420/?format=api", "priority": 100, "id": 111008083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=c8c2221d5a770a6e", "url": "https://translations.documentfoundation.org/api/units/111008083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.516582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The removal of duplicate rows is done starting at the first row in the range moving downwards, meaning that if two or more rows are duplicates then only the first one is kept." ], "previous_source": "", "target": [ "" ], "id_hash": -6177830313484190466, "content_hash": -6177830313484190466, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id831674511881468\nhelp.text", "note": "py5XZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110310651/?format=api", "priority": 100, "id": 111008100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=2a43f00fba227cfe", "url": "https://translations.documentfoundation.org/api/units/111008100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.554384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>range</emph>: The range from which duplicates will be removed, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": 8909504778874405614, "content_hash": 8909504778874405614, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699082900\nhelp.text", "note": "UxCsB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110310662/?format=api", "priority": 100, "id": 111008103, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=fba4eb644d7442ee", "url": "https://translations.documentfoundation.org/api/units/111008103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.556943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>columns</emph>: An array containing column numbers indicating which columns will be considered to determine if a row is a duplicate or not. If this argument is left blank, then only the first column is used. Items in this array must be in the interval between 1 and the range width." ], "previous_source": "", "target": [ "" ], "id_hash": -8889879456442722582, "content_hash": -8889879456442722582, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699082848\nhelp.text", "note": "WBeEc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110310669/?format=api", "priority": 100, "id": 111008106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=04a0cdbc26b056ea", "url": "https://translations.documentfoundation.org/api/units/111008106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.559482Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>header</emph>: Specifies whether the first row is a header row (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": -3860292765333136882, "content_hash": -3860292765333136882, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699082147\nhelp.text", "note": "C4DUZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110310685/?format=api", "priority": 100, "id": 111008110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=4a6d7c2ec14eda0e", "url": "https://translations.documentfoundation.org/api/units/111008110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.562009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>casesensitive</emph>: Specifies whether string comparisons are case-sensitive (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": 8018551054825895760, "content_hash": 8018551054825895760, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699082231\nhelp.text", "note": "sFJ5x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110310704/?format=api", "priority": 100, "id": 111008112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=ef479db3443b3750", "url": "https://translations.documentfoundation.org/api/units/111008112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.563702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>mode</emph>: Specifies what to do with duplicate rows. If <literal>mode = \"CLEAR\"</literal> then duplicates are simply removed from the sheet leaving the cells blank. If <literal>mode = \"COMPACT\"</literal> then duplicates are removed and empty rows are compacted up (Default = <literal>\"COMPACT\"</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": -2997600473415025425, "content_hash": -2997600473415025425, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699082446\nhelp.text", "note": "zhBuK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110310729/?format=api", "priority": 100, "id": 111008116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=566662405b8dfcef", "url": "https://translations.documentfoundation.org/api/units/111008116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.585706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Removes duplicate rows where values in column A are duplicate" ], "previous_source": "", "target": [ "" ], "id_hash": -5685219272445050224, "content_hash": -5685219272445050224, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id991674511267999\nhelp.text", "note": "CvYHu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110310748/?format=api", "priority": 100, "id": 111008118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=311a0b317bb54290", "url": "https://translations.documentfoundation.org/api/units/111008118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.588007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Note that all optional arguments use their default value" ], "previous_source": "", "target": [ "" ], "id_hash": -4570997699361118563, "content_hash": -4570997699361118563, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id401674511347995\nhelp.text", "note": "wMXKK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 832, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110310778/?format=api", "priority": 100, "id": 111008120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=40908dcf8473e69d", "url": "https://translations.documentfoundation.org/api/units/111008120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.589893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Removes duplicate rows considering that the first row contains headers" ], "previous_source": "", "target": [ "" ], "id_hash": -8801118365033770809, "content_hash": -8801118365033770809, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id31674511325842\nhelp.text", "note": "Dzbis", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110310800/?format=api", "priority": 100, "id": 111008123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=05dc257a31fed0c7", "url": "https://translations.documentfoundation.org/api/units/111008123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.591624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Columns A and B are used to determine if a row is a duplicate" ], "previous_source": "", "target": [ "" ], "id_hash": -8407643724757947529, "content_hash": -8407643724757947529, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id11674511430892\nhelp.text", "note": "H5o2W", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110310833/?format=api", "priority": 100, "id": 111008128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0b520c93f3c2ab77", "url": "https://translations.documentfoundation.org/api/units/111008128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.595444Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Cells containing duplicate values are left blank" ], "previous_source": "", "target": [ "" ], "id_hash": -4844633085307583844, "content_hash": -4844633085307583844, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941674511492390\nhelp.text", "note": "vgiBA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310851/?format=api", "priority": 100, "id": 111008135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=3cc467e07b23029c", "url": "https://translations.documentfoundation.org/api/units/111008135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.599592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Removes an existing sheet from the document." ], "previous_source": "", "target": [ "" ], "id_hash": 3655751650766956187, "content_hash": 3655751650766956187, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id661591699085351\nhelp.text", "note": "C8abL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110310874/?format=api", "priority": 100, "id": 111008138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b2bbd6c1e303269b", "url": "https://translations.documentfoundation.org/api/units/111008138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.603567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to remove." ], "previous_source": "", "target": [ "" ], "id_hash": -861711971380784070, "content_hash": -861711971380784070, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331591699085330\nhelp.text", "note": "dVxiA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310880/?format=api", "priority": 100, "id": 111008140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=740a95870f25943a", "url": "https://translations.documentfoundation.org/api/units/111008140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.605553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Renames the given sheet and returns <literal>True</literal> if successful." ], "previous_source": "", "target": [ "" ], "id_hash": 8266727991965457143, "content_hash": 8266727991965457143, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id971591704316873\nhelp.text", "note": "GwKHr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110310893/?format=api", "priority": 100, "id": 111008147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=f2b9514f47e11af7", "url": "https://translations.documentfoundation.org/api/units/111008147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.617472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to rename." ], "previous_source": "", "target": [ "" ], "id_hash": 2574359091555468289, "content_hash": 2574359091555468289, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id161591704316337\nhelp.text", "note": "ofAiN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 839, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110310925/?format=api", "priority": 100, "id": 111008153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=a3b9f5f448760401", "url": "https://translations.documentfoundation.org/api/units/111008153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.621284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>newname</emph>: the new name of the sheet. It must not exist yet." ], "previous_source": "", "target": [ "" ], "id_hash": 6238430404663439726, "content_hash": 6238430404663439726, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id931591704316998\nhelp.text", "note": "JHEDe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110311038/?format=api", "priority": 100, "id": 111008167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=d6935b6681f5f16e", "url": "https://translations.documentfoundation.org/api/units/111008167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.647152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This example renames the active sheet to \"SheetY\":" ], "previous_source": "", "target": [ "" ], "id_hash": 2489137102933664675, "content_hash": 2489137102933664675, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351611775260443\nhelp.text", "note": "bwtAA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110311050/?format=api", "priority": 100, "id": 111008171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=a28b3101d19b23a3", "url": "https://translations.documentfoundation.org/api/units/111008171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.649003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>value</literal> argument. Vectors are always expanded vertically." ], "previous_source": "", "target": [ "" ], "id_hash": -8273661404829583938, "content_hash": -8273661404829583938, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191592745582983\nhelp.text", "note": "qEM6N", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 842, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/110311075/?format=api", "priority": 100, "id": 111008173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0d2e0cc9bd45f5be", "url": "https://translations.documentfoundation.org/api/units/111008173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.650742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The method returns a string representing the modified area as a range of cells." ], "previous_source": "", "target": [ "" ], "id_hash": -6358930716030275785, "content_hash": -6358930716030275785, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id671592745582573\nhelp.text", "note": "tm6AR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110311088/?format=api", "priority": 100, "id": 111008177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=27c08a346fb1ef37", "url": "https://translations.documentfoundation.org/api/units/111008177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.652456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>targetcell</emph>: The cell or a range as a string from where to start to store the given value." ], "previous_source": "", "target": [ "" ], "id_hash": 7215120892737357159, "content_hash": 7215120892737357159, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id801592745582116\nhelp.text", "note": "FAuKq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110311089/?format=api", "priority": 100, "id": 111008182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e42142397f1c0567", "url": "https://translations.documentfoundation.org/api/units/111008182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.654181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>value</emph>: A scalar, a vector or an array (in Python, one or two-dimensional lists and tuples) with the new values to be stored from the target cell or from the top-left corner of the range if <literal>targetcell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied." ], "previous_source": "", "target": [ "" ], "id_hash": 4773076787910439492, "content_hash": 4773076787910439492, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id321592745582192\nhelp.text", "note": "aK7EZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/110311090/?format=api", "priority": 100, "id": 111008186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=c23d600cbd107244", "url": "https://translations.documentfoundation.org/api/units/111008186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.655901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The following example uses the builtin <link href=\"text/sbasic/shared/03104300.xhp\">DimArray function</link> to create an array and then store it in cell \"A1\":" ], "previous_source": "", "target": [ "" ], "id_hash": -7609560184362149706, "content_hash": -7609560184362149706, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id331611776151376\nhelp.text", "note": "eAuMT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110311115/?format=api", "priority": 100, "id": 111008189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=166569545a2358b6", "url": "https://translations.documentfoundation.org/api/units/111008189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.657631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This example uses the <literal>RangeInit</literal> method of the <link href=\"text/sbasic/shared/03/sf_array.xhp#RangeInit\">ScriptForge Array service</link> to create an array with values that are then stored from cell \"A1\" and downwards." ], "previous_source": "", "target": [ "" ], "id_hash": 567727770175809918, "content_hash": 567727770175809918, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601611775600983\nhelp.text", "note": "AheUb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110311143/?format=api", "priority": 100, "id": 111008192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=87e0f9662674297e", "url": "https://translations.documentfoundation.org/api/units/111008192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.659229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "'Fill 1st column with values from 1 to 1000" ], "previous_source": "", "target": [ "" ], "id_hash": -846900116507927399, "content_hash": -846900116507927399, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id251592745582536\nhelp.text", "note": "kmatN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110311162/?format=api", "priority": 100, "id": 111008195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=743f34d4c34edc99", "url": "https://translations.documentfoundation.org/api/units/111008195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.660855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "To dump the full contents of an array in a sheet, use <emph>SetArray</emph>. To dump the contents of an array only within the boundaries of the targeted range of cells, use <emph>SetValue</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -4848943881389293524, "content_hash": -4848943881389293524, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id291592905671530\nhelp.text", "note": "YNGtV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110311211/?format=api", "priority": 100, "id": 111008197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=3cb5173b0dfcc02c", "url": "https://translations.documentfoundation.org/api/units/111008197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.662627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Applies the specified cell style to the given target range. The full range is updated and the remainder of the sheet is left untouched. If the cell style does not exist, an error is raised." ], "previous_source": "", "target": [ "" ], "id_hash": -2973567181397501715, "content_hash": -2973567181397501715, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id521595767687154\nhelp.text", "note": "g8mER", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110311248/?format=api", "priority": 100, "id": 111008202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=56bbc467350ad8ed", "url": "https://translations.documentfoundation.org/api/units/111008202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:46.664607Z" } ] }