Originally sent this to the poi-user list, but now I think might be more appropriate for the dev list...
I am trying to implement the NOW() and TODAY() functions in the formula processing, but running into a problem where FormulaParser doesn't know how to parse these functions correctly. For example, when the function NOW() is in a cell, getCellFormula() returns the string, NOW(ATTR(semiVolatile)). When this is parsed by FormulaParser, it identifies semiVolatile as a cell reference and tries to reference it. This then causes an out of bounds exception when trying to reference the cell, semiVolatile. Can anyone help shed some light on how ATTR(semiVolatile), or ATTR() in general, are supposed to be used within formulat evaluating to help solve this? Should there be special parsing for either semiVolatile or ATTR in general? Thank you, Jared
