search

handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.
https://hyperformula.handsontable.com/
Other
2.01k stars 111 forks source link

no description about 'Units' from "DATEDIF(Date1, Date2, Units)" #1462

Open cuihee opened 1 week ago

cuihee commented 1 week ago

Page URL

https://hyperformula.handsontable.com/guide/built-in-functions.html#list-of-available-functions

Improvement description

DATEDIF | Calculates distance between two dates, in provided unit parameter. | DATEDIF(Date1, Date2, Units) -- | -- | --

check resource code: es/interpreter/plugin/DateTimePlugin.js line 261 "switch (unit) { case 'M':"

AMBudnik commented 1 week ago

Thank you for sharing the issue report, @cuihee

You are right. To provide a comprehensive guide, we'd need to either direct users to another resource or list them ourselves. Now we only show possible units within the tests scenarios like https://github.com/handsontable/hyperformula/blob/76aaae5b5f5c02de1d1a365b7407d99789467650/test/interpreter/function-datedif.spec.ts#L10