Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsbasicshared03/axm/units/?format=api&page=17
{ "count": 3638, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/units/?format=api&page=18", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/units/?format=api&page=16", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/98577840/?format=api", "priority": 100, "id": 98759619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=6b1cd85d29518058", "url": "https://translations.documentfoundation.org/api/units/98759619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.801919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98577859/?format=api", "priority": 100, "id": 98759620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=6e7af54228f7c210", "url": "https://translations.documentfoundation.org/api/units/98759620/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.802676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98577924/?format=api", "priority": 100, "id": 98759621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=b151534a4d165f4d", "url": "https://translations.documentfoundation.org/api/units/98759621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.803418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98577976/?format=api", "priority": 100, "id": 98759622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=e0f30607ecfcd30d", "url": "https://translations.documentfoundation.org/api/units/98759622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.804162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98578025/?format=api", "priority": 100, "id": 98759623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=2acef898c22d1828", "url": "https://translations.documentfoundation.org/api/units/98759623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.804955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98578083/?format=api", "priority": 100, "id": 98759624, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=501b356cff53aa0f", "url": "https://translations.documentfoundation.org/api/units/98759624/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.805693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98578098/?format=api", "priority": 100, "id": 98759625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=285bb078520fd7c8", "url": "https://translations.documentfoundation.org/api/units/98759625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.806435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/98578106/?format=api", "priority": 100, "id": 98759626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=0e83ac528f060fb1", "url": "https://translations.documentfoundation.org/api/units/98759626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.807166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/98578128/?format=api", "priority": 100, "id": 98759627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=881be2d6e518fa76", "url": "https://translations.documentfoundation.org/api/units/98759627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.807936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578154/?format=api", "priority": 100, "id": 98759628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=5ad107df61c96249", "url": "https://translations.documentfoundation.org/api/units/98759628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.808752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/98578176/?format=api", "priority": 100, "id": 98759629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=e6c7d594b2987fc0", "url": "https://translations.documentfoundation.org/api/units/98759629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.809488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578197/?format=api", "priority": 100, "id": 98759630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=0f7cb9f0edc473c0", "url": "https://translations.documentfoundation.org/api/units/98759630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.810251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/98578227/?format=api", "priority": 100, "id": 98759631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=6551b2201ba84e03", "url": "https://translations.documentfoundation.org/api/units/98759631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.810979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/98578248/?format=api", "priority": 100, "id": 98759632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=ffb20dd7d1fab600", "url": "https://translations.documentfoundation.org/api/units/98759632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.811779Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578265/?format=api", "priority": 100, "id": 98759633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=22fc668c5e04e5ce", "url": "https://translations.documentfoundation.org/api/units/98759633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.812576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/98578294/?format=api", "priority": 100, "id": 98759634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=03343ed0824a599c", "url": "https://translations.documentfoundation.org/api/units/98759634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.813319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98578329/?format=api", "priority": 100, "id": 98759635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=c8c2221d5a770a6e", "url": "https://translations.documentfoundation.org/api/units/98759635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.814077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/98578355/?format=api", "priority": 100, "id": 98759636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=2a43f00fba227cfe", "url": "https://translations.documentfoundation.org/api/units/98759636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.814811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/98578384/?format=api", "priority": 100, "id": 98759637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=fba4eb644d7442ee", "url": "https://translations.documentfoundation.org/api/units/98759637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.815567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 820, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/98578442/?format=api", "priority": 100, "id": 98759638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=04a0cdbc26b056ea", "url": "https://translations.documentfoundation.org/api/units/98759638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.816355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98578461/?format=api", "priority": 100, "id": 98759639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=4a6d7c2ec14eda0e", "url": "https://translations.documentfoundation.org/api/units/98759639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.817142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/98578489/?format=api", "priority": 100, "id": 98759640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=ef479db3443b3750", "url": "https://translations.documentfoundation.org/api/units/98759640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.817883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/98578508/?format=api", "priority": 100, "id": 98759641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=566662405b8dfcef", "url": "https://translations.documentfoundation.org/api/units/98759641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.818654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/98578572/?format=api", "priority": 100, "id": 98759642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=311a0b317bb54290", "url": "https://translations.documentfoundation.org/api/units/98759642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.819445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/98578631/?format=api", "priority": 100, "id": 98759643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=40908dcf8473e69d", "url": "https://translations.documentfoundation.org/api/units/98759643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.820175Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/98578659/?format=api", "priority": 100, "id": 98759644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=05dc257a31fed0c7", "url": "https://translations.documentfoundation.org/api/units/98759644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.820914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98578691/?format=api", "priority": 100, "id": 98759645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=0b520c93f3c2ab77", "url": "https://translations.documentfoundation.org/api/units/98759645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.821645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578739/?format=api", "priority": 100, "id": 98759646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=3cc467e07b23029c", "url": "https://translations.documentfoundation.org/api/units/98759646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.822378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/98578762/?format=api", "priority": 100, "id": 98759647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=b2bbd6c1e303269b", "url": "https://translations.documentfoundation.org/api/units/98759647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.823102Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578846/?format=api", "priority": 100, "id": 98759648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=740a95870f25943a", "url": "https://translations.documentfoundation.org/api/units/98759648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.823835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98578904/?format=api", "priority": 100, "id": 98759649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=f2b9514f47e11af7", "url": "https://translations.documentfoundation.org/api/units/98759649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.824620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 832, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98578943/?format=api", "priority": 100, "id": 98759650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=a3b9f5f448760401", "url": "https://translations.documentfoundation.org/api/units/98759650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.825366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/98578993/?format=api", "priority": 100, "id": 98759651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=d6935b6681f5f16e", "url": "https://translations.documentfoundation.org/api/units/98759651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.826093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98579024/?format=api", "priority": 100, "id": 98759652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=a28b3101d19b23a3", "url": "https://translations.documentfoundation.org/api/units/98759652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.826824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/98579064/?format=api", "priority": 100, "id": 98759653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=0d2e0cc9bd45f5be", "url": "https://translations.documentfoundation.org/api/units/98759653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.827581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98579091/?format=api", "priority": 100, "id": 98759654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=27c08a346fb1ef37", "url": "https://translations.documentfoundation.org/api/units/98759654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.828367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98579128/?format=api", "priority": 100, "id": 98759655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=e42142397f1c0567", "url": "https://translations.documentfoundation.org/api/units/98759655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.829111Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/98579171/?format=api", "priority": 100, "id": 98759656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=c23d600cbd107244", "url": "https://translations.documentfoundation.org/api/units/98759656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.829862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 839, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/98579196/?format=api", "priority": 100, "id": 98759657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=166569545a2358b6", "url": "https://translations.documentfoundation.org/api/units/98759657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.830690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/98579224/?format=api", "priority": 100, "id": 98759658, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=87e0f9662674297e", "url": "https://translations.documentfoundation.org/api/units/98759658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.831458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98579228/?format=api", "priority": 100, "id": 98759659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=743f34d4c34edc99", "url": "https://translations.documentfoundation.org/api/units/98759659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.832247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 842, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/98579271/?format=api", "priority": 100, "id": 98759660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=3cb5173b0dfcc02c", "url": "https://translations.documentfoundation.org/api/units/98759660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.833001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?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": 843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/98579281/?format=api", "priority": 100, "id": 98759661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=56bbc467350ad8ed", "url": "https://translations.documentfoundation.org/api/units/98759661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.833780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "The method returns a string representing the modified area as a range of cells." ], "previous_source": "", "target": [ "" ], "id_hash": -1292493768822549976, "content_hash": -1292493768822549976, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id70159576768715\nhelp.text", "note": "nxDCd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98579297/?format=api", "priority": 100, "id": 98759662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=6e1023c3e2ed1228", "url": "https://translations.documentfoundation.org/api/units/98759662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.834553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "<emph>targetrange</emph>: The range to which the style will be applied, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": 2396024459415207352, "content_hash": 2396024459415207352, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id22159576768782\nhelp.text", "note": "FtFpL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98579312/?format=api", "priority": 100, "id": 98759663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=a140638d18973db8", "url": "https://translations.documentfoundation.org/api/units/98759663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.835284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "<emph>style</emph>: The name of the cell style to apply." ], "previous_source": "", "target": [ "" ], "id_hash": 8486390493891208697, "content_hash": 8486390493891208697, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id181595767687247\nhelp.text", "note": "aAGcy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98579348/?format=api", "priority": 100, "id": 98759664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=f5c5b730fda325f9", "url": "https://translations.documentfoundation.org/api/units/98759664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.836024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\"><literal>ClearAll</literal></link> method documentation for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -9670167350139542, "content_hash": -9670167350139542, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461670942481294\nhelp.text", "note": "oU8ui", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98579369/?format=api", "priority": 100, "id": 98759665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=7fdda508b62d256a", "url": "https://translations.documentfoundation.org/api/units/98759665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.836770Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "Inserts the given (array of) formula(s) in the specified range. The size of the modified area is equal to the size of the range." ], "previous_source": "", "target": [ "" ], "id_hash": 7150658288935689628, "content_hash": 7150658288935689628, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id481593880376480\nhelp.text", "note": "DCAWV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/98579394/?format=api", "priority": 100, "id": 98759666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=e33c3dd3f636dd9c", "url": "https://translations.documentfoundation.org/api/units/98759666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.837560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "The method returns a string representing the modified area as a range of cells." ], "previous_source": "", "target": [ "" ], "id_hash": 2657520711735580233, "content_hash": 2657520711735580233, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id711593880376106\nhelp.text", "note": "d8CAU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98579428/?format=api", "priority": 100, "id": 98759667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=a4e16901d63e1649", "url": "https://translations.documentfoundation.org/api/units/98759667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.838304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/axm/?format=api", "source": [ "<emph>targetrange</emph>: The range to insert the formulas, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": 8103559774696774470, "content_hash": 8103559774696774470, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id891593880376776\nhelp.text", "note": "F5XDi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/98579461/?format=api", "priority": 100, "id": 98759668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/axm/?checksum=f075a0ae3af21b46", "url": "https://translations.documentfoundation.org/api/units/98759668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:34:28.839067Z" } ] }