You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2003/05/05 10:14:02 UTC
DO NOT REPLY [Bug 19638] New: - Same cell definitions blows document (problem with HSSFSerializer)

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=19638>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=19638

Same cell definitions  blows document (problem with HSSFSerializer)

           Summary: Same cell definitions  blows document (problem with
                    HSSFSerializer)
           Product: Cocoon 2
           Version: Current CVS 2.1
          Platform: Sun
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: sitemap components
        AssignedTo: cocoon-dev@xml.apache.org
        ReportedBy: Grigorios.Merenidis@Dresdner-Bank.com
                CC: poi-dev@jakarta.apache.org


Define more cells with the same dataformat in the gnumeric file blows the 
formatting of the document so that when opened in 
Excel, incorrect styles/fonts/formats are applied to the cells in the 
document. Fails with 1.10.0-dev-20030222. 

Sample code:


<gmr:Styles>
<gmr:StyleRegion startCol="0" startRow="0" endCol="0" endRow="0">

<gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" 
Locked="1" Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0"
PatternColor="9999:9999:FFFF" Format="#,##0.00#">

            <gmr:Font Unit="12" Bold="1" Italic="0" Underline="0" 
StrikeThrough="0">Arial</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1" Color="3333:3333:3333"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1" Color="3333:3333:3333"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
</gmr:Styles>

<gmr:Styles>
<gmr:StyleRegion startCol="1" startRow="1" endCol="1" endRow="1">

<gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" 
Locked="1" Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0"
PatternColor="9999:9999:FFFF" Format="#,##0.00#">

            <gmr:Font Unit="12" Bold="1" Italic="0" Underline="0" 
StrikeThrough="0">Arial</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1" Color="3333:3333:3333"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1" Color="3333:3333:3333"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
</gmr:Styles>

<gmr:Styles>
<gmr:StyleRegion startCol="2" startRow="2" endCol="2" endRow="2">

<gmr:Style HAlign="2" VAlign="2" WrapText="0" Orient="1" Shade="1" Indent="0" 
Locked="1" Hidden="0" Fore="0:0:0" Back="C0C0:C0C0:C0C0"
PatternColor="9999:9999:FFFF" Format="#,##0.00#">

            <gmr:Font Unit="12" Bold="1" Italic="0" Underline="0" 
StrikeThrough="0">Arial</gmr:Font>
            <gmr:StyleBorder>
              <gmr:Top Style="1" Color="3333:3333:3333"/>
              <gmr:Bottom Style="1"/>
              <gmr:Left Style="1" Color="3333:3333:3333"/>
              <gmr:Right Style="1"/>
              <gmr:Diagonal Style="0"/>
              <gmr:Rev-Diagonal Style="0"/>
            </gmr:StyleBorder>
          </gmr:Style>
        </gmr:StyleRegion>
</gmr:Styles>


In the created xls file, only the first date is formatted as a #,##0.00#. In 
more 
elaborate instances, this causes styles/fonts to be applied to the wrong cells.