Bug 44095

Summary:	[PATCH] Mid function in formula cell
Product:	POI	Reporter:	Manda Wilson <wilson>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
Severity:	enhancement
Priority:	P5
Version:	unspecified
Target Milestone:	---
Hardware:	All
OS:	All
Attachments:	Generated using svn diff > FormulaMidFunction.patch Contains the files I modified to implement and test the MID function.

Description Manda Wilson 2007-12-18 17:04:20 UTC

I have implemented the MID function for formula cells.  

I have also filled in the MID "FORMULA" and "EXPECTED VALUE" rows of the file
src/scratchpad/testcases/org/apache/poi/hssf/data/FormulaEvalTestData.xls with
17 test cases.  All tests run and pass.

Comment 1 Manda Wilson 2007-12-18 17:05:45 UTC

Created attachment 21281 [details]
Generated using svn diff > FormulaMidFunction.patch

This is a patch file, generated by running:

svn diff > FormulaMidFunction.patch

After I finished implementing the MID function.

Comment 2 Manda Wilson 2007-12-18 17:07:50 UTC

Created attachment 21282 [details]
Contains the files I modified to implement and test the MID function.

This tar file contains two files that I modified to implement and test the MID
formula function.  

The first file is:

src/scratchpad/src/org/apache/poi/hssf/record/formula/functions/Mid.java

This is where the MID function is implemented.

The second file is:

src/scratchpad/testcases/org/apache/poi/hssf/data/FormulaEvalTestData.xls

I modified two rows in this file (rows 884 and 885), the "FORMULA" and
"EXPECTED VALUE" rows for the mid function.  This row contains the test cases
for mid.  These tests run successfully and are run automatically when the ant
task "test" is executed.

Comment 3 Nick Burch 2007-12-21 04:24:52 UTC

Thanks, applied