poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 44050] New: - [PATCH] Trim function in formula cell
Date Tue, 11 Dec 2007 02:14:24 GMT
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: dev@poi.apache.org
        ReportedBy: wilson@cbio.mskcc.org


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message