Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=173
{ "count": 8628, "next": null, "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/units/?format=api&page=172", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If the database range has no labels row defined (Contains columns row), a #REF! error is generated." ], "previous_source": "", "target": [ "" ], "id_hash": -8809937232662223778, "content_hash": -8809937232662223778, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id701727205544887\nhelp.text", "note": "GcxXc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/125072528/?format=api", "priority": 100, "id": 125081731, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=05bcd0c391ae245e", "url": "https://translations.documentfoundation.org/api/units/125081731/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.616770Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The expression <literal>myData[#Headers]</literal> references the cells <literal>A1:D1</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -7296979167886102558, "content_hash": -7296979167886102558, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id161727205452550\nhelp.text", "note": "rNQVw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/125072529/?format=api", "priority": 100, "id": 125081732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1abbec1b9cb92fe2", "url": "https://translations.documentfoundation.org/api/units/125081732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.617653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The short form <input>myData[]</input> can be used as well." ], "previous_source": "", "target": [ "" ], "id_hash": 8591598021259291891, "content_hash": 8591598021259291891, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id601727205675886\nhelp.text", "note": "PQxNG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/125072530/?format=api", "priority": 100, "id": 125081733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f73b7ce14e1becf3", "url": "https://translations.documentfoundation.org/api/units/125081733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.618539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The expression <input>myData[#Data]</input> references the cell rectangle <input>A2:D10</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -45797068959165164, "content_hash": -45797068959165164, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id481727205632987\nhelp.text", "note": "wL8E5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/125072531/?format=api", "priority": 100, "id": 125081734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7f5d4bcef4ef5514", "url": "https://translations.documentfoundation.org/api/units/125081734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.619421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If the database range has no line of totals defined (<link href=\"text/scalc/01/12010000.xhp#contains_totals_row\"><menuitem>Contains totals row</menuitem></link>), a #REF! error is generated." ], "previous_source": "", "target": [ "" ], "id_hash": -4901485736379736131, "content_hash": -4901485736379736131, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id211727205840457\nhelp.text", "note": "kzXVD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/125072532/?format=api", "priority": 100, "id": 125081735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3bfa6cb123711fbd", "url": "https://translations.documentfoundation.org/api/units/125081735/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.620307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The expression <input>myData[#Totals]</input> references the cells <input>A11:D11</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -1834201236064488880, "content_hash": -1834201236064488880, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id691727205815586\nhelp.text", "note": "RhUsA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/125072533/?format=api", "priority": 100, "id": 125081736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=668b9bb19dcb3250", "url": "https://translations.documentfoundation.org/api/units/125081736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.621209Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The keyword <literal>[#All]</literal> references the entire database range including column labels and totals." ], "previous_source": "", "target": [ "" ], "id_hash": 9188773760723633437, "content_hash": 9188773760723633437, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id151727205893803\nhelp.text", "note": "CPKPU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/125072534/?format=api", "priority": 100, "id": 125081737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ff85150d195cc51d", "url": "https://translations.documentfoundation.org/api/units/125081737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.622088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The expression <input>myData[#All]</input> references the cells <input>A1:D11</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -33658198913242981, "content_hash": -33658198913242981, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id311727205907842\nhelp.text", "note": "Jy5V9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6168, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/125072535/?format=api", "priority": 100, "id": 125081738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=7f886c0be1ff289b", "url": "https://translations.documentfoundation.org/api/units/125081738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.622978Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "This keyword describes an <link href=\"text/scalc/01/04060107.xhp#implicit_intersection\">implicit intersection</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 3164360277740197317, "content_hash": 3164360277740197317, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id221727205934899\nhelp.text", "note": "bvT59", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/125072536/?format=api", "priority": 100, "id": 125081739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=abea10e8380f95c5", "url": "https://translations.documentfoundation.org/api/units/125081739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.623860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "If the expression <literal>myData[#This Row]</literal> is used in a formula in cell <input>F2</input>, it references <input>A2:D2</input>. If the same expression is used in a formula in cell <input>F5</input>, it references <input>A5:D5</input>." ], "previous_source": "", "target": [ "" ], "id_hash": 97765887446122724, "content_hash": 97765887446122724, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id491727205948824\nhelp.text", "note": "YF62m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6170, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/125072537/?format=api", "priority": 100, "id": 125081740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=815b558e806080e4", "url": "https://translations.documentfoundation.org/api/units/125081740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.624972Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"field name in square brackets_hd\">Field name in square brackets</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -653116261052574335, "content_hash": -653116261052574335, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id411727208826224\nhelp.text", "note": "gB7fC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6171, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/125072538/?format=api", "priority": 100, "id": 125081741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=76efaa388eee1581", "url": "https://translations.documentfoundation.org/api/units/125081741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.625921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "To reference the array of all values in the records that belong to the same field, use the form <input>[field name]</input>. The referenced cell range does not include label and totals." ], "previous_source": "", "target": [ "" ], "id_hash": -7301960702853959009, "content_hash": -7301960702853959009, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id91727208864918\nhelp.text", "note": "gDso3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/125072539/?format=api", "priority": 100, "id": 125081742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1aaa396d9e87329f", "url": "https://translations.documentfoundation.org/api/units/125081742/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.626803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "" ], "id_hash": 4860559993514220698, "content_hash": 4860559993514220698, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id621727375719966\nhelp.text", "note": "JVr5e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/125072540/?format=api", "priority": 100, "id": 125081743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c3742d8fcee3dc9a", "url": "https://translations.documentfoundation.org/api/units/125081743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.627702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The expression <input>myData[[Region]]</input> or its simplified form <input>myData[Region]</input> references the cells <input>B2:B10</input>. If the database range has no label row, generic labels like <input>Column1</input>, <input>Column2</input> can be used." ], "previous_source": "", "target": [ "" ], "id_hash": -1687645975475246107, "content_hash": -1687645975475246107, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id41727208903631\nhelp.text", "note": "atEon", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/125072541/?format=api", "priority": 100, "id": 125081744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=689446ed452e2be5", "url": "https://translations.documentfoundation.org/api/units/125081744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.628559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "In Microsoft Excel, if the formula cell belongs to the table, then the name of the table may be omitted. For example, the formula <input>=SUM(myData[Sales]</input>) in cell <input>C11</input> could be written as <input>=SUM([Sales]</input>). Omission of the table name is not yet possible in Calc." ], "previous_source": "", "target": [ "" ], "id_hash": -8916216884744718890, "content_hash": -8916216884744718890, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id141727208910739\nhelp.text", "note": "88Fek", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/125072542/?format=api", "priority": 100, "id": 125081745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=04433bfbc47375d6", "url": "https://translations.documentfoundation.org/api/units/125081745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.629466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"combinations_hd\">Combinations</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 8204880549308905822, "content_hash": 8204880549308905822, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id11727208935686\nhelp.text", "note": "DQizE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/125072543/?format=api", "priority": 100, "id": 125081746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f1dd97636611b95e", "url": "https://translations.documentfoundation.org/api/units/125081746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.630397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"columns_and_data_hd\">Columns and data records</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -8037596941779282675, "content_hash": -8037596941779282675, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id911727368734633\nhelp.text", "note": "m6Xb2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/125072544/?format=api", "priority": 100, "id": 125081747, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=1074b82a9d7ad50d", "url": "https://translations.documentfoundation.org/api/units/125081747/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.631303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "To reference a combination of the column labels and data records, use the format <input>[#Headers];[#Data]</input> or <input>[#Headers],[#Data]</input>, where the separator is the same separator as for function parameters that is defined in <menuitem>Tools - Options - Calc - Formula - </menuitem><link href=\"text/shared/optionen/01060900.xhp#separators\"><menuitem>Separators</menuitem></link>." ], "previous_source": "", "target": [ "" ], "id_hash": -796183672098288824, "content_hash": -796183672098288824, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id621727211351391\nhelp.text", "note": "E28MY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/125072545/?format=api", "priority": 100, "id": 125081748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=74f3632b289d8b48", "url": "https://translations.documentfoundation.org/api/units/125081748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.632193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"data_and_totals_hd\">Data records and total row</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -4918345384912751901, "content_hash": -4918345384912751901, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id111727368792150\nhelp.text", "note": "vFxAs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/125072546/?format=api", "priority": 100, "id": 125081749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=3bbe86ee5197f2e3", "url": "https://translations.documentfoundation.org/api/units/125081749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.633138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "To reference a combination of data records and totals row, use <input>[#Data];[#Totals]</input>. For example, <input>myData[[#Data];[#Totals]]</input> references the cells <input>A2:D11</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -5165173219456674660, "content_hash": -5165173219456674660, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id191727211364444\nhelp.text", "note": "JnFaR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/125072547/?format=api", "priority": 100, "id": 125081750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=38519e52baec949c", "url": "https://translations.documentfoundation.org/api/units/125081750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.634021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "A combination like <input>[#Headers];[#Totals]</input> is not possible as that would result in two disjoint cell rectangles." ], "previous_source": "", "target": [ "" ], "id_hash": 4757929091039839996, "content_hash": 4757929091039839996, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id231727211374505\nhelp.text", "note": "GpVa6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/125072548/?format=api", "priority": 100, "id": 125081751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=c2078f4cb9ed46fc", "url": "https://translations.documentfoundation.org/api/units/125081751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.634908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"adjacent_columns_hd\">Adjacent columns</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -7395905345030951682, "content_hash": -7395905345030951682, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id491727369582280\nhelp.text", "note": "nMXZc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/125072549/?format=api", "priority": 100, "id": 125081752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=195c77461d046cfe", "url": "https://translations.documentfoundation.org/api/units/125081752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.635802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "To reference several adjacent columns, use the range operator “<input>:</input>”. For example, the formula <input>myData[[Name]:[Sales]]</input> addresses the cells <input>A2:C10</input>." ], "previous_source": "", "target": [ "" ], "id_hash": -4469358026998891592, "content_hash": -4469358026998891592, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id221727211378888\nhelp.text", "note": "r8pcx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/125072550/?format=api", "priority": 100, "id": 125081753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=41f9a68ddab0bbb8", "url": "https://translations.documentfoundation.org/api/units/125081753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.636677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"non-adjacent_columns_hd\">Non-adjacent columns</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 1010474816729967853, "content_hash": 1010474816729967853, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id301727369611525\nhelp.text", "note": "5vugB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/125072551/?format=api", "priority": 100, "id": 125081754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8e05ed7df9aaeced", "url": "https://translations.documentfoundation.org/api/units/125081754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.637581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The use of non-adjacent columns is not possible since it would reference two separate cell rectangles." ], "previous_source": "", "target": [ "" ], "id_hash": 8563766904143928639, "content_hash": 8563766904143928639, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id941727211383085\nhelp.text", "note": "zAKaX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/125072552/?format=api", "priority": 100, "id": 125081755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=f6d89ca064bedd3f", "url": "https://translations.documentfoundation.org/api/units/125081755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.638455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<variable id=\"field name and keyword_hd\">Field name and keyword</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 922509519073842239, "content_hash": 922509519073842239, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\nhd_id931727369670465\nhelp.text", "note": "k2HUE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6186, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/125072554/?format=api", "priority": 100, "id": 125081756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=8ccd69851a50143f", "url": "https://translations.documentfoundation.org/api/units/125081756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.639376Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "The reference via field name and the use of a reference keyword can be combined. First state the keyword, then the function separator, and last the field name in brackets. For example, <input>myData[[#Totals];[Sales]]</input> references the cell <input>C11</input>." ], "previous_source": "", "target": [ "" ], "id_hash": 447906839566944267, "content_hash": 447906839566944267, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id261727211388563\nhelp.text", "note": "ZiVAG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6187, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/125072565/?format=api", "priority": 100, "id": 125081757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=863748e5c0db080b", "url": "https://translations.documentfoundation.org/api/units/125081757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.640258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/nn/?format=api", "source": [ "<link href=\"text/scalc/01/04060107.xhp#implicit_intersection\">Implicit intersection in formulas</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 7872808326552397511, "content_hash": 7872808326552397511, "location": "database_table_reference.xhp", "context": "database_table_reference.xhp\npar_id371727210314917\nhelp.text", "note": "nnnCj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/125072574/?format=api", "priority": 100, "id": 125081758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/nn/?checksum=ed41d57608e4a6c7", "url": "https://translations.documentfoundation.org/api/units/125081758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-10-04T14:51:14.641240Z" } ] }