Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/ca/changes/?format=api&page=9
{ "count": 1644, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/changes/?format=api&page=10", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/changes/?format=api&page=8", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/110972739/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.800259Z", "action": 59, "target": "Ús d'un prefix per defecte per als noms dels fulls", "id": 48710262, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710262/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972734/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.799178Z", "action": 59, "target": "La cita única és Unicode <literal>U+0027</literal> també conegut com a <literal>apòstrof</literal>. Es permeten altres caràcters d'una cita similar a l'apòstrof <literal></literal> com ara <literal>'</literal> <literal>‛</literal> i <literal>‚</literal>.", "id": 48710261, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710261/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972731/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.799136Z", "action": 59, "target": "cita <literal>'</literal> com el primer o últim caràcter del nom", "id": 48710260, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710260/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972726/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.799094Z", "action": 59, "target": "claudàtor quadrat dret <literal>]</literal>", "id": 48710259, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710259/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972721/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.799052Z", "action": 59, "target": "claudàtor quadrat esquerre <literal>[</literal>", "id": 48710258, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710258/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972718/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.799010Z", "action": 59, "target": "asterisc <literal>*</literal>", "id": 48710257, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710257/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972713/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798968Z", "action": 59, "target": "<unk>GA</literal>", "id": 48710256, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710256/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972707/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798925Z", "action": 59, "target": "barra inclinada <literal>/</literal>", "id": 48710255, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710255/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972704/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798882Z", "action": 59, "target": "barra <literal>\\</literal>", "id": 48710254, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710254/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972697/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798837Z", "action": 59, "target": "còlon <literal></literal>", "id": 48710253, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710253/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972693/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798792Z", "action": 59, "target": "Els noms dels fulls poden contenir gairebé qualsevol caràcter. Hi ha algunes restriccions, però: els caràcters següents no s'hi permeten:", "id": 48710252, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710252/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972689/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798747Z", "action": 59, "target": "Restriccions de noms de fulls", "id": 48710251, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710251/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972683/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798687Z", "action": 59, "target": "El document pot contenir fins a 10.000 fulls, cadascun dels quals ha de dur un nom diferent.", "id": 48710250, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710250/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972651/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798648Z", "action": 59, "target": "Alternativament, manteniu premuda la <switchinline select=\"sys\"><caseinline select=\"MAC\">tecla Opció</caseinline><defaultinline>tecla Alt</defaultinline></switchinline>, feu clic a qualsevol nom del full i introduïu directament el nom nou.", "id": 48710249, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710249/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972627/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798610Z", "action": 59, "target": "Introduïu un nom nou per al full i feu clic a <emph>D'acord</emph>.", "id": 48710248, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710248/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972619/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798572Z", "action": 59, "target": "Feu doble clic a la pestanya del full o obriu el menú contextual i trieu <menuitem>Canvia el nom del full</menuitem>. Apareixerà un diàleg on podreu introduir un nom nou.", "id": 48710247, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710247/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972616/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798536Z", "action": 59, "target": "Per canviar el nom d'un full en el document", "id": 48710246, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710246/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972596/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798499Z", "action": 59, "target": "El nom de cada full és independent del nom del document. Definireu el nom del document quan el deseu per primer cop com a fitxer.", "id": 48710245, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710245/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972591/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798461Z", "action": 59, "target": "Establir noms de fulls és una característica important per produir documents de fulls de càlcul llegibles i comprensibles.", "id": 48710244, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710244/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972587/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798425Z", "action": 59, "target": "<variable id=\"rename_table\"><link href=\"text/scalc/guide/rename_table.xhp\">Canvi de nom dels fulls</link></variable>", "id": 48710243, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710243/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972582/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798386Z", "action": 59, "target": "<bookmark_value>reanomenament;fulls</bookmark_value><bookmark_value>pestanyes dels fulls;reanomenament</bookmark_value><bookmark_value>taules;reanomenament</bookmark_value><bookmark_value>noms; fulls</bookmark_value>", "id": 48710242, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710242/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972577/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798347Z", "action": 59, "target": "Canvi de nom dels fulls", "id": 48710241, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710241/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972574/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798305Z", "action": 59, "target": "", "id": 48710240, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710240/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972571/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798263Z", "action": 59, "target": "", "id": 48710239, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710239/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972567/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798219Z", "action": 59, "target": "", "id": 48710238, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710238/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972562/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798174Z", "action": 59, "target": "", "id": 48710237, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710237/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972538/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798132Z", "action": 59, "target": "", "id": 48710236, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710236/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972536/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798091Z", "action": 59, "target": "", "id": 48710235, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710235/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972532/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798048Z", "action": 59, "target": "", "id": 48710234, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710234/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972530/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.798005Z", "action": 59, "target": "", "id": 48710233, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710233/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972526/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797963Z", "action": 59, "target": "", "id": 48710232, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710232/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972522/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797920Z", "action": 59, "target": "", "id": 48710231, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710231/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972520/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797879Z", "action": 59, "target": "", "id": 48710230, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710230/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972516/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797836Z", "action": 59, "target": "", "id": 48710229, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710229/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972514/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797794Z", "action": 59, "target": "Eliminació dels valors duplicats", "id": 48710228, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710228/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972509/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797753Z", "action": 59, "target": "A banda de quan s'insereixen files i columnes noves, les referències també poden canviar quan una fórmula existent que es refereix a cel·les particulars es copia a una altra àrea del full. Suposeu que heu introduït la fórmula =SUMA(A1:A9) a la fila 10. Si voleu calcular la suma per a la columna adjacent a la dreta, simplement copieu la fórmula a la cel·la de la dreta. La còpia de la fórmula a la columna B s'ajustarà automàticament a =SUMA(B1:B9).", "id": 48710227, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710227/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972504/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797710Z", "action": 59, "target": "Les referències absolutes s'utilitzen quan un càlcul es refereix a una cel·la específica del full. Si una fórmula que es refereix exactament a aquesta fila es copia de manera relativa a una cel·la sota de l'original, la referència també es mourà cap avall si no heu definit les coordenades de la cel·la com a absolutes.", "id": 48710226, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710226/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972502/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797666Z", "action": 59, "target": "Afortunadament, el $[officename] fa aquesta feina de manera automàtica. Després d'haver inserit la columna nova A, la fórmula =SUMA(A1:B2) s'actualitzarà automàticament a =SUMA(B1:C2). Els nombres de les files també s'ajustaran automàticament quan s'insereixi una fila 1 nova. Les referències absolutes i relatives s'ajusten al $[officename] Calc sempre que es mou l'àrea referenciada, però aneu amb compte quan copieu una fórmula, ja que en aquest cas només s'ajustaran les referències relatives, no les absolutes.", "id": 48710225, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710225/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972495/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797622Z", "action": 59, "target": "Què distingeix una referència relativa? Suposeu que a la cel·la E1 voleu calcular la suma de les cel·les de l'interval A1:B2. La fórmula que caldria introduir a E1 seria: =SUMA(A1:B2). Si més tard decidiu inserir una columna nova davant de la columna A, els elements que voleu afegir es trobarien a B1:C2 i la fórmula seria a F1, no a E1. Després d'inserir la columna nova, hauríeu de revisar i corregir totes les fórmules del full, i possiblement les d'altres fulls.", "id": 48710224, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710224/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972489/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797579Z", "action": 59, "target": "Quan s'han d'utilitzar les referències relatives i absolutes", "id": 48710223, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710223/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972482/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797536Z", "action": 59, "target": "El $[officename] Calc mostra les referències a una fórmula. Si, per exemple, feu clic a la fórmula =SUMA(A1:C5;D15:D24) a una cel·la, les dues àrees referenciades en el full es realçaran amb un color. Per exemple, el component de la fórmula «A1:C5» pot estar en blau i l'interval de la cel·la en qüestió pot tenir vores del mateix to de blau. El següent component de la fórmula «D15:D24» pot estar marcat en vermell de la mateixa manera.", "id": 48710222, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710222/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972479/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797495Z", "action": 59, "target": "", "id": 48710221, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710221/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972475/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797451Z", "action": 59, "target": "Les referències absolutes són les oposades a l'assignació d'adreces relatives. En una referència absoluta el signe del dòlar se situa davant de cada lletra i de cada nombre, per exemple, $A$1:$B$2.", "id": 48710220, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710220/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972473/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797406Z", "action": 59, "target": "Adreces absolutes", "id": 48710219, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710219/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972470/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797364Z", "action": 59, "target": "Si assigneu una àrea d'aquesta manera, esteu fent una referència relativa a A1:B2. Aquí, relativa vol dir que la referència a aquesta àrea s'ajustarà automàticament quan copieu les fórmules.", "id": 48710218, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710218/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972469/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797321Z", "action": 59, "target": "La cel·la de la columna A, fila 1 s'anomena A1. Podeu assignar un interval de cel·les adjacents introduint abans les coordenades de la cel·la superior esquerra de l'àrea i a continuació dos punts seguits per les coordenades de la cel·la inferior dreta. Per exemple, el quadrat format per les quatre primeres cel·les de l'angle superior esquerre s'assigna com a A1:B2.", "id": 48710217, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710217/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972464/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797278Z", "action": 59, "target": "Adreces relatives", "id": 48710216, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710216/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972457/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797236Z", "action": 59, "target": "", "id": 48710215, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710215/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972449/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797194Z", "action": 59, "target": "Intervals de cel·les", "id": 48710214, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710214/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110972446/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:29:55.797152Z", "action": 59, "target": "", "id": 48710213, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48710213/?format=api" } ] }