I ran the POI tests on the 2.0-final version, and attached are the
results. Most tests pass, and given the massive change in paradigm, i
think this looks good. Will look at the one's that don't. To give you a
flavour of why tests fail, the testFloat in TestFormulas fail with
"1.5*5.1!=1.5*5.099999999999999".
2.5 however is another matter, coz all the drawing stuff makes heavy use
of awt and J2D stuff, whose implementation in IKVM/Classpath is pretty
weak.. not much should be expected in those areas in the near future.
At some point, I will write all this up on the web, and if necessary ask
the IKVM folks for help.
[junit] Running org.apache.poi.hpsf.basic.TestBasic
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 3.652
sec
[junit] Running org.apache.poi.hpsf.basic.TestClassID
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.35 sec
[junit] TEST org.apache.poi.hpsf.basic.TestClassID FAILED
[junit] Running org.apache.poi.hpsf.basic.TestEmptyProperties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.404
sec
[junit] Running org.apache.poi.hpsf.basic.TestUnicode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.43 sec
[junit] Running
org.apache.poi.hssf.eventmodel.TestEventRecordFactory
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 2.535
sec
[junit] Running org.apache.poi.hssf.eventmodel.TestModelFactory
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.279
sec
[junit] Running org.apache.poi.hssf.model.TestFormulaParser
[junit] Tests run: 22, Failures: 0, Errors: 0, Time elapsed: 4.917
sec
[junit] Running org.apache.poi.hssf.record.TestAreaFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.161
sec
[junit] Running org.apache.poi.hssf.record.TestAxisLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestAxisOptionsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.194
sec
[junit] Running org.apache.poi.hssf.record.TestAxisParentRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.47 sec
[junit] Running org.apache.poi.hssf.record.TestAxisUsedRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.hssf.record.TestBarRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
[junit] Running org.apache.poi.hssf.record.TestBoundSheetRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.136
sec
[junit] Running
org.apache.poi.hssf.record.TestCategorySeriesAxisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.18 sec
[junit] Running org.apache.poi.hssf.record.TestChartRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.157
sec
[junit] Running org.apache.poi.hssf.record.TestDatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.171
sec
[junit] Running org.apache.poi.hssf.record.TestDataFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.177
sec
[junit] Running
org.apache.poi.hssf.record.TestDefaultDataLabelTextPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.149
sec
[junit] Running org.apache.poi.hssf.record.TestFontBasisRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestFontIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.15 sec
[junit] Running org.apache.poi.hssf.record.TestFormulaRecord
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 1.584
sec
[junit] Running org.apache.poi.hssf.record.TestFrameRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.205
sec
[junit] Running org.apache.poi.hssf.record.TestLegendRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.197
sec
[junit] Running org.apache.poi.hssf.record.TestLineFormatRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.186
sec
[junit] Running org.apache.poi.hssf.record.TestLinkedDataRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.45 sec
[junit] Running org.apache.poi.hssf.record.TestMergeCellsRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.132
sec
[junit] Running org.apache.poi.hssf.record.TestNameRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.483
sec
[junit] Running
org.apache.poi.hssf.record.TestNumberFormatIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.151
sec
[junit] Running org.apache.poi.hssf.record.TestObjectLinkRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.record.TestPaletteRecord
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.624
sec
[junit] Running org.apache.poi.hssf.record.TestPaneRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.165
sec
[junit] Running org.apache.poi.hssf.record.TestPlotAreaRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.141
sec
[junit] Running org.apache.poi.hssf.record.TestPlotGrowthRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestRecordFactory
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 2.955
sec
[junit] Running org.apache.poi.hssf.record.TestSCLRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSSTDeserializer
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.967
sec
[junit] Running org.apache.poi.hssf.record.TestSSTRecord
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 72.132
sec
[junit] Running
org.apache.poi.hssf.record.TestSSTRecordSizeCalculator
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.757
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesChartGroupIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesIndexRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.134
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesLabelsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.162
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesListRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.123
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.158
sec
[junit] Running org.apache.poi.hssf.record.TestSeriesTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.247
sec
[junit] Running
org.apache.poi.hssf.record.TestSeriesToChartGroupRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.hssf.record.TestSheetPropertiesRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 1.075
sec
[junit] Running org.apache.poi.hssf.record.TestStringRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.189
sec
[junit] Running org.apache.poi.hssf.record.TestSupBookRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.139
sec
[junit] Running org.apache.poi.hssf.record.TestTextRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.233
sec
[junit] Running org.apache.poi.hssf.record.TestTickRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running org.apache.poi.hssf.record.TestUnitsRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.154
sec
[junit] Running org.apache.poi.hssf.record.TestValueRangeRecord
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.201
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestFormulaRecordAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.497
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestRowRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.144
sec
[junit] Running
org.apache.poi.hssf.record.aggregates.TestValueRecordsAggregate
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.257
sec
[junit] Running org.apache.poi.hssf.record.formula.TestFuncPtg
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.961
sec
[junit] Running org.apache.poi.hssf.usermodel.TestBugs
[junit] Tests run: 21, Failures: 0, Errors: 0, Time elapsed: 257.003
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCellStyle
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 8.102
sec
[junit] Running org.apache.poi.hssf.usermodel.TestCloneSheet
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 2.584
sec
[junit] Running org.apache.poi.hssf.usermodel.TestFormulas
[junit] Tests run: 26, Failures: 1, Errors: 0, Time elapsed: 64.657
sec
[junit] TEST org.apache.poi.hssf.usermodel.TestFormulas FAILED
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFCell
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 7.145
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFDateUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.405
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFHeaderFooter
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 5.508
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFPalette
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.76 sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFRow
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 7.075
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheet
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 6.259
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.545
sec
[junit] Running org.apache.poi.hssf.usermodel.TestHSSFSheetSetOrder
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 3.491
sec
[junit] Running org.apache.poi.hssf.usermodel.TestMisc
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.08 sec
[junit] Running org.apache.poi.hssf.usermodel.TestNamedRange
[junit] Tests run: 12, Failures: 0, Errors: 0, Time elapsed: 7.856
sec
[junit] Running org.apache.poi.hssf.usermodel.TestReadWriteChart
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 5.255
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSanityChecker
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 1.573
sec
[junit] Running org.apache.poi.hssf.usermodel.TestSheetShiftRows
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.612
sec
[junit] Running org.apache.poi.hssf.usermodel.TestTemp
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.089
sec
[junit] Running org.apache.poi.hssf.usermodel.TestWorkbook
[junit] Tests run: 16, Failures: 0, Errors: 0, Time elapsed: 39.247
sec
[junit] Running org.apache.poi.hssf.util.TestAreaReference
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.143
sec
[junit] Running org.apache.poi.hssf.util.TestCellReference
[junit] Tests run: 8, Failures: 0, Errors: 0, Time elapsed: 0.133
sec
[junit] Running org.apache.poi.hssf.util.TestRKUtil
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.085
sec
[junit] Running org.apache.poi.hssf.util.TestRangeAddress
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.155
sec
[junit] Running org.apache.poi.hssf.util.TestSheetReferences
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.093
sec
[junit] Running
org.apache.poi.poifs.eventfilesystem.TestPOIFSReaderRegistry
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.245
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDirectoryNode
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 1.052
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocument
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 60.833
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentDescriptor
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.191
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentInputStream
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 103.291
sec
[junit] Running org.apache.poi.poifs.filesystem.TestDocumentNode
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.568
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestDocumentOutputStream
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.092
sec
[junit] Running
org.apache.poi.poifs.filesystem.TestPOIFSDocumentPath
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.109
sec
[junit] Running org.apache.poi.poifs.property.TestDirectoryProperty
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 2.378
sec
[junit] Running org.apache.poi.poifs.property.TestDocumentProperty
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.29 sec
[junit] Running org.apache.poi.poifs.property.TestPropertyFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.735
sec
[junit] Running org.apache.poi.poifs.property.TestPropertyTable
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.996
sec
[junit] Running org.apache.poi.poifs.property.TestRootProperty
[junit] Tests run: 3, Failures: 1, Errors: 0, Time elapsed: 0.383
sec
[junit] TEST org.apache.poi.poifs.property.TestRootProperty FAILED
[junit] Running org.apache.poi.poifs.storage.TestBATBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableReader
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.968
sec
[junit] Running
org.apache.poi.poifs.storage.TestBlockAllocationTableWriter
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.284
sec
[junit] Running org.apache.poi.poifs.storage.TestBlockListImpl
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.388
sec
[junit] Running org.apache.poi.poifs.storage.TestDocumentBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 7.084
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.204
sec
[junit] Running org.apache.poi.poifs.storage.TestHeaderBlockWriter
[junit] Tests run: 4, Failures: 0, Errors: 0, Time elapsed: 0.317
sec
[junit] Running org.apache.poi.poifs.storage.TestPropertyBlock
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.298
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlock
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.175
sec
[junit] Running org.apache.poi.poifs.storage.TestRawDataBlockList
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.306
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableReader
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.795
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallBlockTableWriter
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.638
sec
[junit] Running org.apache.poi.poifs.storage.TestSmallDocumentBlock
[junit] Tests run: 6, Failures: 0, Errors: 0, Time elapsed: 9.562
sec
[junit] Running
org.apache.poi.poifs.storage.TestSmallDocumentBlockList
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.099
sec
[junit] Running org.apache.poi.util.TestBinaryTree
[junit] Tests run: 20, Failures: 7, Errors: 6, Time elapsed: 3.555
sec
[junit] TEST org.apache.poi.util.TestBinaryTree FAILED
[junit] Running org.apache.poi.util.TestBitField
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.074
sec
[junit] Running org.apache.poi.util.TestByteField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.118
sec
[junit] Running org.apache.poi.util.TestHexDump
[junit] Tests run: 2, Failures: 1, Errors: 0, Time elapsed: 0.199
sec
[junit] TEST org.apache.poi.util.TestHexDump FAILED
[junit] Running org.apache.poi.util.TestIntList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.169
sec
[junit] TEST org.apache.poi.util.TestIntList FAILED
[junit] Running org.apache.poi.util.TestIntegerField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.128
sec
[junit] Running org.apache.poi.util.TestLittleEndian
[junit] Tests run: 15, Failures: 0, Errors: 0, Time elapsed: 0.11
sec
[junit] Running org.apache.poi.util.TestLongField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 1.827
sec
[junit] Running org.apache.poi.util.TestPOILogFactory
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.146
sec
[junit] Running org.apache.poi.util.TestPOILogger
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.153
sec
[junit] Running org.apache.poi.util.TestShortField
[junit] Tests run: 5, Failures: 0, Errors: 0, Time elapsed: 0.119
sec
[junit] Running org.apache.poi.util.TestShortList
[junit] Tests run: 18, Failures: 1, Errors: 0, Time elapsed: 0.195
sec
[junit] TEST org.apache.poi.util.TestShortList FAILED
[junit] Running org.apache.poi.util.TestStringUtil
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 0.173
sec
On Thu, 2004-07-08 at 19:19, Avik Sengupta wrote:
> Have you yearned to use the wonders of POI in you .NET applications?
> Well, then yearn no more. POI compiled into a .NET dll is available at
>
> http://www.apache.org/~avik/dist/poi-2.5.1-dev-20040708.dll
>
> The following C# code uses poi to create a new excel file.. it compiles
> and runs successfully .. tested in mono, should be fine in windows as
> well. Of course, no warranties, it may eat your homework :)
>
> Done with IKVM. You need to download the IKVM runtime to run this.
>
> Thoughts?
>
> ------------------------------------------------------------------
> //Main.cs -- reference POI dll and IKVM.GNU.Classpath.dll
> using System;
> using org.apache.poi.hssf.usermodel;
> using ikvm.lang;
>
> class MainClass
> {
> public static void Main(string[] args)
> {
> Console.WriteLine("Hello World!");
> HSSFWorkbook wb = new HSSFWorkbook();
> HSSFSheet s= wb.createSheet("Sheet1");
> HSSFRow r= s.createRow(0);
> HSSFCell c = r.createCell(1);
> c.setCellValue(1);
> java.io.FileOutputStream fs = new
> java.io.FileOutputStream("dotnet.xls");
> wb.write(fs);
> fs.close();
> }
> }
> -------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
|