Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=34
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=33", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "" ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942720/?format=api", "priority": 100, "id": 1499723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/1499723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.840361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "" ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942721/?format=api", "priority": 100, "id": 1499724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/1499724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.855544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "" ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942722/?format=api", "priority": 100, "id": 1499725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/1499725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.866611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Funkcio ELEKTI</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942734/?format=api", "priority": 100, "id": 1499737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/1499737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.013473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "ELEKTI" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942735/?format=api", "priority": 100, "id": 1499738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/1499738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.024165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uzas indekson por liveri valoron el listo de ĝis 30 valoroj.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942736/?format=api", "priority": 100, "id": 1499739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/1499739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.037404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "" ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942740/?format=api", "priority": 100, "id": 1499743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/1499743/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.080730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HSERĈO-funkcio</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942741/?format=api", "priority": 100, "id": 1499744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/1499744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.093116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "HSERĈO" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942742/?format=api", "priority": 100, "id": 1499745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/1499745/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.105526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Serĉas valoron kaj referencon al la ĉeloj sub la elektita ĉelaro.</ahelp> Ĉi tiu funkcio kontrolas ĉu la unua vico de tabelo enhavas specifan valoron. La funkcio liveras la valoron en vico de la tabelo, nomita en la <emph>Indekso</emph>, en la sama kolumno." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942743/?format=api", "priority": 100, "id": 1499746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/1499746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.116820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>VICO-funkcio</bookmark_value>" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942744/?format=api", "priority": 100, "id": 1499749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/1499749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.173325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "VICO" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942745/?format=api", "priority": 100, "id": 1499750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/1499750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.190400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph>Reference</emph> estas ĉelo, ĉelaro aŭ la nomo de ĉelaro." ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942748/?format=api", "priority": 100, "id": 1499753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/1499753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.227668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Se vi ne indikas referecon, la funkcio liveros la vican nombron de la ĉelo en kiu la formulo estas enigita. <item type=\"productname\">%PRODUCTNAME</item> Calc aŭtomate agordas la referencon al la aktuala ĉelo." ], "id_hash": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942749/?format=api", "priority": 100, "id": 1499754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/1499754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.237996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=VICO(B3)</item> liveras je 3 ĉar la referenco referas al la tria vico en la tabelo." ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942750/?format=api", "priority": 100, "id": 1499755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/1499755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.253636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "<item type=\"input\">{=Vico(D5:D8)}</item> liveras la unukolumnan tabelon (5, 6, 7, 8) ĉar la referenco specifita enhavas vicojn 5 ĝis 8." ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942751/?format=api", "priority": 100, "id": 1499756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/1499756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.265534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=ROW(D5:D8)</item> liveras je 5 ĉar la funkcio VICO ne estas uzata kiel tabela formulo do ĝi liveras nur la nombron de la unua vico de la referenco." ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942752/?format=api", "priority": 100, "id": 1499757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/1499757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.275366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "" ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24942753/?format=api", "priority": 100, "id": 1499758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/1499758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.285368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "<item type=\"input\">=VICO()</item> liveras je 3 se la formulo estas enigita en vico 3." ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942754/?format=api", "priority": 100, "id": 1499759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/1499759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.297092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=VICO(Kuniklo)}</item> liveras la unukolumnan tabelon (1, 2, 3) se \"Kuniklo\" estas la nomita ĉelaro (C1:D3)." ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942755/?format=api", "priority": 100, "id": 1499760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/1499760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.308086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>VICOJ-funkcio</bookmark_value>" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942756/?format=api", "priority": 100, "id": 1499761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/1499761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.320824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "VICOJ" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942757/?format=api", "priority": 100, "id": 1499762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/1499762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.329124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Liveras la nombron da vicoj en referenco aŭ tabelo.</ahelp>" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942758/?format=api", "priority": 100, "id": 1499763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/1499763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.342193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942759/?format=api", "priority": 100, "id": 1499764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/1499764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.355404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "" ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942760/?format=api", "priority": 100, "id": 1499765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/1499765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.366609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "<item type=\"input\">=VICOJ(B5)</item> liveras je 1 ĉar ĉelo enhavas nur unu vicon." ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942761/?format=api", "priority": 100, "id": 1499766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/1499766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.379730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "<item type=\"input\">=VICOJ(A10:B12</item> liveras je 3." ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24942762/?format=api", "priority": 100, "id": 1499767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/1499767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.390867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=VICOJ(Kuniklo)</item>} liveras je 3 se \"Kuniklo\" estas la nomita ĉelaro (C1:D3)." ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942763/?format=api", "priority": 100, "id": 1499768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/1499768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.405454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HIPERLIGILO-funkcio</bookmark_value>" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942764/?format=api", "priority": 100, "id": 1499769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/1499769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.423025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "HIPERLIGILO" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942765/?format=api", "priority": 100, "id": 1499770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/1499770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.438751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">Kiam oni alklakas ĉelon kiu enhavas la funkcion HIPERLIGILO, la hiperligilo malfermiĝas.</ahelp>" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942766/?format=api", "priority": 100, "id": 1499771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/1499771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.453791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "Por malfermi hiperligitan ĉelon per la klavaro, elektu la ĉelon, premu je F2 por komencigi la redaktan reĝimon, movu la kursoron al antaŭ la hiperligilo, premu je SHIFT+F10, kaj tiam elektu je <emph>Malfermi Hiperligilon</emph>." ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942768/?format=api", "priority": 100, "id": 1499773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/1499773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.480038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "" ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942771/?format=api", "priority": 100, "id": 1499776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/1499776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.538613Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FINDAT-funkcio</bookmark_value>" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942778/?format=api", "priority": 100, "id": 1499784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/1499784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.659546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "PIVOTDATUM" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942779/?format=api", "priority": 100, "id": 1499785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/1499785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.676571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942780/?format=api", "priority": 100, "id": 1499786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/1499786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.693688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24942781/?format=api", "priority": 100, "id": 1499787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/1499787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.706780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24942783/?format=api", "priority": 100, "id": 1499789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/1499789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.733744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "" ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942784/?format=api", "priority": 100, "id": 1499790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/1499790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.748873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." ], "previous_source": "", "target": [ "" ], "id_hash": -7239259067986216298, "content_hash": -7239259067986216298, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9302346\nhelp.text", "note": "xTLTZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942785/?format=api", "priority": 100, "id": 1499791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/1499791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.766516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used." ], "previous_source": "", "target": [ "" ], "id_hash": 4132487332375574583, "content_hash": 4132487332375574583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8296151\nhelp.text", "note": "yNzcp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942786/?format=api", "priority": 100, "id": 1499792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/1499792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.781176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field." ], "previous_source": "", "target": [ "" ], "id_hash": -1497535495358537996, "content_hash": -1497535495358537996, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4809411\nhelp.text", "note": "bmrBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24942787/?format=api", "priority": 100, "id": 1499793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/1499793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.797219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": 2388784086717151413, "content_hash": 2388784086717151413, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6454969\nhelp.text", "note": "swvQC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/24942788/?format=api", "priority": 100, "id": 1499794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a126aa7875e1b8b5", "url": "https://translations.documentfoundation.org/api/units/1499794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.812302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -7629710895233941748, "content_hash": -7629710895233941748, "location": "04060109.xhp", "context": "04060109.xhp\npar_id79042\nhelp.text", "note": "vjksc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24942789/?format=api", "priority": 100, "id": 1499795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=161dd25d5ea73f0c", "url": "https://translations.documentfoundation.org/api/units/1499795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.831142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." ], "previous_source": "", "target": [ "" ], "id_hash": -1979321936287154257, "content_hash": -1979321936287154257, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3864253\nhelp.text", "note": "nARMD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942791/?format=api", "priority": 100, "id": 1499797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6488092f93773faf", "url": "https://translations.documentfoundation.org/api/units/1499797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.849857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>pivot table</emph> has the same meaning as in the first syntax." ], "previous_source": "", "target": [ "<emph>Investo</emph> estas la valoro de la investo." ], "id_hash": -4232016537115714080, "content_hash": -4232016537115714080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9937131\nhelp.text", "note": "KETgR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942792/?format=api", "priority": 100, "id": 1499798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=4544db61b5a39de0", "url": "https://translations.documentfoundation.org/api/units/1499798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.865798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell." ], "previous_source": "", "target": [ "" ], "id_hash": 5115834849937829754, "content_hash": 5115834849937829754, "location": "04060109.xhp", "context": "04060109.xhp\npar_id5616626\nhelp.text", "note": "GUofE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942793/?format=api", "priority": 100, "id": 1499799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c6ff18b0f01baf7a", "url": "https://translations.documentfoundation.org/api/units/1499799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.881188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present." ], "previous_source": "", "target": [ "" ], "id_hash": 3603286722984903350, "content_hash": 3603286722984903350, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4076357\nhelp.text", "note": "xS3qo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24942794/?format=api", "priority": 100, "id": 1499800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=b201722efb6582b6", "url": "https://translations.documentfoundation.org/api/units/1499800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.901121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Each of the other entries specifies a constraint in the form <item type=\"literal\">Field[Item]</item> (with literal characters [ and ]), or only <item type=\"literal\">Item</item> if the item name is unique within all fields that are used in the pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": -4546692663667297643, "content_hash": -4546692663667297643, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8231757\nhelp.text", "note": "TFWzU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942795/?format=api", "priority": 100, "id": 1499801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=40e6e71c9f3c7295", "url": "https://translations.documentfoundation.org/api/units/1499801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.913535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "A function name can be added in the form <emph>Field[Item;Function]</emph>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, Count (Numbers only), StDev (Sample), StDevP (Population), Var (Sample), and VarP (Population), case-insensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -4629497150021799111, "content_hash": -4629497150021799111, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3168736\nhelp.text", "note": "Haoyc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942796/?format=api", "priority": 100, "id": 1499802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3fc0b8dec4447339", "url": "https://translations.documentfoundation.org/api/units/1499802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.923672Z" } ] }