Florian, This POI-ODF bridge is a very good idea and a very good collaboration between our projects.
What level of conformance are you aiming at ? Are you going to support all POI Spreadsheet interfaces or only a subset ? This work will consist of several iterations, off the top of my head I can name three: level 1: create / read simple spreadsheets with basic formatting. Create sheets, rows, cells. Merge cells. . Iterate over the data. Set cell values as strings, numbers, booleans, etc. This is functionality of first releases of POI. level 2: advanced features, some of them may be Excel-specific: header/footers, data validation, conditional formatting, cell comments, etc. . level 3: formulas and formula evaluation. POI's spreadsheet framework can evaluate formulas and it is a VERY strong feature. Having it in ODF would be a killer. (1) is fairly simple . (2) and (3) may require efforts and research. In POI we have a good set base unit tests which are called by HSSF and XSSF implementations. Have a look at the classes in https://svn.apache.org/repos/asf/poi/trunk/src/testcases/org/apache/poi/ss/usermodel/ Ideally, your code will re-use theese tests and pass all of them, at least for the phase (1). Regards, Yegor On Sat, Feb 23, 2013 at 3:28 PM, Florian Hopf <mailingli...@florian-hopf.de> wrote: > Hi, > > I just wanted to let you know that I started work on a POI workbook adapter > for the ODFToolkit. The goal is to make the POI Workbook functionality > available for ODS documents so users can use the familiar POI API to read > and modify Open Document spreadsheets. The code still is in an early stage > but so far it looks quite promising. It's an interesting task because it is > a rather rare opportunity to have an existing implementation that I can use > to see how the API should behave. I already noticed that the ODFToolkit > needs some further enhancements and fixes to implement all the functionality > but I am waiting for the current release to be completed. > > I think providing the existing POI API for Open Document formats will be a > huge benefit for many users as for simple use cases I expect this to be > nearly a drop in replacement. > > Regards > Florian > > -- > Florian Hopf > Freelance Software Developer > > http://blog.florian-hopf.de > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org > For additional commands, e-mail: dev-h...@poi.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
