Re: Built-in function code

2015-12-04 Thread Nick Burch
On Fri, 4 Dec 2015, Javen O'Neal wrote: From what I can tell, DAYS wasn't added until Excel 2013 [1]. Clearly this means DAYS is not a recognized function in BIFF8. I developed a solution [2] for saving unregistered functions in bug 58452, but this gets tricky with common SS support regarding p

Re: Built-in function code

2015-12-04 Thread Nick Burch
On Fri, 4 Dec 2015, Javen O'Neal wrote: In FunctionEval.java [1], there's an array that maps the binary function code used in BIFF8 to a function instance. There's also src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt I'm implementing Days [2] for bug 58468 [3], and

Re: Built-in function code

2015-12-04 Thread Javen O'Neal
>From what I can tell, DAYS wasn't added until Excel 2013 [1]. Clearly this means DAYS is not a recognized function in BIFF8. I developed a solution [2] for saving unregistered functions in bug 58452, but this gets tricky with common SS support regarding parsing, storing, and evaluating and to have

Re: Built-in function code

2015-12-04 Thread Javen O'Neal
I got close to finding my answer in section 3.11.1 (starts on Page 74) of https://www.openoffice.org/sc/excelfileformat.pdf, but DAYS isn't included. Helpful resource if others are curious. On Fri, Dec 4, 2015 at 12:40 AM, Javen O'Neal wrote: > In FunctionEval.java [1], there's an array that map

Built-in function code

2015-12-04 Thread Javen O'Neal
In FunctionEval.java [1], there's an array that maps the binary function code used in BIFF8 to a function instance. I'm implementing Days [2] for bug 58468 [3], and I have no idea what the code is. Is there an easy way to figure out the code? Thanks! [1] https://svn.apache.org/viewvc/poi/trunk/