[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [office-comment] [OpenFormula] Return type of EDATE and EOMONTH functions - PS
I should point out that how a cell is presented at the UI of a spreadsheet processor, whether Excel or LibreOffice Calc, does not mean thatâs how the cell content is carried or calculated. It is very easy to demonstrate with the mentioned applications that serial datetime numbers are used, where time within a day is the fraction part of the number. From: dennis.hamilton@acm.org <dennis.hamilton@acm.org> It seems to me the specification is very clear that serial day numbers are produced. There may be an Excel compatibility consideration about that. Itâs more suspicious that DATEVALUE returns a date when the description is that a serial number is returned. In fact, that is true about the semantics of DATE as well. Also, DateParam is either a serial date-time or it is *text* which may be interpreted as a Gregorian Calendar date. It is the serial date-time provided directly or indirectly that is used by the related function. Of course you can document your deviation from OpenFormula in HyperFormula, as some propose on the Hyperformula issue #1083. DateParam is considered a âpseudo typeâ and I see no date type in the OpenFormula specification. The office:date-value attribute in the XML for a table cell does have the data type âdateOrDateTime.â Thatâs from XML Schema Part 2: Data Types second edition (although I think it is actually from the ODF schema). So, office:date-value=â2023-03-02T22:28Zâ expresses the datetime that I typed this. And thatâs for interchange representation in an ODF document file. It may or may not have much to do with the internal representations in a spreadsheet processor. Thanks for the great question, and a thoughtful HyperFormula issue.
From: Jakub SÄkowski <jakub.sekowski@handsontable.com> Hi, I'm a developer working on HyperFormula - a _javascript_ formula calculation engine: https://hyperformula.handsontable.com/ We try to follow the OpenFormula 1.3 specification: https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html I have a question about functions EDATE and EOMONTH. The specification states that their return type should be Number, but for me, it seems more logical to return Date from these 2 functions. The numbers returned by EDATE and EOMONTH are not "just numbers" they represent dates in the same way as in functions TODAY, DATE, etc. Link to the discussion on that topic in our project repository: https://github.com/handsontable/hyperformula/issues/1083 â Jakub SÄkowski Developer | Handsoncode E-mail: jakub.sekowski@handsontable.com Timezone: GMT+1 - Bielsko-BiaÅa, PL |
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]