Re: Issues with Open XML in Office 2008 for Mac SP2

[Yegor Kozlov <ye...@dinom.ru>]

The Application setting "Apache POI" makes sense for all OOXML packages produced by Apache POI.
I changed XSSF and XWPF to set it to "Apache POI" instead of "Microsoft Excel" and "Microsoft Office Word".

The AppVersion property can is not that important and can be omitted.

Excel 2007 and OpenOffice 3.1 have no problems opening such files.
Leif, would you please do the final check in Mac Excel 2008? The fix was committed in r802539.

Regards,
Yegor

> On 7/30/09 12:19 PM, "David Fisher" <df...@jmlafferty.com> wrote:
>> As a project we should decide if -
>>
>> (a) It is safe to make the Application setting "Apache POI". A test
>> would be to successfully open an XSSF file with consumers other than
>> Excel 12.2.0. This includes OpenOffice 3.0.
>>
>> (b) If it is safe then I propose that we set the Application to
>> "Apache POI" and the AppVersion to the poi version - eg. "3.5-
>> beta7-20090731"
>>
>> This is worth a discussion. Please respond if you have an opinion.
>>
> 
> I did some experimenting with the newly release Excel 2008 12.2.1.  Here's
> what I've found related to (b) above:
> 
> The following works on both Mac (12.2.1) /Windows Excel (12.0.6425.1000):
> 
> XSSFWorkbook wb = new XSSFWorkbook();
> POIXMLProperties.ExtendedProperties ext =
> wb.getProperties().getExtendedProperties();
> ext.getUnderlyingProperties().setApplication("Apache POI");
> ext.getUnderlyingProperties().setAppVersion("3.5");
> 
> This DOES NOT WORK on either version of Excel (mac or windows)
> 
> XSSFWorkbook wb = new XSSFWorkbook();
> POIXMLProperties.ExtendedProperties ext =
> wb.getProperties().getExtendedProperties();
> ext.getUnderlyingProperties().setApplication("Apache POI");
> ext.getUnderlyingProperties().setAppVersion("3.5-beta-7020090731");
> 
> After some experimenting, it seems that anything in the AppVersion field
> except a digit or a "." causes the files to become unreadable by Excel.
> i.e. 3.5.5 works, but 3.5.beta7 does not.  Also, it only allows two "."
> values.  So, 3.5.5 works, but 3.5.5.0 does not.
> 
> I tried the following variations. All of the results were the SAME for both
> windows/mac excel, which is nice.  OpenOffice 3.1 could open every one of
> the variations.
> 
> 3.5-beta7 (excel-NO) (openoffice-OK)
> 3-5 (excel-NO) (openoffice-OK)
> 3.5.beta7 (excel-NO) (openoffice-OK)
> 3.5.b (excel-NO) (openoffice-OK)
> 3.5.0.20090731 (excel-NO) (openoffice-OK)
> 3.5.0.1 (excel-NO) (openoffice-OK)
> 
> 3.5 (excel-OK) (openoffice-OK)
> 3.5.0 (excel-OK) (openoffice-OK)
> 3.5.20090731 (excel-OK) (openoffice-OK)
> 
> According to the ECMA-376 Second Edition docs:
> 
> 22.2.2.1 Application (Application Name)
> This element specifies the name of the application that created this
> document. 
> The possible values for this element are defined by the W3C XML Schema
> string datatype. 
> 
> 22.2.2.2 AppVersion (Application Version)
> This element specifies the version of the application which produced this
> document. 
> The content of this element shall be of the form XX.YYYY where X and Y
> represent numerical values, or the document shall be considered
> non-conformant. 
> [Note: The contents of this element do not represent absolute values, but
> rather qualify the contents of the Application element to differentiate
> between different versions of the same producer. Applications should use
> this information in an informative manner only (as document metadata). end
> note]  
> The possible values for this element are defined by the W3C XML Schema
> string datatype.
> 
> Hope that helps,
> --Leif
> 
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
> 
> 


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