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

[Nicklas Karlsson (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBSEAM-3878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12444764#action_12444764 ] 

Nicklas Karlsson commented on JBSEAM-3878:
------------------------------------------

I think it would be a little sneaky to just silently insert a blank and drive the user nuts as to why the value doesn't appear. 

I'll have a look if I could drag something out of the seam resource bundle.

> Excel e:cell 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