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=44050>. 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=44050 Summary: [PATCH] Trim function in formula cell Product: POI Version: unspecified Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: HSSF AssignedTo: [email protected] ReportedBy: [EMAIL PROTECTED] I have implemented the TRIM function for formula cells. In Excel TRIM is defined as "Removes all spaces from text except for single spaces between words.". I have also filled in the TRIM "FORMULA" and "EXPECTED VALUE" rows of the file src/scratchpad/testcases/org/apache/poi/hssf/data/FormulaEvalTestData.xls with 15 test cases. These test cases include passing TRIM a reference to a cell with an empty string, passing TRIM numbers, passing TRIM an area, and others. All tests pass. I would like to implement more formula functions, so any feedback on this one would be greatly appreciated. I plan to try MID next. -- 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]
