Re: Today's work on the ooxml branch

[Paolo Mottadelli <p....@sourcesense.com>]

Hi all,
I hope I did'n miss anything about this before;

>  We're now able to open an existing ooxml excel file in poi, tweak it, save
>  it, and have it open in excel! Admitedly, excel does feel the need to
>  repair the file, and it declares any new files we create to be
>  un-repairable, but it's a start... :)

for the first time today I could create a new .xlsx file through the
POI library and open it in Excel 2007 without making the application
declaring that the file is 'un-repairable'.
Checked in TestXSSFWorkbook.testSaveNew()

We were missing some styles.xml stuff, that is required in order to
make the file properly readable by Excel 2007;  in particular, we have
to provide:
_ at least one font
_ at least one fill
_ at least one border
_ at least one cellStyle Xf
_ at least one cell Xf

Attached the default styles.xml part created for a new POI .xlsx file

Paolo





-- 
Paolo Mottadelli
Sourcesense - making sense of Open Source: http://www.sourcesense.com

Re: Today's work on the ooxml branch

[Nick Burch <ni...@torchbox.com>]

On Sun, 6 Apr 2008, Paolo Mottadelli wrote:
> for the first time today I could create a new .xlsx file through the POI
> library and open it in Excel 2007 without making the application
> declaring that the file is 'un-repairable'. Checked in
> TestXSSFWorkbook.testSaveNew()

Excellent news :)

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org