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 parsing, storing, and
evaluating and to have consistent behavior where it makes sense between
HSSF and XSSF workbooks.
Do you have a copy of Excel 2013 handy? If so, can you try creating a
simple .xlsx file with the DAYS function in it, then do a save-as to save
it as .xls, close Excel, re-open, and see if the function is still there?
If so, would be interesting to use BiffViewer to see how it was stored
(There are quite a few bits lately where Excel 2010 or 2013 can save and
re-load things into a .xls file which Excel 2007 doesn't support and
ignores, eg some of the Conditional Formatting things)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
