ASF Bugzilla – Attachment 26530 Details for
Bug 50610
Add ant tasks for running POI against a workbook
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
[patch]
updates to the example build
50610-update-21-JAN-2011.patch (text/plain), 6.71 KB, created by
Jon Svede
on 2011-01-21 12:15:13 UTC
(
hide
)
Description:
updates to the example build
Filename:
MIME Type:
Creator:
Jon Svede
Created:
2011-01-21 12:15:13 UTC
Size:
6.71 KB
patch
obsolete
>Index: src/examples/excelant-build.xml >=================================================================== >--- src/examples/excelant-build.xml (revision 0) >+++ src/examples/excelant-build.xml (revision 0) >@@ -0,0 +1,48 @@ >+<?xml version="1.0" encoding="UTF-8" standalone="yes"?> >+<project name="Package FreeRefFunction Example" basedir="." default="all"> >+ >+ >+ >+ <property name="build.dir" value="build"/> >+ <property name="src.dir" value="src"/> >+ <property name="dist.dir" value="src/org/apache/poi/ss/examples/excelant/lib"/> >+ <property name="lib.dir" value="../../build/dist"/> >+ >+ <property name="version" value="0.4.0"/> >+ <tstamp> >+ <format property="build.tstamp" pattern="MMddyyyy" locale="en,US"/> >+ </tstamp> >+ >+ <property name="jar.file.name" value="calculator-function.jar"/> >+ >+ <path id="compile.class.path"> >+ <pathelement location="${lib.dir}/poi-3.8-beta1-20110112.jar"/> >+ <pathelement location="${lib.dir}/poi-examples-3.8-beta1-20110112.jar"/> >+ <pathelement location="${lib.dir}/poi-ooxml-3.8-beta1-20110112.jar"/> >+ <pathelement location="${lib.dir}/poi-ooxml-schemas-3.8-beta1-20110112.jar"/> >+ <pathelement location="${lib.dir}/poi-scratchpad-3.8-beta1-20110112.jar"/> >+ </path> >+ >+ <target name="all" depends="clean, compile, jar"/> >+ >+ <target name="clean"> >+ <delete dir = "${build.dir}"/> >+ <mkdir dir ="${build.dir}"/> >+ <delete file="${dist.dir}/${jar.file.name}"/> >+ <mkdir dir="${dist.dir}"/> >+ </target> >+ >+ <target name="compile"> >+ <javac >+ debug="true" >+ srcdir="${src.dir}" >+ destdir="${build.dir}" >+ includes="org/apache/poi/ss/examples/formula/CalculateMortgage.java" >+ classpathref="compile.class.path"> >+ </javac> >+ </target> >+ >+ <target name="jar"> >+ <jar destfile="${dist.dir}/${jar.file.name}" basedir="${build.dir}"/> >+ </target> >+</project> >\ No newline at end of file >Index: src/examples/src/org/apache/poi/ss/examples/excelant/excelant-example.xml >=================================================================== >--- src/examples/src/org/apache/poi/ss/examples/excelant/excelant-example.xml (revision 0) >+++ src/examples/src/org/apache/poi/ss/examples/excelant/excelant-example.xml (revision 0) >@@ -0,0 +1,49 @@ >+<?xml version="1.0" encoding="UTF-8" standalone="yes"?> >+<project name="Simple ExcelAnt Example" basedir="."> >+ >+ <property name="xls.file" value="excelant.xls" /> >+ >+ <property name="lib.dir" value="../../../../../../../../../build/dist" /> >+ >+ <property name="local.lib.dir" value="lib" /> >+ >+ <path id="excelant.path"> >+ <pathelement location="${local.lib.dir}/excelant-0.4.0-01182011.jar" /> >+ <pathelement location="${lib.dir}/poi-3.8-beta1-20110112.jar" /> >+ <pathelement location="${lib.dir}/poi-ooxml-3.8-beta1-20110112.jar" /> >+ <pathelement location="${lib.dir}/poi-ooxml-schemas-3.8-beta1-20110112.jar" /> >+ <pathelement location="${local.lib.dir}/calculator-function.jar"/> >+ </path> >+ >+ <taskdef name="excelant" classname="org.excelant.ExcelAntTask" classpathref="excelant.path" /> >+ <taskdef name="test" classname="org.excelant.ExcelAntTest" classpathref="excelant.path" /> >+ <taskdef name="setDouble" classname="org.excelant.ExcelAntSetDoubleCell" classpathref="excelant.path" /> >+ <taskdef name="udf" classname="org.excelant.ExcelAntUserDefinedFunction" classpathref="excelant.path" /> >+ <taskdef name="precision" classname="org.excelant.ExcelAntPrecision" classpathref="excelant.path" /> >+ >+ <target name="simpleTest"> >+ <excelant fileName="${xls.file}"> >+ <precision value="1.0e-3"/> >+ <test name="checkValue" showFailureDetail="true"> >+ <setDouble cell="'MortgageCalculator'!$B$1" value="240000"/> >+ <setDouble cell="'MortgageCalculator'!$B$2" value ="0.11"/> >+ <setDouble cell="'MortgageCalculator'!$B$3" value ="30"/> >+ <evaluate showDelta="true" cell="'MortgageCalculator'!$B$4" expectedValue="2285.576149" precision="1.0e-4" /> >+ </test> >+ </excelant> >+ </target> >+ >+ <target name="functionTest"> >+ <excelant fileName="${xls.file}"> >+ <udf functionAlias="calculatePayment" className="org.apache.poi.ss.examples.formula.CalculateMortgage"/> >+ <precision value="1.0e-3"/> >+ <test name="checkValue" showFailureDetail="true"> >+ <setDouble cell="'MortageCalculatorFunction'!$B$1" value="240000"/> >+ <setDouble cell="'MortageCalculatorFunction'!$B$2" value ="0.11"/> >+ <setDouble cell="'MortageCalculatorFunction'!$B$3" value ="30"/> >+ <evaluate showDelta="true" cell="'MortageCalculatorFunction'!$B$4" expectedValue="2285.576149" precision="1.0e-4" /> >+ </test> >+ </excelant> >+ </target> >+ >+</project> >\ No newline at end of file >Index: src/examples/src/org/apache/poi/ss/examples/excelant/excelant.xls >=================================================================== >Cannot display: file marked as a binary type. >svn:mime-type = application/octet-stream > >Property changes on: src\examples\src\org\apache\poi\ss\examples\excelant\excelant.xls >___________________________________________________________________ >Added: svn:mime-type > + application/octet-stream > >Index: src/examples/src/org/apache/poi/ss/examples/excelant/mortgage-calculation.xls >=================================================================== >Cannot display: file marked as a binary type. >svn:mime-type = application/octet-stream > >Property changes on: src\examples\src\org\apache\poi\ss\examples\excelant\mortgage-calculation.xls >___________________________________________________________________ >Added: svn:mime-type > + application/octet-stream > >Index: src/examples/src/org/apache/poi/ss/examples/excelant/lib/calculator-function.jar >=================================================================== >Cannot display: file marked as a binary type. >svn:mime-type = application/octet-stream > >Property changes on: src\examples\src\org\apache\poi\ss\examples\excelant\lib\calculator-function.jar >___________________________________________________________________ >Added: svn:mime-type > + application/octet-stream > >Index: src/examples/src/org/apache/poi/ss/examples/excelant/lib/excelant-0.4.0-01182011.jar >=================================================================== >Cannot display: file marked as a binary type. >svn:mime-type = application/octet-stream > >Property changes on: src\examples\src\org\apache\poi\ss\examples\excelant\lib\excelant-0.4.0-01182011.jar >___________________________________________________________________ >Added: svn:mime-type > + application/octet-stream >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 50610
:
26510
|
26511
|
26523
| 26530 |
26531
|
26616
|
26617