Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/units/?format=api&page=93
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=94", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=92", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"aggregate_head\"><link href=\"text/scalc/01/func_aggregate.xhp\">AGGREGATE</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"aggregate_head\">Función <link href=\"text/scalc/01/func_aggregate.xhp\">AGREGAR</link></variable>" ], "id_hash": -1053760278183226725, "content_hash": -1053760278183226725, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nhd_id3154073\nhelp.text", "note": "T2Az9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950634/?format=api", "priority": 100, "id": 1511363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=71604a9c2c78d29b", "url": "https://translations.documentfoundation.org/api/units/1511363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.309222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"aggregate_des\">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"aggregate_des\">Esta función devuelve el resultado totalizado de los cálculos de un intervalo. Puede utilizar una de las funciones de totalización mostradas a continuación. La función AGREGAR le permite ignorar las filas ocultas, los errores y los resultados de otras fórmulas SUBTOTALES y AGREGAR.</variable></ahelp>" ], "id_hash": -3207479533146748597, "content_hash": -3207479533146748597, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174373\nhelp.text", "note": "m2Tdo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950635/?format=api", "priority": 100, "id": 1511364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=537cbe5bca73c94b", "url": "https://translations.documentfoundation.org/api/units/1511364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.323504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row." ], "previous_source": "", "target": [ "La función AGREGAR se aplica a rangos verticales de datos con AutoFiltro activado. Si AutoFiltro no está áctivado el recálculo automático del resultado de la función no funciona para columnas ocultadas recientemente. No se supone que funcione con rangos horizontales, de todos modo se puede aplicar a esos rangos también pero con limitaciones. En particular, la función AGREGAR aplicada a un rango horizontal de datos no reconoce columnas ocultas aunque omite correctamente errores y resultados de SUBTOTALES y otras funciones AGREGAR incrustadas en la fila." ], "id_hash": -4827951649456729671, "content_hash": -4827951649456729671, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174453\nhelp.text", "note": "swMHB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 83, "source_unit": "https://translations.documentfoundation.org/api/units/24950636/?format=api", "priority": 100, "id": 1511365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3cffab8ded5ed1b9", "url": "https://translations.documentfoundation.org/api/units/1511365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.346345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "o" ], "id_hash": 5165818302746437215, "content_hash": 5165818302746437215, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201516102726\nhelp.text", "note": "Xt2VS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950638/?format=api", "priority": 100, "id": 1511367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c7b0ac606d69a65f", "url": "https://translations.documentfoundation.org/api/units/1511367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.368790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Function</emph> – obligatory argument. A function index or a reference to a cell with value from 1 to 19, in accordance with the following table." ], "previous_source": "", "target": [ "<emph>Función</emph> (argumento obligatorio): un índice de función o una referencia a una celda cuyo valor esté entre 1 y 19, conforme a la tabla siguiente." ], "id_hash": 598813956301167531, "content_hash": 598813956301167531, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174378\nhelp.text", "note": "WPGsi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24950640/?format=api", "priority": 100, "id": 1511369, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=884f6a1edfe09bab", "url": "https://translations.documentfoundation.org/api/units/1511369/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.394509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Function index" ], "previous_source": "", "target": [ "Índice de funciones" ], "id_hash": -1896280781412991509, "content_hash": -1896280781412991509, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511454963\nhelp.text", "note": "EKz89", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950641/?format=api", "priority": 100, "id": 1511370, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=65af0ead1d7a7deb", "url": "https://translations.documentfoundation.org/api/units/1511370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.406100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Function applied" ], "previous_source": "", "target": [ "Función aplicada" ], "id_hash": -9101540512308578305, "content_hash": -9101540512308578305, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511454945\nhelp.text", "note": "u8cTQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950642/?format=api", "priority": 100, "id": 1511371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=01b0d520470537ff", "url": "https://translations.documentfoundation.org/api/units/1511371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.417503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "AVERAGE" ], "previous_source": "", "target": [ "PROMEDIO" ], "id_hash": 6349814163625906163, "content_hash": 6349814163625906163, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360043\nhelp.text", "note": "yEcCJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950643/?format=api", "priority": 100, "id": 1511372, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d81f1256ccaa8ff3", "url": "https://translations.documentfoundation.org/api/units/1511372/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.431761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COUNT" ], "previous_source": "", "target": [ "CONTAR" ], "id_hash": 621694158914778196, "content_hash": 621694158914778196, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136007\nhelp.text", "note": "LRogz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6391, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950644/?format=api", "priority": 100, "id": 1511373, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=88a0b38b2d0cf454", "url": "https://translations.documentfoundation.org/api/units/1511373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.445645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COUNTA" ], "previous_source": "", "target": [ "CONTARA" ], "id_hash": 2372983928507894132, "content_hash": 2372983928507894132, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360018\nhelp.text", "note": "EQF7t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950645/?format=api", "priority": 100, "id": 1511374, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a0ee884f746c8974", "url": "https://translations.documentfoundation.org/api/units/1511374/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.459743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MAX" ], "previous_source": "", "target": [ "MAX" ], "id_hash": 244100451723229145, "content_hash": 244100451723229145, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360026\nhelp.text", "note": "8HhQr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950646/?format=api", "priority": 100, "id": 1511375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=836338114a79b7d9", "url": "https://translations.documentfoundation.org/api/units/1511375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.473844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MIN" ], "previous_source": "", "target": [ "MIN" ], "id_hash": 4394860047333577022, "content_hash": 4394860047333577022, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360078\nhelp.text", "note": "VqbLM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950647/?format=api", "priority": 100, "id": 1511376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bcfdaded96dfd13e", "url": "https://translations.documentfoundation.org/api/units/1511376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.488141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "PRODUCT" ], "previous_source": "", "target": [ "PRODUCTO" ], "id_hash": -1711823522605648199, "content_hash": -1711823522605648199, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360087\nhelp.text", "note": "GjAYj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950648/?format=api", "priority": 100, "id": 1511377, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=683e619368eeb6b9", "url": "https://translations.documentfoundation.org/api/units/1511377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.500735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "STDEV.S" ], "previous_source": "", "target": [ "DESVEST.M" ], "id_hash": 8846584884968578513, "content_hash": 8846584884968578513, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360153\nhelp.text", "note": "vRU5e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950649/?format=api", "priority": 100, "id": 1511378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fac56214e7e45dd1", "url": "https://translations.documentfoundation.org/api/units/1511378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.513916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "STDEV.P" ], "previous_source": "", "target": [ "DESVEST.P" ], "id_hash": -8197045192624482240, "content_hash": -8197045192624482240, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360178\nhelp.text", "note": "VNpFW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950650/?format=api", "priority": 100, "id": 1511379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0e3e3ed3bdcb5840", "url": "https://translations.documentfoundation.org/api/units/1511379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.526509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SUM" ], "previous_source": "", "target": [ "SUMA" ], "id_hash": 8022580678134696730, "content_hash": 8022580678134696730, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360199\nhelp.text", "note": "DwcTK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950651/?format=api", "priority": 100, "id": 1511380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ef55ee9f0e218b1a", "url": "https://translations.documentfoundation.org/api/units/1511380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.538782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "VAR.S" ], "previous_source": "", "target": [ "VAR.S" ], "id_hash": -7161298333087739920, "content_hash": -7161298333087739920, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360174\nhelp.text", "note": "BW2Yf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6399, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950652/?format=api", "priority": 100, "id": 1511381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1c9df51bb5b54ff0", "url": "https://translations.documentfoundation.org/api/units/1511381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.550650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "VAR.P" ], "previous_source": "", "target": [ "VAR.P" ], "id_hash": -5281586986569483276, "content_hash": -5281586986569483276, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360120\nhelp.text", "note": "DknCD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6400, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950653/?format=api", "priority": 100, "id": 1511382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=36b4089e67333bf4", "url": "https://translations.documentfoundation.org/api/units/1511382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.563661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MEDIAN" ], "previous_source": "", "target": [ "MEDIANA" ], "id_hash": 8649179191260744639, "content_hash": 8649179191260744639, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360122\nhelp.text", "note": "qTcKa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6401, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950654/?format=api", "priority": 100, "id": 1511383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f8080ea62dcc0bbf", "url": "https://translations.documentfoundation.org/api/units/1511383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.574378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MODE.SNGL" ], "previous_source": "", "target": [ "MODA.UNO" ], "id_hash": 6266701016886543926, "content_hash": 6266701016886543926, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136016\nhelp.text", "note": "Vm9Es", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6402, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950655/?format=api", "priority": 100, "id": 1511384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d6f7cb5f591a0636", "url": "https://translations.documentfoundation.org/api/units/1511384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.585486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "LARGE" ], "previous_source": "", "target": [ "K.ESIMO.MAYOR" ], "id_hash": 4912462916571599001, "content_hash": 4912462916571599001, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360180\nhelp.text", "note": "jvBDw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6403, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950656/?format=api", "priority": 100, "id": 1511385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c42c92feca879099", "url": "https://translations.documentfoundation.org/api/units/1511385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.599167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SMALL" ], "previous_source": "", "target": [ "K.ESIMO.MENOR" ], "id_hash": -5181183493836644684, "content_hash": -5181183493836644684, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360150\nhelp.text", "note": "MYUUL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6404, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950657/?format=api", "priority": 100, "id": 1511386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3818bd103dbfdeb4", "url": "https://translations.documentfoundation.org/api/units/1511386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.611463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "PERCENTILE.INC" ], "previous_source": "", "target": [ "PERCENTIL.INC" ], "id_hash": -7414235457462457519, "content_hash": -7414235457462457519, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360157\nhelp.text", "note": "FK7At", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6405, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950658/?format=api", "priority": 100, "id": 1511387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=191b58223cd82b51", "url": "https://translations.documentfoundation.org/api/units/1511387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.624166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "QUARTILE.INC" ], "previous_source": "", "target": [ "CUARTIL.INC" ], "id_hash": -1302486541136101254, "content_hash": -1302486541136101254, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360151\nhelp.text", "note": "jRDcG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6406, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950659/?format=api", "priority": 100, "id": 1511388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6deca36446db007a", "url": "https://translations.documentfoundation.org/api/units/1511388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.633986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "PERCENTILE.EXC" ], "previous_source": "", "target": [ "PERCENTIL.EXC" ], "id_hash": 5425285444438436153, "content_hash": 5425285444438436153, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136017\nhelp.text", "note": "X8cbt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6407, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950660/?format=api", "priority": 100, "id": 1511389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cb4a7c5e08d9a939", "url": "https://translations.documentfoundation.org/api/units/1511389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.646236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "QUARTILE.EXC" ], "previous_source": "", "target": [ "CUARTIL.EXC" ], "id_hash": 4595162875984693312, "content_hash": 4595162875984693312, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360169\nhelp.text", "note": "x7Qhp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6408, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950661/?format=api", "priority": 100, "id": 1511390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bfc54c4a1c214840", "url": "https://translations.documentfoundation.org/api/units/1511390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.659811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Option</emph> – obligatory argument. An option index or reference to a cell with value from 0 to 7 determines what to ignore in the range for the function." ], "previous_source": "", "target": [ "<emph>Opción</emph> – argumento obligatorio. Un índice de opciones o referencia a una celda con valores de 0 a 7 determina que ignorar en el rango de la función." ], "id_hash": 6574897751863773235, "content_hash": 6574897751863773235, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174372\nhelp.text", "note": "ZeuFJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6409, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24950662/?format=api", "priority": 100, "id": 1511391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=db3ebaab865ac833", "url": "https://translations.documentfoundation.org/api/units/1511391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.672474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Option index" ], "previous_source": "", "target": [ "Índice de opción" ], "id_hash": -1480617660331537247, "content_hash": -1480617660331537247, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011557\nhelp.text", "note": "3cZPH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6410, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950663/?format=api", "priority": 100, "id": 1511392, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6b73ca1523c4cca1", "url": "https://translations.documentfoundation.org/api/units/1511392/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.683898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Option applied" ], "previous_source": "", "target": [ "Opción aplicada" ], "id_hash": 8599313250129090645, "content_hash": 8599313250129090645, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011551\nhelp.text", "note": "Lbpgg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6411, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950664/?format=api", "priority": 100, "id": 1511393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f756e5d702411855", "url": "https://translations.documentfoundation.org/api/units/1511393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.697246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Ignora solo SUBTOTALES anidados y funciones AGREGAR" ], "id_hash": -78718025930399498, "content_hash": -78718025930399498, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011567\nhelp.text", "note": "ph2Z6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6412, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950665/?format=api", "priority": 100, "id": 1511394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7ee8565f5affa0f6", "url": "https://translations.documentfoundation.org/api/units/1511394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.709889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Ignora solo filas ocultas, SUBTOTALES anidados y funciones AGREGAR" ], "id_hash": 6263018716214357107, "content_hash": 6263018716214357107, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id315771547630277\nhelp.text", "note": "AGUis", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6413, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24950666/?format=api", "priority": 100, "id": 1511395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d6eab656e9946c73", "url": "https://translations.documentfoundation.org/api/units/1511395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.722761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Ignoara solo errores, SUBTOTALES anidados y funciones AGREGAR" ], "id_hash": 7069325496975214359, "content_hash": 7069325496975214359, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011514\nhelp.text", "note": "EAKJn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6414, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24950667/?format=api", "priority": 100, "id": 1511396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e21b4a15a8d1c717", "url": "https://translations.documentfoundation.org/api/units/1511396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.737872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Ignorar filas ocultas, errores, SUBTOTALES anidados y funciones AGREGAR" ], "id_hash": 1285618312874630734, "content_hash": 1285618312874630734, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011547\nhelp.text", "note": "ofBiE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6415, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24950668/?format=api", "priority": 100, "id": 1511397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=91d76f0b47a11e4e", "url": "https://translations.documentfoundation.org/api/units/1511397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.749852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore nothing" ], "previous_source": "", "target": [ "No ignorar nada" ], "id_hash": -1795886336106039185, "content_hash": -1795886336106039185, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011510\nhelp.text", "note": "oTDkv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6416, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950669/?format=api", "priority": 100, "id": 1511398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6713bae46f6bf86f", "url": "https://translations.documentfoundation.org/api/units/1511398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.764699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only hidden rows" ], "previous_source": "", "target": [ "Ignorar solo filas ocultas" ], "id_hash": -8760652021237738981, "content_hash": -8760652021237738981, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011592\nhelp.text", "note": "5SwRv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6417, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950670/?format=api", "priority": 100, "id": 1511399, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=066be9671151121b", "url": "https://translations.documentfoundation.org/api/units/1511399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.777322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only errors" ], "previous_source": "", "target": [ "Ignorar solo errores" ], "id_hash": -3404317888262980966, "content_hash": -3404317888262980966, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151201150\nhelp.text", "note": "eDQoE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6418, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950671/?format=api", "priority": 100, "id": 1511400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=50c16eeadf93ba9a", "url": "https://translations.documentfoundation.org/api/units/1511400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.788799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Ignore only hidden rows and errors" ], "previous_source": "", "target": [ "Ignorar solo filas ocultas y errores" ], "id_hash": 8176957812684302160, "content_hash": 8176957812684302160, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011539\nhelp.text", "note": "AEVKM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6419, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950672/?format=api", "priority": 100, "id": 1511401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f17a63cea8672750", "url": "https://translations.documentfoundation.org/api/units/1511401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.800133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "For using column labels “Automatically find columns and rows labels” function needs to be enabled." ], "previous_source": "", "target": [ "Para utilizar etiquetas de columnas debe activar la función «Buscar automáticamente etiquetas de columnas y filas»." ], "id_hash": 2520226777258839907, "content_hash": 2520226777258839907, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201515555812\nhelp.text", "note": "tQG5i", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6423, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24950676/?format=api", "priority": 100, "id": 1511405, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a2f9a4e6b3f0cf63", "url": "https://translations.documentfoundation.org/api/units/1511405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.854994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>ColumnOne</emph>" ], "previous_source": "", "target": [ "<emph>ColumnaUno</emph>" ], "id_hash": 5316286428101866127, "content_hash": 5316286428101866127, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454314\nhelp.text", "note": "5M7aG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6425, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950678/?format=api", "priority": 100, "id": 1511407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c9c73e56e73df28f", "url": "https://translations.documentfoundation.org/api/units/1511407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.882522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>ColumnTwo</emph>" ], "previous_source": "", "target": [ "<emph>ColumnaDos</emph>" ], "id_hash": -4230562346510376131, "content_hash": -4230562346510376131, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454361\nhelp.text", "note": "gPqUD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6426, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950679/?format=api", "priority": 100, "id": 1511408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=454a05f5d81b233d", "url": "https://translations.documentfoundation.org/api/units/1511408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.894784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>ColumnThree</emph>" ], "previous_source": "", "target": [ "<emph>ColumnaTres</emph>" ], "id_hash": -4093994859747297707, "content_hash": -4093994859747297707, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454323\nhelp.text", "note": "TGf5y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950680/?format=api", "priority": 100, "id": 1511409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=472f355db07cb655", "url": "https://translations.documentfoundation.org/api/units/1511409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.910328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "#DIV/0!" ], "previous_source": "", "target": [ "#¡DIV/0!" ], "id_hash": -3722701830242757940, "content_hash": -3722701830242757940, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id27530261624700\nhelp.text", "note": "cGmqm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6428, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950681/?format=api", "priority": 100, "id": 1511410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4c564e68bbaf12cc", "url": "https://translations.documentfoundation.org/api/units/1511410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.921619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "3" ], "previous_source": "", "target": [ "3" ], "id_hash": 83303118788611080, "content_hash": 83303118788611080, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201517384053\nhelp.text", "note": "R9Bfd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6429, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950682/?format=api", "priority": 100, "id": 1511411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8127f3bec413cc08", "url": "https://translations.documentfoundation.org/api/units/1511411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.931587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "#VALUE!" ], "previous_source": "", "target": [ "#¡VALOR!" ], "id_hash": -6506822171614038623, "content_hash": -6506822171614038623, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nid_par29987248418152\nhelp.text", "note": "WMMFj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6430, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950683/?format=api", "priority": 100, "id": 1511412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=25b31fb5a44f35a1", "url": "https://translations.documentfoundation.org/api/units/1511412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.943999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(9;5;A5:C5)</item><br/>Returns sum for the range A5:C5 = 29, even if some of the columns are hidden." ], "previous_source": "", "target": [ "<item type=\"input\">=AGREGAR(9;5;A5:C5)</item><br/>Devuelve la suma del intervalo A5:C5 = 29, incluso si algunas de las columnas están ocultas." ], "id_hash": -4987997586971609650, "content_hash": -4987997586971609650, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064180\nhelp.text", "note": "Tx8Vx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6432, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24950685/?format=api", "priority": 100, "id": 1511414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3ac7129f480d35ce", "url": "https://translations.documentfoundation.org/api/units/1511414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.964802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(9;5;B2:B9)</item><br/>Returns sum of the column B = 115. If any row is hidden, the function omit its value, for example if the 7th row is hidden, the function returns 95." ], "previous_source": "", "target": [ "<item type=\"input\">=AGREGAR(9;5;B2:B9)</item><br/>Devuelve la suma de la columna B = 115. Si alguna fila estuviere oculta, la función omitirá su valor; por ejemplo, si la séptima fila está oculta, la función devuelve 95." ], "id_hash": -8594706496281572450, "content_hash": -8594706496281572450, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064118\nhelp.text", "note": "GPwbY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6433, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950686/?format=api", "priority": 100, "id": 1511415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=08b977fa74650b9e", "url": "https://translations.documentfoundation.org/api/units/1511415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.975833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If you need to apply the function with a 3D range, this example shows how to do it." ], "previous_source": "", "target": [ "Si necesita aplicar la función en un intervalo 3D, este ejemplo muestra cómo hacerlo." ], "id_hash": -2586474231245957718, "content_hash": -2586474231245957718, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id196152404026557\nhelp.text", "note": "eyn5c", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6434, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24950687/?format=api", "priority": 100, "id": 1511416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5c1aff63f1e215aa", "url": "https://translations.documentfoundation.org/api/units/1511416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.986816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(13;3;Sheet1.B2:B9:Sheet3.B2:B9)</item><br/>The function returns mode of the values of second columns through sheets 1:3 (that have the same data) = 8." ], "previous_source": "", "target": [ "<item type=\"input\">=AGREGAR(13;3;Hoja1.B2:B9:Hoja3.B2:B9)</item><br/>La función devuelve la moda de los valores de la segunda columna a través de las hojas 1:3 (que tienen los mismos datos) = 8." ], "id_hash": 4304690304793179858, "content_hash": 4304690304793179858, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520180167\nhelp.text", "note": "nKQgg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24950688/?format=api", "priority": 100, "id": 1511417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bbbd55066543f6d2", "url": "https://translations.documentfoundation.org/api/units/1511417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.998196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "You can use reference to a cell or a range for every argument in the formula. The following example shows how it works. Besides, it shows that you can use column labels to specify an array." ], "previous_source": "", "target": [ "Es posible emplear referencias a celdas o a intervalos para cada argumento de la fórmula. El ejemplo siguiente muestra cómo funciona esta técnica. Además, muestra cómo se pueden utilizar etiquetas de columnas para especificar una matriz." ], "id_hash": -1480143598379973480, "content_hash": -1480143598379973480, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395365\nhelp.text", "note": "kDEuY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6436, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950689/?format=api", "priority": 100, "id": 1511418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6b75793d49fe4498", "url": "https://translations.documentfoundation.org/api/units/1511418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.011379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E3 = 13 and E5 = 5, the function returns mode of the first column = 10." ], "previous_source": "", "target": [ "<item type=\"input\">=AGREGAR(E3;E5;'ColumnaUno')</item><br/>Si E3 = 13 y E5 = 5, la función devuelve la moda de la primera columna = 10." ], "id_hash": 8676200419343678172, "content_hash": 8676200419343678172, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395380\nhelp.text", "note": "cFhbt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24950690/?format=api", "priority": 100, "id": 1511419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f8680e501b133adc", "url": "https://translations.documentfoundation.org/api/units/1511419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.023280Z" } ] }