[jbossseam-issues] [JBoss JIRA] Created: (JBSEAM-3878) Excel null Values get hardcoded, non-localized "#not a number#" or "#not a date#"

[Alexander Schwartz (JIRA)]

Excel null Values get hardcoded, non-localized "#not a number#" or "#not a date#" 
----------------------------------------------------------------------------------

                 Key: JBSEAM-3878
                 URL: https://jira.jboss.org/jira/browse/JBSEAM-3878
             Project: Seam
          Issue Type: Sub-task
          Components: Excel
    Affects Versions: 2.1.1.GA
         Environment: Seam 2.1.1 GA, Windows, Jetty
            Reporter: Alexander Schwartz


When there is a null date or a null number, the helper outputs a fixed, non-localized string  "#not a number#" or "#not a date#" .

I think it should work like h:outputText and the string should be empty. Another alternative would be to look up the string in the messages resources to be able to change it and to localize it. 

>From JXLHelper.java:

      case number:
          try {
              return new jxl.write.Number(column, row, Double.parseDouble(data.toString()), cellFormat);
          } catch (NumberFormatException e) {
              return new Label(column, row, "#not a number#", cellFormat);
          }
      case date:
          try {
              return new DateTime(column, row, (Date) data, cellFormat);
          } catch (ClassCastException e) {
              return new Label(column, row, "#not a date#", cellFormat);
          }


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira