Re: [POI] defining Print Orientation to landscape

[Joerg Heinicke]

Sorry to hear that. The Javadoc is more than clear on that:

No-op implementation of ElementProcessor to handle the 
"PrintInformation" tag. This element is a container element with no 
attributes. This element is not used in HSSFSerializer 1.0.

We also had a request of one of our customers for landscape printing. 
Maybe anyone implements it :-) I'll be on holiday the next two weeks.

Joerg

Antonio Gallardo wrote:
Hi Joerg:

Thanks for your answer. We already tried to use <gmr:PrintInformation>.
From the docs the tag address all the issues related to the Printing. The
fact is that the current implementation in Cocoon does not process any
nested tag of <gmr:PrintInformation> and the result is that the tag does
not do nothing. The generated XLS does not have any print info.
In cocoon CVS we found that the class
o.a.c.components.elementprocessor.impl.poi.hssf.elements.EPPrintInformation
just have the following constructor:

public EPPrintInformation()
    {
        super(null);
    }
Here is how we configured the tag:

<gmr:PrintInformation>
    <gmr:Margins>
        <gmr:top Points="2" PrefUnit="cm"/>
        <gmr:bottom Points="2" PrefUnit="cm"/>
        <gmr:left Points="0.64" PrefUnit="cm"/>
        <gmr:right Points="0.64" PrefUnit="cm"/>
        <gmr:header Points="1" PrefUnit="cm"/>
        <gmr:footer Points="1" PrefUnit="cm"/>
    </gmr:Margins>
    <gmr:Scale type="percentage" percentage="100"/>
    <gmr:vcenter value="0"/>
    <gmr:hcenter value="0"/>
    <gmr:grid value="0"/>
    <gmr:even_if_only_styles value="0"/>
    <gmr:monochrome value="0"/>
    <gmr:draft value="0"/>
    <gmr:titles value="0"/>
    <gmr:repeat_top value=""/>
    <gmr:repeat_left value=""/>
    <gmr:order>d_then_r</gmr:order>
    <gmr:orientation>landscape</gmr:orientation>
    <gmr:Header Left="" Middle="&amp;[TAB]" Right=""/>
    <gmr:Footer Left="" Middle="P&#195;&#161;gina &amp;[PAGE]" Right=""/>
    <gmr:paper>US-Legal</gmr:paper>
</gmr:PrintInformation>
Please tell me what we are doing wrong.

Best Regards,

Antonio Gallardo

Joerg Heinicke dijo:

Hello Antonio,

the best resource is the "The Gnumeric File Format" guide linked twice
from http://wiki.cocoondev.org/Wiki.jsp?page=XLSSerializer.
There is written:

<gmr:orientation>landscape</gmr:orientation>

of course embedded in

<gmr:PrintInformation>
  ...
</gmr:PrintInformation>
Regards,

Joerg

Antonio Gallardo wrote:


Hi:

We are trying to manage the print orientation of a serialized Excel
spreadsheet using POI.
How we can define the print orientation of the page to landscape?

Best Regards,

Antonio Gallardo


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]