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/id/units/?format=api&page=14
{ "count": 4173, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/units/?format=api&page=15", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/units/?format=api&page=13", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The following example makes a copy of the sheet \"SheetX\" and places it as the last sheet in the current document. The name of the copied sheet is \"SheetY\"." ], "previous_source": "", "target": [ "" ], "id_hash": 413700147613167258, "content_hash": 413700147613167258, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961591632309410\nhelp.text", "note": "yuvEn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 651, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110307169/?format=api", "priority": 100, "id": 111337785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=85bdc217a6026e9a", "url": "https://translations.documentfoundation.org/api/units/111337785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.743584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "'Gets the Document object of the active window" ], "previous_source": "", "target": [ "" ], "id_hash": -3441017644253958226, "content_hash": -3441017644253958226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id231611706034607\nhelp.text", "note": "pqVdW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 652, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110307171/?format=api", "priority": 100, "id": 111337791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=503f0caf10642fae", "url": "https://translations.documentfoundation.org/api/units/111337791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.745248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The example below copies \"SheetX\" from \"FileA.ods\" and pastes it at the last position of \"FileB.ods\" with the name \"SheetY\":" ], "previous_source": "", "target": [ "" ], "id_hash": 5098410387327329670, "content_hash": 5098410387327329670, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461591632297415\nhelp.text", "note": "xUG9G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 653, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110307173/?format=api", "priority": 100, "id": 111337796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=c6c1313c17cea586", "url": "https://translations.documentfoundation.org/api/units/111337796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.746934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "To copy sheets between <emph>open</emph> documents, use <literal>CopySheet</literal>. To copy sheets from documents that are <emph>closed</emph>, use <literal>CopySheetFromFile</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 6083641035646651294, "content_hash": 6083641035646651294, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id801595695285478\nhelp.text", "note": "2AAEx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 654, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110307175/?format=api", "priority": 100, "id": 111337802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=d46d6f4a16b54b9e", "url": "https://translations.documentfoundation.org/api/units/111337802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.748647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Copies a specified sheet from a <emph>closed</emph> Calc document and pastes it before an existing sheet or at the end of the list of sheets of the file referred to by a <literal>Document</literal> object." ], "previous_source": "", "target": [ "" ], "id_hash": 71251651323642476, "content_hash": 71251651323642476, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id931591714614755\nhelp.text", "note": "5fctt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 655, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110307177/?format=api", "priority": 100, "id": 111337808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=80fd22ffd6ce426c", "url": "https://translations.documentfoundation.org/api/units/111337808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.750413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet." ], "previous_source": "", "target": [ "" ], "id_hash": 4954474255409286440, "content_hash": 4954474255409286440, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id271611706609445\nhelp.text", "note": "M9mDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 656, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110307184/?format=api", "priority": 100, "id": 111337813, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=c4c1d415da7d0d28", "url": "https://translations.documentfoundation.org/api/units/111337813/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.752199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password." ], "previous_source": "", "target": [ "" ], "id_hash": 6161904090638406798, "content_hash": 6161904090638406798, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id471591714947181\nhelp.text", "note": "tCseT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 657, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110307197/?format=api", "priority": 100, "id": 111337819, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=d5837b1f8e87548e", "url": "https://translations.documentfoundation.org/api/units/111337819/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.754068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to be copied as a string." ], "previous_source": "", "target": [ "" ], "id_hash": -8163067119949255370, "content_hash": -8163067119949255370, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id9915917146142\nhelp.text", "note": "gHjz6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 658, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110307211/?format=api", "priority": 100, "id": 111337825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=0eb6f5b445c0ed36", "url": "https://translations.documentfoundation.org/api/units/111337825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:52.755869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>newname</emph>: The name of the copied sheet to be inserted in the document. The name must not be in use in the document." ], "previous_source": "", "target": [ "" ], "id_hash": 7230076804639943975, "content_hash": 7230076804639943975, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id71591714614904\nhelp.text", "note": "PeZ4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 659, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110307222/?format=api", "priority": 100, "id": 111337830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=e456648c175aed27", "url": "https://translations.documentfoundation.org/api/units/111337830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.122906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position." ], "previous_source": "", "target": [ "" ], "id_hash": 1264359049188327446, "content_hash": 1264359049188327446, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601591714614407\nhelp.text", "note": "2niVz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 660, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110307234/?format=api", "priority": 100, "id": 111337834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=918be7db3b6bc016", "url": "https://translations.documentfoundation.org/api/units/111337834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.126221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The following example copies \"SheetX\" from \"myFile.ods\" and pastes it into the document referred to by \"oDoc\" as \"SheetY\" at the first position." ], "previous_source": "", "target": [ "" ], "id_hash": 6771593316251289143, "content_hash": 6771593316251289143, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id981611707192039\nhelp.text", "note": "iEHJy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 661, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110307243/?format=api", "priority": 100, "id": 111337838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=ddf9883e62914637", "url": "https://translations.documentfoundation.org/api/units/111337838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.128493Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Copies a specified source range (values, formulas and formats) to a destination range or cell. The method reproduces the behaviour of a Copy/Paste operation from a range to a single cell." ], "previous_source": "", "target": [ "" ], "id_hash": -2488477199871859506, "content_hash": -2488477199871859506, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id91592558768804\nhelp.text", "note": "kELHv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 662, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/110307300/?format=api", "priority": 100, "id": 111337842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=5d77272bd5faa4ce", "url": "https://translations.documentfoundation.org/api/units/111337842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.130198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "It returns a string representing the modified range of cells. The size of the modified area is fully determined by the size of the source area." ], "previous_source": "", "target": [ "" ], "id_hash": 4432333625800308753, "content_hash": 4432333625800308753, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id831611707431984\nhelp.text", "note": "KixB2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 663, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110307335/?format=api", "priority": 100, "id": 111337859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=bd82cff2fbd8b811", "url": "https://translations.documentfoundation.org/api/units/111337859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.144007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The source range may belong to another <emph>open</emph> document." ], "previous_source": "", "target": [ "" ], "id_hash": 3033093333381109024, "content_hash": 3033093333381109024, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id681592558768463\nhelp.text", "note": "KCiyF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 664, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110307364/?format=api", "priority": 100, "id": 111337862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=aa17b65112c95520", "url": "https://translations.documentfoundation.org/api/units/111337862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.147531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document." ], "previous_source": "", "target": [ "" ], "id_hash": 5339514003632238176, "content_hash": 5339514003632238176, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id761592558768578\nhelp.text", "note": "RBQG9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 665, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110307398/?format=api", "priority": 100, "id": 111337865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=ca19c3b243b92e60", "url": "https://translations.documentfoundation.org/api/units/111337865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.149451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>destinationcell</emph>: The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered." ], "previous_source": "", "target": [ "" ], "id_hash": 8988344706776658690, "content_hash": 8988344706776658690, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id711592558768466\nhelp.text", "note": "3MUwk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 666, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110307431/?format=api", "priority": 100, "id": 111337869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=fcbd03e3762f7302", "url": "https://translations.documentfoundation.org/api/units/111337869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.151412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Next is an example where the source and destination are in the same file:" ], "previous_source": "", "target": [ "" ], "id_hash": -680338937402677348, "content_hash": -680338937402677348, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431592904964362\nhelp.text", "note": "FbkjF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 667, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110307500/?format=api", "priority": 100, "id": 111337873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=768ef3574d3f279c", "url": "https://translations.documentfoundation.org/api/units/111337873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.153335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The example below illustrates how to copy a range from another open Calc document:" ], "previous_source": "", "target": [ "" ], "id_hash": -3161336888915455065, "content_hash": -3161336888915455065, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id751592905035452\nhelp.text", "note": "Zh3Wp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 668, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110307539/?format=api", "priority": 100, "id": 111337878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=5420acd958db13a7", "url": "https://translations.documentfoundation.org/api/units/111337878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.155346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "'Open the source document in the background (hidden)" ], "previous_source": "", "target": [ "" ], "id_hash": -3953349280367640401, "content_hash": -3953349280367640401, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id351592558768880\nhelp.text", "note": "uFAEe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 669, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110307583/?format=api", "priority": 100, "id": 111337881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=4922e1c676a400af", "url": "https://translations.documentfoundation.org/api/units/111337881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.157237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "'Do not forget to close the source document because it was opened as hidden" ], "previous_source": "", "target": [ "" ], "id_hash": -3582412578444852936, "content_hash": -3582412578444852936, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id1001611708508251\nhelp.text", "note": "PBgwL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 670, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110307613/?format=api", "priority": 100, "id": 111337886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=4e48b6bd86e74138", "url": "https://translations.documentfoundation.org/api/units/111337886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.159040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "To simulate a Copy/Paste from a range to a single cell, use <literal>CopyToCell</literal>. To simulate a Copy/Paste from a range to a larger range (with the same cells being replicated several times), use <literal>CopyToRange</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 4807276954834911032, "content_hash": 4807276954834911032, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id61592905442071\nhelp.text", "note": "ZzDAQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 671, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110307663/?format=api", "priority": 100, "id": 111337890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=c2b6e0eb9ddb3f38", "url": "https://translations.documentfoundation.org/api/units/111337890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.160873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Copies downwards and/or rightwards a specified source range (values, formulas and formats) to a destination range. The method imitates the behaviour of a Copy/Paste operation from a source range to a larger destination range." ], "previous_source": "", "target": [ "" ], "id_hash": -2008967503551711619, "content_hash": -2008967503551711619, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id1615929031212\nhelp.text", "note": "maHke", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 672, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110307704/?format=api", "priority": 100, "id": 111337893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=641eb6b3117f367d", "url": "https://translations.documentfoundation.org/api/units/111337893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.162895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "If the height (or width) of the destination area is > 1 row (or column) then the height (or width) of the source must be <= the height (or width) of the destination. Otherwise nothing happens." ], "previous_source": "", "target": [ "" ], "id_hash": 5376960491041418300, "content_hash": 5376960491041418300, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id271592904084534\nhelp.text", "note": "G4qky", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 673, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110307850/?format=api", "priority": 100, "id": 111337897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=ca9ecd1407d56c3c", "url": "https://translations.documentfoundation.org/api/units/111337897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.164765Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "If the height (or width) of the destination is = 1 then the destination is expanded downwards (or rightwards) up to the height (or width) of the source range." ], "previous_source": "", "target": [ "" ], "id_hash": -6431310356051462315, "content_hash": -6431310356051462315, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id131592904286834\nhelp.text", "note": "Pko2R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 674, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110307901/?format=api", "priority": 100, "id": 111337902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=26bf654e4342f755", "url": "https://translations.documentfoundation.org/api/units/111337902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.166536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The method returns a string representing the modified range of cells." ], "previous_source": "", "target": [ "" ], "id_hash": 7495282324396252969, "content_hash": 7495282324396252969, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id661592904348877\nhelp.text", "note": "jYha4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 675, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110307912/?format=api", "priority": 100, "id": 111337906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=e804978ff4e71f29", "url": "https://translations.documentfoundation.org/api/units/111337906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:54.168127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The source range may belong to another <emph>open</emph> document." ], "previous_source": "", "target": [ "" ], "id_hash": 5546808927261758851, "content_hash": 5546808927261758851, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id41592903121807\nhelp.text", "note": "wfzcw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 676, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110307925/?format=api", "priority": 100, "id": 111337947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=ccfa3954c2671583", "url": "https://translations.documentfoundation.org/api/units/111337947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.493295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document." ], "previous_source": "", "target": [ "" ], "id_hash": -1532857823434487798, "content_hash": -1532857823434487798, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592903121145\nhelp.text", "note": "CEaED", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 677, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110307935/?format=api", "priority": 100, "id": 111337950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=6aba31ee5702480a", "url": "https://translations.documentfoundation.org/api/units/111337950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.495964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>destinationrange</emph>: The destination of the copied range of cells, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": -5874871587523563740, "content_hash": -5874871587523563740, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031211000\nhelp.text", "note": "v3d3d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 678, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110307947/?format=api", "priority": 100, "id": 111337954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=2e78436ae49f6f24", "url": "https://translations.documentfoundation.org/api/units/111337954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.499602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Copy within the same document:" ], "previous_source": "", "target": [ "" ], "id_hash": -5609596176834912958, "content_hash": -5609596176834912958, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461592905128991\nhelp.text", "note": "LsHF6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 679, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110307961/?format=api", "priority": 100, "id": 111337959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=3226b5ff825d9d42", "url": "https://translations.documentfoundation.org/api/units/111337959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.504968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "' Returns a range string: \"$SheetY.$C$5:$J$14\"" ], "previous_source": "", "target": [ "" ], "id_hash": 2934433011410434018, "content_hash": 2934433011410434018, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id601592904507182\nhelp.text", "note": "dNdmJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 680, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110308029/?format=api", "priority": 100, "id": 111337965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=a8b93346ce4c77e2", "url": "https://translations.documentfoundation.org/api/units/111337965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.511646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Copy from one file to another:" ], "previous_source": "", "target": [ "" ], "id_hash": -2061534920952186652, "content_hash": -2061534920952186652, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id1001592905195364\nhelp.text", "note": "FBbwi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 681, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110308060/?format=api", "priority": 100, "id": 111337967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=6363f4e97094f8e4", "url": "https://translations.documentfoundation.org/api/units/111337967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.515946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Creates a new chart object showing the data in the specified range. The returned chart object can be further manipulated using the <literal>Chart</literal> service." ], "previous_source": "", "target": [ "" ], "id_hash": -6487620855521588424, "content_hash": -6487620855521588424, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id1615929033642\nhelp.text", "note": "L3GHp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 682, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110308098/?format=api", "priority": 100, "id": 111337972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=25f757346d384b38", "url": "https://translations.documentfoundation.org/api/units/111337972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.519827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>chartname:</emph> The user-defined name of the chart to be created. The name must be unique in the same sheet." ], "previous_source": "", "target": [ "" ], "id_hash": 6992492384207117200, "content_hash": 6992492384207117200, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592903121025\nhelp.text", "note": "2YZ5H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 683, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110308131/?format=api", "priority": 100, "id": 111337975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=e10a52c68f4a1b90", "url": "https://translations.documentfoundation.org/api/units/111337975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.521577Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>sheetname:</emph> The name of the sheet where the chart will be placed." ], "previous_source": "", "target": [ "" ], "id_hash": -3043381907049541448, "content_hash": -3043381907049541448, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031213680\nhelp.text", "note": "BBtB3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 684, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110308401/?format=api", "priority": 100, "id": 111337978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=55c3bc47b27610b8", "url": "https://translations.documentfoundation.org/api/units/111337978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.523301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>range:</emph> The range to be used as the data source for the chart. The range may refer to any sheet of the Calc document." ], "previous_source": "", "target": [ "" ], "id_hash": -987211335908348498, "content_hash": -987211335908348498, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031211522\nhelp.text", "note": "GEiCb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 685, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110308414/?format=api", "priority": 100, "id": 111337981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=724cb8853cf1adae", "url": "https://translations.documentfoundation.org/api/units/111337981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.524949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>columnheader:</emph> When <literal>True</literal>, the topmost row of the range is used as labels for the category axis or the legend (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": -7790735963400643562, "content_hash": -7790735963400643562, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031216390\nhelp.text", "note": "L3dSo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 686, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110308532/?format=api", "priority": 100, "id": 111337983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=13e1beeb1aa4dc16", "url": "https://translations.documentfoundation.org/api/units/111337983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.526536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>rowheader:</emph> When <literal>True</literal>, the leftmost column of the range is used as labels for the category axis or the legend. (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": -4420083844856853749, "content_hash": -4420083844856853749, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031211633\nhelp.text", "note": "iyq5m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 687, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110308536/?format=api", "priority": 100, "id": 111337985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=42a8b52965dd4b0b", "url": "https://translations.documentfoundation.org/api/units/111337985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.528230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The examples below in Basic and Python create a chart using the data contained in the range \"A1:B5\" of \"Sheet1\" and place the chart in \"Sheet2\"." ], "previous_source": "", "target": [ "" ], "id_hash": 8625145552444464415, "content_hash": 8625145552444464415, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id61635441176547\nhelp.text", "note": "CKzBZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 688, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110308538/?format=api", "priority": 100, "id": 111337987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=f7b2ac2e957e1d1f", "url": "https://translations.documentfoundation.org/api/units/111337987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.529886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Refer to the help page about ScriptForge's <link href=\"text/sbasic/shared/03/sf_chart.xhp\">Chart service</link> to learn more how to further manipulate chart objects. It is possible to change properties as the chart type, chart and axes titles and chart position." ], "previous_source": "", "target": [ "" ], "id_hash": 6691328220814838568, "content_hash": 6691328220814838568, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id231635441342180\nhelp.text", "note": "NcUxk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 689, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110308543/?format=api", "priority": 100, "id": 111337990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=dcdc5f908d370b28", "url": "https://translations.documentfoundation.org/api/units/111337990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.531468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "Creates a new pivot table with the properties defined by the arguments passed to the method." ], "previous_source": "", "target": [ "" ], "id_hash": 1588058185253751164, "content_hash": 1588058185253751164, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id1615929033065\nhelp.text", "note": "DFCVe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 690, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110308551/?format=api", "priority": 100, "id": 111337993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=9609ea816eb3897c", "url": "https://translations.documentfoundation.org/api/units/111337993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.533223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "A name must be provided for the pivot table. If a pivot table with the same name already exists in the targeted sheet, it will be replaced without warning." ], "previous_source": "", "target": [ "" ], "id_hash": 4079318241287738568, "content_hash": 4079318241287738568, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id1001652794922144\nhelp.text", "note": "gouER", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 691, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110308560/?format=api", "priority": 100, "id": 111337995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=b89ca653c9ba14c8", "url": "https://translations.documentfoundation.org/api/units/111337995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.534809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "This method returns a string containing the range where the new pivot table was placed." ], "previous_source": "", "target": [ "" ], "id_hash": 6416342409305395362, "content_hash": 6416342409305395362, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id751652795324382\nhelp.text", "note": "SnCCg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 692, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110308569/?format=api", "priority": 100, "id": 111337997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=d90b6d6d0fec10a2", "url": "https://translations.documentfoundation.org/api/units/111337997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.536319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>pivottablename:</emph> The user-defined name of the new pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": 6517720187414641083, "content_hash": 6517720187414641083, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592903128525\nhelp.text", "note": "AKjmT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 693, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110308576/?format=api", "priority": 100, "id": 111337999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=da7397fa643df9bb", "url": "https://translations.documentfoundation.org/api/units/111337999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.537817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>sourcerange:</emph> The range containing the raw data, as a string. It is assumed that the first row contains the field names that are used by the pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": 7287367858591797962, "content_hash": 7287367858591797962, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031203640\nhelp.text", "note": "vvGTx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 694, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110308585/?format=api", "priority": 100, "id": 111338001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=e521ee750ef692ca", "url": "https://translations.documentfoundation.org/api/units/111338001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.539276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>targetcell:</emph> The top-left cell where the new pivot table will be placed. If a range is specified, only its top-left cell is considered." ], "previous_source": "", "target": [ "" ], "id_hash": 403137935589965374, "content_hash": 403137935589965374, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031210400\nhelp.text", "note": "twWbD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 695, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110308593/?format=api", "priority": 100, "id": 111338003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=85983bd10652fe3e", "url": "https://translations.documentfoundation.org/api/units/111338003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.540749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>datafields:</emph> It can be either a single string or an array containing strings that define field names and functions to be applied. When an array is specified, it must follow the syntax <input>Array(\"FieldName[;Function]\", ...)</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -3437097514577660924, "content_hash": -3437097514577660924, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031951290\nhelp.text", "note": "YXG64", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 696, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110308602/?format=api", "priority": 100, "id": 111338005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=504cfa0561387404", "url": "https://translations.documentfoundation.org/api/units/111338005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.542164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "The allowed functions are: <literal>Sum</literal>, <literal>Count</literal>, <literal>Average</literal>, <literal>Max</literal>, <literal>Min</literal>, <literal>Product</literal>, <literal>CountNums</literal>, <literal>StDev</literal>, <literal>StDevP</literal>, <literal>Var</literal>, <literal>VarP</literal> and <literal>Median</literal>. Function names must be provided in English. When all values are numerical, <literal>Sum</literal> is the default function, otherwise the default function is <literal>Count</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 8055998606887529762, "content_hash": 8055998606887529762, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652795942348\nhelp.text", "note": "cKZ3U", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 697, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110308610/?format=api", "priority": 100, "id": 111338007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=efcca80cea92ad22", "url": "https://translations.documentfoundation.org/api/units/111338007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.543566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>rowfields:</emph> A single string or an array with the field names that will be used as the pivot table rows." ], "previous_source": "", "target": [ "" ], "id_hash": 7617922890712818621, "content_hash": 7617922890712818621, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031211003\nhelp.text", "note": "JKCoA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 698, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110308619/?format=api", "priority": 100, "id": 111338009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=e9b84c81f34123bd", "url": "https://translations.documentfoundation.org/api/units/111338009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.545027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>columnfields:</emph> A single string or an array with the field names that will be used as the pivot table columns." ], "previous_source": "", "target": [ "" ], "id_hash": -7377807794460617704, "content_hash": -7377807794460617704, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id5515929031211114\nhelp.text", "note": "8GW5G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 699, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110308626/?format=api", "priority": 100, "id": 111338011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=199cc2e676111418", "url": "https://translations.documentfoundation.org/api/units/111338011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.546385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/id/?format=api", "source": [ "<emph>filterbutton:</emph> Determines whether a filter button will be displayed above the pivot table (Default = <literal>True</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": -2748308082469955139, "content_hash": -2748308082469955139, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652796141240\nhelp.text", "note": "iTL7C", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 700, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110308629/?format=api", "priority": 100, "id": 111338013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/id/?checksum=59dc0c5c330b19bd", "url": "https://translations.documentfoundation.org/api/units/111338013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:40:56.547858Z" } ] }