Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15323
{ "count": 766762, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15324", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15322", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99101419/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253840Z", "action": 59, "target": "<variable id=\"h1\">Date & Time Functions</variable>", "id": 36726392, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726392/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101418/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253794Z", "action": 59, "target": "<bookmark_value>date and time functions</bookmark_value> <bookmark_value>functions; date & time</bookmark_value> <bookmark_value>Function Wizard; date & time</bookmark_value>", "id": 36726391, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726391/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101417/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253748Z", "action": 59, "target": "Date & Time Functions", "id": 36726390, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726390/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101397/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253699Z", "action": 59, "target": "Insert the formula <input>=DVARP(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the population variance of the distances in meters that Joe’s party guests travel to school. The value 171666.67 is returned.", "id": 36726389, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726389/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101357/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253650Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726388, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726388/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101309/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253604Z", "action": 59, "target": "DVARP(Database; DatabaseField; SearchCriteria)", "id": 36726387, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726387/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101263/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253558Z", "action": 59, "target": "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726386, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726386/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101262/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253510Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored.", "id": 36726385, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726385/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101228/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253462Z", "action": 59, "target": "DVARP", "id": 36726384, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726384/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101207/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253414Z", "action": 59, "target": "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>", "id": 36726383, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726383/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101162/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253366Z", "action": 59, "target": "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned.", "id": 36726382, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726382/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101123/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253317Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726381, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726381/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101084/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253268Z", "action": 59, "target": "DVAR(Database; DatabaseField; SearchCriteria)", "id": 36726380, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726380/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99101030/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253224Z", "action": 59, "target": "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726379, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726379/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100981/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253180Z", "action": 59, "target": "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records.", "id": 36726378, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726378/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100938/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253135Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored.", "id": 36726377, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100778/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253091Z", "action": 59, "target": "DVAR", "id": 36726376, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726376/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100771/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.253044Z", "action": 59, "target": "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>", "id": 36726375, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726375/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100770/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252999Z", "action": 59, "target": "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned.", "id": 36726374, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100769/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252955Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726373, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726373/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100768/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252911Z", "action": 59, "target": "DSUM(Database; DatabaseField; SearchCriteria)", "id": 36726372, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100767/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252869Z", "action": 59, "target": "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726371, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100761/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252827Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included.", "id": 36726370, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726370/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100730/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252785Z", "action": 59, "target": "DSUM", "id": 36726369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100693/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252739Z", "action": 59, "target": "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>", "id": 36726368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100587/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252694Z", "action": 59, "target": "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned.", "id": 36726367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100569/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252650Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100475/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252609Z", "action": 59, "target": "DSTDEVP(Database; DatabaseField; SearchCriteria)", "id": 36726365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100449/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252565Z", "action": 59, "target": "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100375/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252520Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored.", "id": 36726363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100310/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252478Z", "action": 59, "target": "DSTDEVP", "id": 36726362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100273/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252434Z", "action": 59, "target": "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>", "id": 36726361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100243/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252391Z", "action": 59, "target": "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned.", "id": 36726360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100203/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252347Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100173/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252300Z", "action": 59, "target": "DSTDEV(Database; DatabaseField; SearchCriteria)", "id": 36726358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100120/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252247Z", "action": 59, "target": "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100082/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252202Z", "action": 59, "target": "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records.", "id": 36726356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100058/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252159Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the sample standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored.", "id": 36726355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100031/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252116Z", "action": 59, "target": "DSTDEV", "id": 36726354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99100000/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252072Z", "action": 59, "target": "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>", "id": 36726353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099960/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.252031Z", "action": 59, "target": "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned.", "id": 36726352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099937/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251987Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099923/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251943Z", "action": 59, "target": "DPRODUCT(Database; DatabaseField; SearchCriteria)", "id": 36726350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099899/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251900Z", "action": 59, "target": "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records.", "id": 36726349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099882/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251855Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT calculates the product of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included.", "id": 36726348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099854/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251814Z", "action": 59, "target": "DPRODUCT", "id": 36726347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099823/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251770Z", "action": 59, "target": "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>", "id": 36726346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099814/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251727Z", "action": 59, "target": "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned.", "id": 36726345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099776/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251681Z", "action": 59, "target": "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table).", "id": 36726344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99099758/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.251639Z", "action": 59, "target": "DAVERAGE(Database; DatabaseField; SearchCriteria)", "id": 36726343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726343/?format=api" } ] }