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