Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=120
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=121", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=119", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/title\">Enter the title that you want to display when the cell or cell range is selected.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/title\">Escriba'l títulu que deseya que s'amuese al escoyer la caxella o l'área de caxelles.</ahelp>" ], "id_hash": -6721495588795767196, "content_hash": -6721495588795767196, "location": "12120200.xhp", "context": "12120200.xhp\npar_id3149400\nhelp.text", "note": "EsFGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99280656/?format=api", "priority": 100, "id": 99523194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=22b8735fbe792664", "url": "https://translations.documentfoundation.org/api/units/99523194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.225000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Input help" ], "previous_source": "", "target": [ "Ayuda d'entrada" ], "id_hash": -6690119676337770090, "content_hash": -6690119676337770090, "location": "12120200.xhp", "context": "12120200.xhp\nhd_id3149121\nhelp.text", "note": "QiL6A", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99280699/?format=api", "priority": 100, "id": 99523199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2327eb99a3093196", "url": "https://translations.documentfoundation.org/api/units/99523199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.228332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/inputhelp\">Enter the message that you want to display when the cell or cell range is selected.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/inputhelp\">Escriba'l mensaxe que deseya que s'amuese al escoyer la caxella o l'área de caxelles.</ahelp>" ], "id_hash": 4887930933095072892, "content_hash": 4887930933095072892, "location": "12120200.xhp", "context": "12120200.xhp\npar_id3150752\nhelp.text", "note": "C3Tt3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99280752/?format=api", "priority": 100, "id": 99523211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c3d56b4949c6847c", "url": "https://translations.documentfoundation.org/api/units/99523211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.233177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Error Alert" ], "previous_source": "", "target": [ "Alerta de fallos" ], "id_hash": 7204537709117025682, "content_hash": 7204537709117025682, "location": "12120300.xhp", "context": "12120300.xhp\ntit\nhelp.text", "note": "w7EtY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99280791/?format=api", "priority": 100, "id": 99523217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e3fba8e00ad3ad92", "url": "https://translations.documentfoundation.org/api/units/99523217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.236713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/12120300.xhp\">Error Alert</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/12120300.xhp\">Alerta de fallos</link>" ], "id_hash": -1588111684138411646, "content_hash": -1588111684138411646, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3153821\nhelp.text", "note": "XoQah", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99280815/?format=api", "priority": 100, "id": 99523220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=69f5e4d663485982", "url": "https://translations.documentfoundation.org/api/units/99523220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.238566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Defines the error message that is displayed when invalid data is entered in a cell.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Define'l mensaxe de fallu qu'ha amosase al introducir datos incorreutos nuna caxella.</ahelp>" ], "id_hash": 1233669252356806036, "content_hash": 1233669252356806036, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3153379\nhelp.text", "note": "Ret79", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99280847/?format=api", "priority": 100, "id": 99523226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=911edfa6150c9594", "url": "https://translations.documentfoundation.org/api/units/99523226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.240572Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "You can also start a macro with an error message. A sample macro is provided at the end of this page." ], "previous_source": "", "target": [ "Tamién pue executase una macro con un mensaxe de fallu. A la fin d'esta páxina amuésase una macro d'exemplu." ], "id_hash": -1321536352868199254, "content_hash": -1321536352868199254, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3154138\nhelp.text", "note": "CqYXY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99280881/?format=api", "priority": 100, "id": 99523234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6da8f5b0598694aa", "url": "https://translations.documentfoundation.org/api/units/99523234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.243511Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Show error message when invalid values are entered." ], "previous_source": "", "target": [ "Amosar mensaxe de fallu al entrar valores incorrectos" ], "id_hash": -4436234289515250076, "content_hash": -4436234289515250076, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3156280\nhelp.text", "note": "3xGLr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99280906/?format=api", "priority": 100, "id": 99523241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=426f546af9093e64", "url": "https://translations.documentfoundation.org/api/units/99523241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.245759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\">Displays the error message that you enter in the <emph>Contents</emph> area when invalid data is entered in a cell.</ahelp> If enabled, the message is displayed to prevent an invalid entry." ], "previous_source": "", "target": [ "<ahelp hid=\".\">Amuesa'l mensaxe de fallu que s'introduz na seición <emph>Conteníu</emph> al ingresar datos inválidos nuna caxella.</ahelp> El mensaxe amosar pa prevenir l'ingresu de datos inválidos cuando ta habilitada esta opción." ], "id_hash": -3860965077880682059, "content_hash": -3860965077880682059, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3150768\nhelp.text", "note": "iEPGj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99280942/?format=api", "priority": 100, "id": 99523248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4a6b18b7cabbc9b5", "url": "https://translations.documentfoundation.org/api/units/99523248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.247466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "In both cases, if you select \"Stop\", the invalid entry is deleted and the previous value is reentered in the cell. The same applies if you close the \"Warning\" and \"Information\" dialogs by clicking the <emph>Cancel </emph>button. If you close the dialogs with the <emph>OK</emph> button, the invalid entry is not deleted." ], "previous_source": "", "target": [ "En dambos casos, si escueye la opción \"Detener\" la entrada incorrecta bórrase y restablezse na caxella'l valor anterior. Lo mesmo asocede si zarra los diálogos \"Alvertencia\" y \"Información\" calcando'l botón <emph>Encaboxar</emph>. Si zarra los diálogos col botón <emph>Aceutar</emph>, la entrada incorrecta nun se desaniciar." ], "id_hash": -9145480881195976107, "content_hash": -9145480881195976107, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3146984\nhelp.text", "note": "TXcNJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/99280983/?format=api", "priority": 100, "id": 99523254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0114b997e82ffa55", "url": "https://translations.documentfoundation.org/api/units/99523254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.249503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Contents" ], "previous_source": "", "target": [ "Conteníos" ], "id_hash": 4940687517473724030, "content_hash": 4940687517473724030, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3152460\nhelp.text", "note": "6FEcf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281033/?format=api", "priority": 100, "id": 99523260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c490d91ec93a567e", "url": "https://translations.documentfoundation.org/api/units/99523260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.373192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Action" ], "previous_source": "", "target": [ "Aición" ], "id_hash": -1745432522311539585, "content_hash": -1745432522311539585, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3148646\nhelp.text", "note": "qk32q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281115/?format=api", "priority": 100, "id": 99523262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=67c6fa5e6034e47f", "url": "https://translations.documentfoundation.org/api/units/99523262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.377266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/actionCB\">Select the action that you want to occur when invalid data is entered in a cell.</ahelp> The \"Stop\" action rejects the invalid entry and displays a dialog that you have to close by clicking <emph>OK</emph>. The \"Warning\" and \"Information\" actions display a dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>. The invalid entry is only rejected when you click <emph>Cancel</emph>." ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/actionCB\">Escueya l'aición que deseye que tenga llugar al introducir datos incorrectos nuna caxella.</ahelp> L'aición \"Detener\" refuga la entrada incorrecta y amuesa un diálogu que se debe zarrar calcando <emph>Aceutar</emph>. Les acciones \"Alvertencia\" y \"Información\" amuesen un diálogu que pue zarrase calcando <emph>Aceutar</emph> o <emph>Encaboxar</emph>. La entrada incorrecta namái se refuga si faise clic en <emph>Encaboxar</emph>." ], "id_hash": -7400310107330147609, "content_hash": -7400310107330147609, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3151115\nhelp.text", "note": "eDPY4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/99281153/?format=api", "priority": 100, "id": 99523265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=194cd12a78da8ae7", "url": "https://translations.documentfoundation.org/api/units/99523265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.378777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Browse" ], "previous_source": "", "target": [ "Restolar" ], "id_hash": 4002924905075615968, "content_hash": 4002924905075615968, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3156441\nhelp.text", "note": "tCT5q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281180/?format=api", "priority": 100, "id": 99523267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b78d3efe2598a8e0", "url": "https://translations.documentfoundation.org/api/units/99523267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.381041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/browseBtn\">Opens the <link href=\"text/shared/01/06130000.xhp\">Macro</link> dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/browseBtn\">Abre'l diálogu <link href=\"text/shared/01/06130000.xhp\">Macro</link>, onde pue escoyer la macro que se va executar al introducir datos incorrectos nuna caxella. La macro execútase dempués d'amosar el mensaxe de fallu.</ahelp>" ], "id_hash": 3856631479866971497, "content_hash": 3856631479866971497, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3153160\nhelp.text", "note": "NHAMn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99281202/?format=api", "priority": 100, "id": 99523271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b58581e5cb0f5569", "url": "https://translations.documentfoundation.org/api/units/99523271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.382741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Title" ], "previous_source": "", "target": [ "Títulu" ], "id_hash": 4763194959483245165, "content_hash": 4763194959483245165, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3153876\nhelp.text", "note": "WZjAF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281221/?format=api", "priority": 100, "id": 99523278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c21a449443ee126d", "url": "https://translations.documentfoundation.org/api/units/99523278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.385367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/title\">Enter the title of the macro or the error message that you want to display when invalid data is entered in a cell.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/title\">Escriba'l títulu de la macro o'l mensaxe de fallu que deseya que s'amuese al introducir datos incorrectos nuna caxella.</ahelp>" ], "id_hash": 8108274495734413626, "content_hash": 8108274495734413626, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3149410\nhelp.text", "note": "GFCFe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99281241/?format=api", "priority": 100, "id": 99523282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f08660b1c39bf93a", "url": "https://translations.documentfoundation.org/api/units/99523282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.387050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Error message" ], "previous_source": "", "target": [ "Mensaxe de fallu" ], "id_hash": -4290662514667656518, "content_hash": -4290662514667656518, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id3154510\nhelp.text", "note": "6CdzQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99281261/?format=api", "priority": 100, "id": 99523295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4474812d02266aba", "url": "https://translations.documentfoundation.org/api/units/99523295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.391454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/errorMsg\">Enter the message that you want to display when invalid data is entered in a cell.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/errorMsg\">Escriba'l mensaxe que deseya que s'amuese al introducir datos incorrectos nuna caxella.</ahelp>" ], "id_hash": -3429678990883797573, "content_hash": -3429678990883797573, "location": "12120300.xhp", "context": "12120300.xhp\npar_id3149122\nhelp.text", "note": "CTvnv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99281281/?format=api", "priority": 100, "id": 99523301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5067552106c045bb", "url": "https://translations.documentfoundation.org/api/units/99523301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.393306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Sample macro:" ], "previous_source": "", "target": [ "" ], "id_hash": 3329370545789318535, "content_hash": 3329370545789318535, "location": "12120300.xhp", "context": "12120300.xhp\nhd_id881545240342781\nhelp.text", "note": "c9UDY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99281298/?format=api", "priority": 100, "id": 99523320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae344cdf236bb587", "url": "https://translations.documentfoundation.org/api/units/99523320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.403177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Below is a sample function that can be called when an error occurs. Note that the macro takes in two parameters that are passed on by %PRODUCTNAME when the function is called:" ], "previous_source": "", "target": [ "" ], "id_hash": -780777889672446798, "content_hash": -780777889672446798, "location": "12120300.xhp", "context": "12120300.xhp\npar_id521625929022780\nhelp.text", "note": "vkaMd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99281316/?format=api", "priority": 100, "id": 99523326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=752a1ea565983cb2", "url": "https://translations.documentfoundation.org/api/units/99523326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.407199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>CellValue</emph>: The value entered by the user, as a String." ], "previous_source": "", "target": [ "" ], "id_hash": 100742523085178983, "content_hash": 100742523085178983, "location": "12120300.xhp", "context": "12120300.xhp\npar_id981625929097216\nhelp.text", "note": "F9upo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99281335/?format=api", "priority": 100, "id": 99523332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8165e8ca7e44c867", "url": "https://translations.documentfoundation.org/api/units/99523332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.412310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>CellAddress</emph>: The address of the cell where the value was entered, as a String prefixed with the sheet name (e.g: \"Sheet1.A1\")." ], "previous_source": "", "target": [ "" ], "id_hash": -1133945098779341118, "content_hash": -1133945098779341118, "location": "12120300.xhp", "context": "12120300.xhp\npar_id421625929100152\nhelp.text", "note": "oSFqW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99281346/?format=api", "priority": 100, "id": 99523339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=70436af0c8764ec2", "url": "https://translations.documentfoundation.org/api/units/99523339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.415430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The function must return a Boolean value. If it returns <literal>True</literal>, the entered value is kept. If the function returns <literal>False</literal>, the entered value is erased and the previous value is restored." ], "previous_source": "", "target": [ "" ], "id_hash": -192349039727920713, "content_hash": -192349039727920713, "location": "12120300.xhp", "context": "12120300.xhp\npar_id101625929384030\nhelp.text", "note": "A52Nm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/99281384/?format=api", "priority": 100, "id": 99523342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7d54a391462139b7", "url": "https://translations.documentfoundation.org/api/units/99523342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.417120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "msg = \"Invalid value: \" & \"'\" & CellValue & \"'\"" ], "previous_source": "", "target": [ "" ], "id_hash": 517176829023712635, "content_hash": 517176829023712635, "location": "12120300.xhp", "context": "12120300.xhp\npar_id531545240216611\nhelp.text", "note": "4tzCz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99281413/?format=api", "priority": 100, "id": 99523347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=872d6195fc05757b", "url": "https://translations.documentfoundation.org/api/units/99523347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.418703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "msg = msg & \" in cell: \" & \"'\" & CellAddress & \"'\"" ], "previous_source": "", "target": [ "" ], "id_hash": -5686792953037051487, "content_hash": -5686792953037051487, "location": "12120300.xhp", "context": "12120300.xhp\nbas_id971625928577365\nhelp.text", "note": "Zfic8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99281448/?format=api", "priority": 100, "id": 99523350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=311473f06b0829a1", "url": "https://translations.documentfoundation.org/api/units/99523350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.420305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "msg = msg & Chr(10) & \"Accept anyway?\"" ], "previous_source": "", "target": [ "" ], "id_hash": 3884342064576181528, "content_hash": 3884342064576181528, "location": "12120300.xhp", "context": "12120300.xhp\nbas_id181625928577640\nhelp.text", "note": "hiNR9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99281455/?format=api", "priority": 100, "id": 99523355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b5e7f487112bb518", "url": "https://translations.documentfoundation.org/api/units/99523355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.423225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "iAnswer = MsgBox (msg , MB_FLAGS, \"Error message\")" ], "previous_source": "", "target": [ "iAnswer = MsgBox (msg , MB_FLAGS, \"Mensaxe d'error\")" ], "id_hash": 7672931698638373893, "content_hash": 7672931698638373893, "location": "12120300.xhp", "context": "12120300.xhp\nbas_id941625928578118\nhelp.text", "note": "EhFBn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99281492/?format=api", "priority": 100, "id": 99523358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ea7bbaba1b2cc405", "url": "https://translations.documentfoundation.org/api/units/99523358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.425050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ODFF" ], "previous_source": "", "target": [ "ODFF" ], "id_hash": -259829638655111881, "content_hash": -259829638655111881, "location": "ODFF.xhp", "context": "ODFF.xhp\ntit\nhelp.text", "note": "4C6T2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281528/?format=api", "priority": 100, "id": 99523361, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7c64e651fdd80d37", "url": "https://translations.documentfoundation.org/api/units/99523361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.426785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)" ], "previous_source": "", "target": [ "" ], "id_hash": -2908931507336042508, "content_hash": -2908931507336042508, "location": "ODFF.xhp", "context": "ODFF.xhp\nhd_id1000010\nhelp.text", "note": "RZfPH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99281546/?format=api", "priority": 100, "id": 99523365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=57a16634cd4b27f4", "url": "https://translations.documentfoundation.org/api/units/99523365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.428719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.3." ], "previous_source": "", "target": [ "" ], "id_hash": -2795688898410823662, "content_hash": -2795688898410823662, "location": "ODFF.xhp", "context": "ODFF.xhp\nhd_id1000013\nhelp.text", "note": "BFcB6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99281592/?format=api", "priority": 100, "id": 99523367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5933b7c253b84012", "url": "https://translations.documentfoundation.org/api/units/99523367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.431123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculate" ], "previous_source": "", "target": [ "" ], "id_hash": -4505439404257030050, "content_hash": -4505439404257030050, "location": "calculate.xhp", "context": "calculate.xhp\ntit\nhelp.text", "note": "SGHPh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99281647/?format=api", "priority": 100, "id": 99523380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=417976bb9036505e", "url": "https://translations.documentfoundation.org/api/units/99523380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.437929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/calculate.xhp\">Calculate</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 6478986767259742098, "content_hash": 6478986767259742098, "location": "calculate.xhp", "context": "calculate.xhp\nhd_id621584668179317\nhelp.text", "note": "7dvqE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99281667/?format=api", "priority": 100, "id": 99523383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d9e9fc233ef92f92", "url": "https://translations.documentfoundation.org/api/units/99523383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.439595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Commands to calculate formula cells." ], "previous_source": "", "target": [ "Comandos pa calcular caxelles con fórmules." ], "id_hash": -8639535070997214806, "content_hash": -8639535070997214806, "location": "calculate.xhp", "context": "calculate.xhp\npar_id241584668179318\nhelp.text", "note": "8YGcD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99281693/?format=api", "priority": 100, "id": 99523386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=081a34a08cae89aa", "url": "https://translations.documentfoundation.org/api/units/99523386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.441056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Choose <menuitem>Data - Calculate</menuitem>" ], "previous_source": "", "target": [ "Escueyi <menuitem>Datos - Calcular</menuitem>" ], "id_hash": -2895625525376226160, "content_hash": -2895625525376226160, "location": "calculate.xhp", "context": "calculate.xhp\npar_id251645222672072\nhelp.text", "note": "f2aRJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99281706/?format=api", "priority": 100, "id": 99523389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=57d0abed25656c90", "url": "https://translations.documentfoundation.org/api/units/99523389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.442892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculation Accuracy" ], "previous_source": "", "target": [ "Precisión del cálculu" ], "id_hash": 7194142236925268251, "content_hash": 7194142236925268251, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\ntit\nhelp.text", "note": "9AbDs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99281724/?format=api", "priority": 100, "id": 99523393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e3d6ba3f8f90911b", "url": "https://translations.documentfoundation.org/api/units/99523393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.445017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>calculation;accuracy</bookmark_value> <bookmark_value>precision;calculation</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8526925647895807578, "content_hash": 8526925647895807578, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\nbm_id741642020503366\nhelp.text", "note": "8Bv3f", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99281771/?format=api", "priority": 100, "id": 99523398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f655b9b2fcff465a", "url": "https://translations.documentfoundation.org/api/units/99523398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.449859Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/calculation_accuracy.xhp\">%PRODUCTNAME Calculation Accuracy</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/calculation_accuracy.xhp\">Precisión de cálculos en %PRODUCTNAME</link>" ], "id_hash": 92165820666071387, "content_hash": 92165820666071387, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\nhd_id961642017927878\nhelp.text", "note": "wPGAg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99281807/?format=api", "priority": 100, "id": 99523401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=81477053593bc95b", "url": "https://translations.documentfoundation.org/api/units/99523401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.451507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Inherent Accuracy Problem" ], "previous_source": "", "target": [ "" ], "id_hash": -4759422949506098076, "content_hash": -4759422949506098076, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\nhd_id941642017968835\nhelp.text", "note": "sW5fH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99281838/?format=api", "priority": 100, "id": 99523411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3df3220b3ed8dc64", "url": "https://translations.documentfoundation.org/api/units/99523411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.458034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "%PRODUCTNAME Calc, just like most other spreadsheet software, uses floating-point math capabilities available on hardware. Given that most contemporary hardware uses binary floating-point arithmetic with limited precision defined in <link href=\"https://en.wikipedia.org/wiki/IEEE_754\">IEEE 754</link> standard, many decimal numbers - including as simple as 0.1 - cannot be precisely represented in %PRODUCTNAME Calc (which uses 64-bit double-precision numbers internally)." ], "previous_source": "", "target": [ "" ], "id_hash": 4669054549008670639, "content_hash": 4669054549008670639, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id541642018071800\nhelp.text", "note": "sVT3D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/99281863/?format=api", "priority": 100, "id": 99523413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c0cbd05fe6955faf", "url": "https://translations.documentfoundation.org/api/units/99523413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.460293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculations with those numbers necessarily <link href=\"https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems\">results in rounding errors</link>, and those accumulate with every calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -1597852292874000379, "content_hash": -1597852292874000379, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id191642019423811\nhelp.text", "note": "mdFJq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99281893/?format=api", "priority": 100, "id": 99523420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=69d349ce2fb3a805", "url": "https://translations.documentfoundation.org/api/units/99523420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.462491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This is not a bug, but is expected and currently unavoidable without using complex calculations in software, which would incur inappropriate performance penalties, and thus is out of question. Users need to account for that, and use rounding and comparisons with <link href=\"https://en.wikipedia.org/wiki/Machine_epsilon\">machine epsilon (or unit roundoff)</link> as necessary." ], "previous_source": "", "target": [ "" ], "id_hash": -7086398979241201622, "content_hash": -7086398979241201622, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id221642019437175\nhelp.text", "note": "LnjTN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/99281937/?format=api", "priority": 100, "id": 99523423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1da80dac79a3302a", "url": "https://translations.documentfoundation.org/api/units/99523423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.464096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "An example with numbers:" ], "previous_source": "", "target": [ "Un exemplu con númberos:" ], "id_hash": 197957955335728880, "content_hash": 197957955335728880, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id801642019531438\nhelp.text", "note": "ncGy5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99281963/?format=api", "priority": 100, "id": 99523429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=82bf49b6283faef0", "url": "https://translations.documentfoundation.org/api/units/99523429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.831246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This will result in -999.129999999997 in A3, instead of expected -999.13 (you might need to increase shown decimal places in cell format to see this)." ], "previous_source": "", "target": [ "" ], "id_hash": 3539363844637866725, "content_hash": 3539363844637866725, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id761642018318896\nhelp.text", "note": "BpnPy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99281993/?format=api", "priority": 100, "id": 99523448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b11e58aa12803ae5", "url": "https://translations.documentfoundation.org/api/units/99523448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.840320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "An example with dates and times:" ], "previous_source": "", "target": [ "Un exemplu con dates y hores:" ], "id_hash": -1067950478859783331, "content_hash": -1067950478859783331, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id221642020132399\nhelp.text", "note": "kDcn9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99282015/?format=api", "priority": 100, "id": 99523453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=712de0b29ddab35d", "url": "https://translations.documentfoundation.org/api/units/99523453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.841990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Due to the specific of time representation in Calc, this also applies to all calculations involving times. For example, the cells A1 and A2 below show the date and time data as entered (in ISO 8601 format):" ], "previous_source": "", "target": [ "" ], "id_hash": -1225837895091161012, "content_hash": -1225837895091161012, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id801642018326882\nhelp.text", "note": "aWCYz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99282035/?format=api", "priority": 100, "id": 99523460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6efcf2eddee0f84c", "url": "https://translations.documentfoundation.org/api/units/99523460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.843696Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Cell A3 will show 00:10:00 if the default formatting [HH]:MM:SS is applied to the cell. However, cell A3 will show 00:09:59.999999 instead of expected 00:10:00.000000 if formatted using [HH]:MM:SS.000000 format string. This happens despite only whole numbers of hours and minutes were used, because internally, any time is a fraction of a day, 12:00 (noon) being represented as 0.5." ], "previous_source": "", "target": [ "" ], "id_hash": -2906831234666046813, "content_hash": -2906831234666046813, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id101643312991679\nhelp.text", "note": "rcuhc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/99282052/?format=api", "priority": 100, "id": 99523465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=57a8dc64a3b85aa3", "url": "https://translations.documentfoundation.org/api/units/99523465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.845186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The data in A1 is represented internally as 43934.5125, and in A2 as 43934.5055555555591126903891563 (which is not exact representation of the entered datetime, which would be 43934.505555555555555555...)." ], "previous_source": "", "target": [ "" ], "id_hash": 7581120068996414268, "content_hash": 7581120068996414268, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id921642020011065\nhelp.text", "note": "EZjhJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99282083/?format=api", "priority": 100, "id": 99523467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e9358c89481dbb3c", "url": "https://translations.documentfoundation.org/api/units/99523467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.846604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Their subtraction results in 0.00694444443287037, a value slightly less than expected 0.00694444444444..., which is 10 minutes." ], "previous_source": "", "target": [ "" ], "id_hash": -8901510994812390973, "content_hash": -8901510994812390973, "location": "calculation_accuracy.xhp", "context": "calculation_accuracy.xhp\npar_id801642020017858\nhelp.text", "note": "QY6Ti", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99282108/?format=api", "priority": 100, "id": 99523473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=04777ae995f931c3", "url": "https://translations.documentfoundation.org/api/units/99523473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.848953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Cell Styles" ], "previous_source": "", "target": [ "" ], "id_hash": 902117330872616789, "content_hash": 902117330872616789, "location": "cell_styles.xhp", "context": "cell_styles.xhp\ntit\nhelp.text", "note": "J8xZD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99282155/?format=api", "priority": 100, "id": 99523476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8c84f6eecc62c755", "url": "https://translations.documentfoundation.org/api/units/99523476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:22.850544Z" } ] }