On Wed, 9 Nov 2011, Rene Becker wrote:
The problem is that the date arithmetic is performed on textual content. Performing date arithmetic on numeric cells works, however in the given testcase the date arithmetic is performed on a date that is retrieved from a substring(i.e. right()) of a textual cell. Unfortunately DATEVALUE() is also not available for converting the text cell to a date cell.
I'm not sure I follow you. Any chance you could create a very simple spreadsheet with a very simple problem formula in it, then write a unit test that shows the evaluation issue? If so, please upload it as a new issue in bugzilla, then people can hopefully easily see what's going wrong
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
