DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUGĀ· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=44364>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED ANDĀ· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=44364 Summary: [patch] Added Excel functions MATCH, NA, SUMPRODUCT and other fixes Product: POI Version: 3.0-dev Platform: Other OS/Version: other Status: NEW Severity: normal Priority: P2 Component: HSSF AssignedTo: dev@poi.apache.org ReportedBy: [EMAIL PROTECTED] Added Implementations for Excel functions MATCH(), NA(), SUMPRODUCT(). Added junits. Rewrote 3 classes(GenericFormulaTestCase, TestEverything, TestEverything) into TestFormulasFromSpreadsheet. This served a few purposes: - to allow for more conventional structuring of the test suites - to formalise and simplify the interface between the test spreadsheet and the test code. - to identify and fix a few bugs (related to comparing expected vs actual evaluation results) Those 3 classes should be deleted. The most correct appropriate predecessor of TestFormulasFromSpreadsheet is GenericFormulaTestCase. Added cases for COUNTA, COUNTIF, MATCH, NA, and SUMPRODUCT to the spreadsheet As a result of fixing the spreadsheet and related test, a few other bugs became visible. Fixed Excel error code propagation throughout HSSFFormulaEvaluator. Fixed error code handling in ROUNDDOWN(), ROUNDUP() and T(). Added junits. Note - TestFormulasFromSpreadsheet has a disabled assert which confirms expected error codes. This can be enabled after another 45 functions like ROUNDDOWN and ROUNDUP are fixed wrt. error handling. Fixed bug (involving column area refs) in UnaryPlusEval. Added junit. Fixed FormulaParser.toFormulaString() for the case of a single no-arg function e.g. "=NOW()". Added junit. -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]