Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=143
{ "count": 8388, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=144", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=142", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/56109379/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:26:20.902359Z", "action": 4, "target": "<item type=\"input\">=EXTRAEB(\"中国\";1;3)</item> devuelve \"中\" (3 bytes constituyen un carácter DBCS y medio; el último byte da como resultado un carácter de espacio).", "id": 2824747, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824747/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109378/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:25:37.786491Z", "action": 4, "target": "<item type=\"input\">=EXTRAEB(\"中国\";1;2)</item> devuelve \"中\" (2 bytes constituyen un carácter DBCS completo).", "id": 2824746, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824746/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109377/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:25:21.269903Z", "action": 4, "target": "<item type=\"input\">=EXTRAEB(\"中国\";1;1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y, por lo tanto, el resultado es un carácter de espacio).", "id": 2824745, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824745/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109376/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:25:06.575263Z", "action": 4, "target": "<item type=\"input\">=EXTRAEB(\"中国\";1;0)</item> devuelve \"\" (0 bytes siempre es una cadena vacía).", "id": 2824744, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824744/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109375/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:23:45.506216Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"oficina\";3)</item> devuelve \"ofi\" (3 caracteres que no son DBCS, cada uno de los cuales consta de 1 byte).", "id": 2824743, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824743/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109374/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:23:06.999123Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";4)</item> devuelve \"中国\" (4 bytes constituyen dos caracteres DBCS completos).", "id": 2824742, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824742/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:22:20.399283Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y en su lugar se devuelve un carácter de espacio).", "id": 2824741, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824741/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:22:09.252325Z", "action": 26, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y en su lugar se devuelve un carácter de espacio).\n", "id": 2824740, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824740/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109373/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:21:34.194076Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";3)</item> devuelve \"中\" (3 bytes constituyen un carácter DBCS y medio; el último carácter devuelto es, por lo tanto, un carácter de espacio).", "id": 2824739, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824739/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:20:54.234022Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y en su lugar se devuelve un carácter de espacio).\n", "id": 2824738, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824738/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:20:36.446626Z", "action": 26, "target": "<item type=\"input\">=IZQUIEEDAB(\"中国\";1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y en su lugar se devuelve un carácter de espacio).", "id": 2824737, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824737/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109372/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:20:20.343080Z", "action": 4, "target": "<item type=\"input\">=IZQUIERDAB(\"中国\";2)</item> devuelve \"中\" (2 bytes constituyen un carácter DBCS completo).", "id": 2824736, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824736/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:19:50.345057Z", "action": 4, "target": "<item type=\"input\">=IZQUIEEDAB(\"中国\";1)</item> devuelve \" \" (1 byte es solo la mitad de un carácter DBCS y en su lugar se devuelve un carácter de espacio).", "id": 2824735, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824735/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459591/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:18:50.818216Z", "action": 4, "target": "IZQUIERDAB(\"Texto\" [; Número_bytes])\n", "id": 2824734, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824734/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459591/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:18:38.166624Z", "action": 26, "target": "IZQUIERDA(\"Texto\" [; Número_bytes])", "id": 2824733, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824733/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459591/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:18:25.603505Z", "action": 4, "target": "IZQUIERDA(\"Texto\" [; Número_bytes])", "id": 2824732, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824732/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459587/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:17:32.253594Z", "action": 4, "target": "IZQUIERDA(\"Texto\" [; Número])", "id": 2824731, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824731/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45723688/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:16:50.237825Z", "action": 4, "target": "<item type=\"input\">=FIJO(12345.789;8/5)</item> devuelve 12.345,8 como cadena de texto.", "id": 2824730, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824730/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548247/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:16:32.027626Z", "action": 4, "target": "<item type=\"input\">=FIJO(12345.789;3/4)</item> devuelve 12,346 como una cadena de texto.", "id": 2824729, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824729/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548246/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:16:16.989933Z", "action": 4, "target": "<item type=\"input\">=FIJO(12134567.89;-3;1)</item> devuelve 12135000 como una cadena de texto.", "id": 2824728, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824728/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548245/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:15:58.797803Z", "action": 4, "target": "<item type=\"input\">=FIJO(12345.6789;-2)</item> devuelve 12,300 como una cadena de texto.", "id": 2824727, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824727/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548244/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:15:32.211812Z", "action": 4, "target": "<item type=\"input\">=FIJO(123456.789;;TRUE)</item> devuelve 123456.79 como una cadena de texto.", "id": 2824726, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824726/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548242/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T23:08:04.243002Z", "action": 4, "target": "<emph>Decimales</emph> (opcional) se refiere a la cantidad de lugares decimales que se mostrarán. Si <literal>Decimales</literal> es negativo, <literal>Número</literal> se redondea a su valor absoluto ABS(<literal>Decimales</literal>) lugares a la izquierda del punto decimal. Si <literal>Decimales</literal> es una fracción, se trunca ignorando cuál es el entero más cercano.", "id": 2824724, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824724/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548240/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:57:52.523845Z", "action": 4, "target": "FIJO(Número; [Decimales = 2 [; SinSeparadorMiles = FALSO]])", "id": 2824722, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824722/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45548239/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:56:54.535554Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_FEST\">Devuelve un número como texto con un número específico de lugares decimales y separadores de miles opcionales.</ahelp>", "id": 2824721, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824721/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459574/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:55:44.429911Z", "action": 4, "target": "ENCONTRAR(\"EncontrarTexto\"; \"Texto\" [; Posición])", "id": 2824720, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824720/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907745/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:54:26.163453Z", "action": 4, "target": "<item type=\"input\">=MONEDA(255)</item> devuelve $255,00 para la configuración regional en inglés (EE. UU.) y la moneda USD (dólar); 255,00 yenes para la moneda local japonesa y JPY (yen); o 255,00 € para el idioma alemán (Alemania) y la moneda EUR (euro).", "id": 2824719, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824719/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459566/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:53:20.616737Z", "action": 4, "target": "MONEDA(Valor [; Decimales])", "id": 2824718, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824718/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209271/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:50:04.723923Z", "action": 4, "target": "<emph>Cadena 1[; Cadena 2][; … ;[String 255]]</emph> son cadenas o referencias a celdas que contienen cadenas.", "id": 2824716, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824716/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209270/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:48:35.767932Z", "action": 4, "target": "CONCATENAR(<embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/>)", "id": 2824715, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824715/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907744/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T22:48:13.579064Z", "action": 4, "target": "<input>=LARGO(LIMPIAR(CARACTER(7) & \"LibreOffice Calc\" & CARACTER(8)))</input> devuelve 16, lo que muestra que la función CLEAN elimina el Unicode no imprimible U+0007 (\"BEL\") y U+0008 (\"BS\") caracteres al principio y al final del argumento de cadena. CLEAN no elimina espacios.", "id": 2824714, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824714/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459544/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T21:12:18.432947Z", "action": 4, "target": "BASE(Número; Base [; LongitudMínima])", "id": 2824627, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824627/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109367/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T21:05:38.896352Z", "action": 4, "target": "Puede usar la función CARACTER o la función UNICAR para insertar una comilla doble. Por ejemplo, la fórmula <input>=UNICAR(34) & \"The Guardián entre el centeno\" & UNICAR(34) & \" es un libro famoso de JD Salinger\".</input> muestra la cadena <literal>\"El Guardián entre el centeno\" es un famoso libro de JD Salinger.</literal>", "id": 2824622, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824622/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109366/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T21:01:20.085146Z", "action": 4, "target": "Puede \"escapar\" las comillas dobles con una comilla doble adicional, Calc trata las comillas dobles escapadas como un valor literal. Por ejemplo, la fórmula <input>=\"Mi nombre es \"\"John Doe\"\".\"</input> genera la cadena <literal>Mi nombre es \"John Doe\". </literal> Otro ejemplo simple es la fórmula <input>=UNICODE(\"\"\"\")</input> que devuelve <literal>34</literal>, el valor decimal del carácter de comillas Unicode (U+0022) — aquí las comillas dobles primera y cuarta indican el principio y el final de la cadena, mientras que la segunda comilla doble escapa a la tercera.", "id": 2824621, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824621/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109365/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:58:59.848413Z", "action": 4, "target": "Para colocar una comilla doble literal dentro de una cadena en de una fórmula, se pueden usar dos métodos:", "id": 2824620, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824620/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109364/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:58:36.867385Z", "action": 4, "target": "La fórmula más compleja <input>=CONCATENAR(\"La vida es realmente simple, \"; \"pero insistimos en hacerla complicada\"; \"(Confucio)\")</input> concatena tres cadenas individuales entre comillas dobles, generando <literal>La vida es realmente simple, pero insistimos en complicarla (Confucio).</literal>", "id": 2824619, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824619/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109363/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:57:19.262502Z", "action": 4, "target": "Para incluir una cadena de texto en una fórmula, coloque la cadena de texto entre comillas dobles (\"), Calc toma los caracteres de la cadena sin intentar interpretarlos. Por ejemplo, la fórmula <input>=\"¡Hola mundo!\"< /input> muestra la cadena de texto <literal>¡Hola mundo!</literal> en la celda, sin las comillas dobles envolventes.\n", "id": 2824618, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824618/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109363/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:57:08.545544Z", "action": 26, "target": "Para incluir una cadena de texto en una fórmula, coloque la cadena de texto entre dos comillas dobles (\"), Calc toma los caracteres de la cadena sin intentar interpretarlos. Por ejemplo, la fórmula <input>=\"¡Hola mundo!\"< /input> muestra la cadena de texto <literal>¡Hola mundo!</literal> en la celda, sin las comillas dobles envolventes.", "id": 2824617, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824617/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109363/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:56:20.200658Z", "action": 4, "target": "Para incluir una cadena de texto en una fórmula, coloque la cadena de texto entre dos comillas dobles (\"), Calc toma los caracteres de la cadena sin intentar interpretarlos. Por ejemplo, la fórmula <input>=\"¡Hola mundo!\"< /input> muestra la cadena de texto <literal>¡Hola mundo!</literal> en la celda, sin las comillas dobles envolventes.", "id": 2824616, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824616/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56109361/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:55:09.734579Z", "action": 4, "target": "<bookmark_value>Uso de comillas dobles en fórmulas</bookmark_value> <bookmark_value>fórmulas; usando comillas dobles</bookmark_value>", "id": 2824615, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824615/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45065141/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:54:12.002847Z", "action": 4, "target": "Si no se proporciona ninguna restricción para un filtro, el valor seleccionado del campo se usa implícitamente. Si se proporciona una restricción para un filtro, debe coincidir con el valor seleccionado del campo o se devolverá un error. Los filtros son los campos en la parte superior izquierda de una tabla dinámica, que se completan con el área \"Filtros\" del diálogo de diseño de la tabla dinámica. De cada filtro, se puede seleccionar un elemento (valor), lo que significa que solo ese elemento se incluye en el cálculo.", "id": 2824614, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824614/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25243120/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:53:11.045320Z", "action": 4, "target": "IMPORTARDATOSDINAMICOS(CampoDestino; TablaDinámica[; Campo 1; Elemento 1][; ... [Campo 126; Elemento 126]])\n", "id": 2824613, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824613/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45494037/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:51:08.334340Z", "action": 4, "target": "<input>=HIPERVINCULO(\"http://www.\";\"Click \") & \"example.org\"</input> muestra el texto Click example.org en la celda y ejecuta el hipervínculo http://www.example .org cuando se hace clic.", "id": 2824612, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824612/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45494036/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:50:27.295178Z", "action": 4, "target": "<input>=HIPERVINCULO($B4)</input> cuando la celda B4 contiene <literal>http://www.example.org</literal>. La función agrega http://www.example.org a la URL de la celda del hipervínculo y devuelve el mismo texto que se usa como resultado de la fórmula.", "id": 2824611, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824611/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45494035/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:49:13.961560Z", "action": 4, "target": "<input>=HIPERVINCULO(\"http://www.example.org\";12345)</input> muestra el número 12345 y ejecuta el hipervínculo http://www.example.org cuando se hace clic.", "id": 2824610, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824610/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45494034/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:48:33.564469Z", "action": 4, "target": "<input>=HIPERVINCULO(\"http://www.example.org\";\"Haga clic aquí\")</input> muestra el texto \"Haga clic aquí\" en la celda y ejecuta el hipervínculo http://www.example.org cuando se hace clic.", "id": 2824609, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824609/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45494033/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:47:37.125962Z", "action": 4, "target": "<input>=HIPERVINCULO(\"http://www.example.org\")</input> muestra el texto \"http://www.example.org\" en la celda y ejecuta el hipervínculo http://www.example .org cuando se hace clic.", "id": 2824608, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824608/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852537/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:45:57.163281Z", "action": 4, "target": "<emph>URL</emph> especifica el destino del vínculo. El parámetro <emph>TextodeCelda</emph> opcional es el texto o un número que se muestra en la celda y que se devolverá como resultado. Si no se especifica el parámetro <emph>TextodeCelda</emph>, se muestra la dirección <emph>URL</emph> en el texto de la celda y se devolverá como resultado.", "id": 2824607, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824607/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852535/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:44:40.610326Z", "action": 4, "target": "Si utiliza el parámetro <emph>TextodeCelda</emph> opcional, la fórmula localiza el URL y muestra el texto o número.", "id": 2824606, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824606/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852535/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:44:22.967196Z", "action": 26, "target": "Si utiliza el parámetro <emph>Texto de la celda</emph> opcional, la fórmula localiza el URL y muestra el texto o número.", "id": 2824605, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824605/?format=api" } ] }