workbook open in German OS

[Shuli Zhou/schedule <sh...@Barra.COM>]

Hi,

Our application uses POI HSSF to export excel workbooks to clients. A
problem is that when some workbooks are opened in German platform (German
Windows 2000 with office), the client will get a popup:

Namenskonflikt 
name darf integriertem Namen nicht gleichen 
Alter Name: Drucktitel 

translated roughly as:
Name conflict 
Name may not be similar to integrated name 
Alternative name: pressure title 

The same workbook opens fine in English OS. After opening it in English
OS/Excel2000, save it as another file without changing anything, the saved
copy opens fine in German platform.

Anyone has any clue how to get rid of the popup? Thanks in advance.
Shirley

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Re: [poi] workbook open in German OS / workbook.createSheet

[Christian Gosch <c....@inovex.de>]

Hi,

this may be an answer to Shuli Zhou and Shinya Koizumi.

In short, "Drucktitel" is the (German) reserved name of the 'named range' (I
don't exactly know how this is officially called in POI object model)
containing the 'repeating rows & cols' of one sheet for printing. This is
not to confuse with 'freeze pane', which basically serves the same purpose
when viewing a sheet in 'edit mode'. Similarly, there is another reserved
name in German Excel versions called "Druckbereich" which means the 'named
range' effectively printed (by default: All cells with any content).

I did not experience the described behaviour before, but the difference
between opening the sheet directly on German platform and opening it on enUS
platform before is explainable: Internally this 'named range' has no visible
name but some identifier which is automatically transferred to the localized
name when the sheet is opened on some localized platform.

The same holds for placeholders (or call them variables) in the
header/footer sections of a sheet denoting "number of the current page" or
"total page number" which is internally "&P" resp. "&N", but on german
platform it shows up as "[Seite]" resp. "[Seiten]".

Thus you eventually should not give any 'nameable' object a name identically
to reserved object names used in the localized target platform versions
except for their by-design purposes.

hth,
Christian Gosch
inovex GmbH


On Monday, October 24, 2005 10:57 PM [GMT+1=CET],
Shuli Zhou/schedule <sh...@Barra.COM> wrote:

> Hi,
>
> Our application uses POI HSSF to export excel workbooks to clients. A
> problem is that when some workbooks are opened in German platform
> (German Windows 2000 with office), the client will get a popup:
>
> Namenskonflikt
> name darf integriertem Namen nicht gleichen
> Alter Name: Drucktitel
>
> translated roughly as:
> Name conflict
> Name may not be similar to integrated name
> Alternative name: pressure title
>
> The same workbook opens fine in English OS. After opening it in
> English OS/Excel2000, save it as another file without changing
> anything, the saved copy opens fine in German platform.
>
> Anyone has any clue how to get rid of the popup? Thanks in advance.
> Shirley
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Gruesse,
-- 
Dipl.-Inform. Christian Gosch
Systems Development
inovex GmbH
Karlsruher Strasse 71
D-75179 Pforzheim
Tel.: +49 (0)72 31 - 31 91 - 85
Fax: +49 (0)72 31 - 31 91 - 91
mailto:c.gosch@inovex.de
http://www.inovex.de


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/