Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.0
    • Fix Version/s: 3.0.1, EE-3.0.0.GA
    • Component/s: ACE-Components
    • Labels:
      None
    • Environment:
      Chrome17, FF10, IE9, ICEfaces 3.0

      Description

      Example page code:
                  <h:panelGrid columns="5">
                          <ace:dataExporter label="Export to CSV" type="csv" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to PDF" type="pdf" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to XLS" type="xls" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to XML" type="xml" target="carTable" fileName="cars"/>
                  </h:panelGrid>
                  
                 <ace:dataTable id="carTable"
                                          value="#{dataTableBean.cars}"
                                          var="car">
                      <ace:column headerText="Name">
                         <ace:cellEditor>
                              <f:facet name="output">
                                  <h:outputText value="#{car.name}"/>
                              </f:facet>
                              <f:facet name="input">
                                  <h:inputText value="#{car.name}"/>
                              </f:facet>
                          </ace:cellEditor>
                     </ace:column>
                     <ace:column headerText="Chassis">
                        <h:outputText value="#{car.chassis}"/>
                     </ace:column>
                     <ace:column headerText="Weight (lbs)">
                         <h:outputText value="#{car.weight}"/>
                     </ace:column>
                     <ace:column headerText="Options">
                         <ace:rowEditor/>
                     </ace:column>
                  </ace:dataTable>

      Bugs detected:
      1. Editable columns remain blank when exported to CSV file (in our case name column)
      2. Export to PDF file does not work at all
      3. Export to the XLS file throw an exception org.apache.poi.ss.usermodel.RichTextString - class java.lang.NoClassDefFoundError (on client).

      FF Console output:
      [window] received error message [code: 200]: <?xml version='1.0' encoding='UTF-8'?> <partial-response><error><error-name>class java.lang.NoClassDefFoundError</error-name><error-message><![CDATA[org.apache.poi.ss.usermodel.RichTextString]]></error-message></error><changes><extension aceCallbackParam="validationFailed">{"validationFailed":false}</extension></changes></partial-response>
      bridge...8177343 (line 1221)
      [window] received error message [code: 200]: <?xml version='1.0' encoding='UTF-8'?> <partial-response><error><error-name>class java.lang.NoClassDefFoundError</error-name><error-message><![CDATA[org.apache.poi.ss.usermodel.RichTextString]]></error-message></error><changes><extension aceCallbackParam="validationFailed">{"validationFailed":false}</extension></changes></partial-response>

      4. Export to XML file will produce next tag <name></name> for editable column, but the content of it will be blank as with CSV file
      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
      Example page code:
      <h:panelGrid columns="5">
                          <ace:dataExporter label="Export to CSV" type="csv" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to PDF" type="pdf" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to XLS" type="xls" target="carTable" fileName="cars"/>
                          <ace:dataExporter label="Export to XML" type="xml" target="carTable" fileName="cars"/>
                  </h:panelGrid>
                  
                 <ace:dataTable id="carTable"
                                          value="#{dataTableBean.cars}"
                                          var="car"
                                          rowIndexVar="rowNo">
                     
                     <ace:column headerText="Row no">
                               <h:outputText value="#{rowNo + 1}"/>
                      </ace:column>
                     
                      <ace:column headerText="Name">
                         <h:outputText value="#{car.name}"/>
                     </ace:column>
                     <ace:column headerText="Chassis">
                        <h:outputText value="#{car.chassis}"/>
                     </ace:column>
                     <ace:column headerText="Weight (lbs)">
                         <h:outputText value="#{car.weight}"/>
                     </ace:column>
                  </ace:dataTable>

      Bugs detected:
      1. Row numbers always stay the same when exported to CSV file. (in our case it is 1)
      2. Export to PDF file does not work at all
      3. Export to the XLS file throws an exception org.apache.poi.ss.usermodel.RichTextString - class java.lang.NoClassDefFoundError (on client).
      4. Export to XML file will produce next tag: <row no>1</row no>. The number will always be the same for each row tag. In addition to the number, produced tag name is incorrect.

      Based on W3C recomendation:
      Names can contain letters, numbers, and other characters
      Names cannot start with a number or punctuation character
      Names cannot start with the letters xml (or XML, or Xml, etc)
      Names cannot contain spaces <<<< this is the one we are breaking during the export (http://www.w3.org/TR/REC-xml/#sec-white-space)
      Any name can be used, no words are reserved.
      1. src.rar
        2 kB
        Evgheni Sadovoi
      2. welcomeICEfaces.xhtml
        2 kB
        Evgheni Sadovoi

        Activity

        Repository Revision Date User Message
        ICEsoft Public SVN Repository #28016 Fri Feb 24 11:04:42 MST 2012 art.zambrano ICE-7792 added support for ace:cellEditor; added support for rowIndexVar; added code to sanitize tag names in XML format
        Files Changed
        Commit graph MODIFY /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/PDFExporter.java
        Commit graph MODIFY /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/Exporter.java
        Commit graph ADD /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/util/XMLChar.java
        Commit graph MODIFY /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/ExcelExporter.java
        Commit graph MODIFY /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/XMLExporter.java
        Commit graph MODIFY /icefaces3/branches/icefaces-3.0.x-maintenance/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/CSVExporter.java
        Repository Revision Date User Message
        ICEsoft Public SVN Repository #28015 Fri Feb 24 10:55:27 MST 2012 art.zambrano ICE-7792 added support for ace:cellEditor; added support for rowIndexVar; added code to sanitize tag names in XML format
        Files Changed
        Commit graph ADD /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/util/XMLChar.java
        Commit graph MODIFY /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/XMLExporter.java
        Commit graph MODIFY /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/PDFExporter.java
        Commit graph MODIFY /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/CSVExporter.java
        Commit graph MODIFY /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/ExcelExporter.java
        Commit graph MODIFY /icefaces3/trunk/icefaces/ace/component/src/org/icefaces/ace/component/dataexporter/Exporter.java

          People

          • Assignee:
            Arturo Zambrano
            Reporter:
            Evgheni Sadovoi
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: