McLeodMoores / xl4j

Framework for writing Excel Add-ins in Java
Other
7 stars 3 forks source link

Convert Double.Inf and Double.NaN to and from XLErrors (or strings) #84

Closed jimmoores closed 8 years ago

jimmoores commented 8 years ago

Double.Inf <-> XLError.Div0 (#DIV0!) Double.NaN <-> XLError.NA or XLString.of("#NaN")

emcleod commented 8 years ago

Easy enough to convert Infs and NaNs to the appropriate error: am making a decision to map XLError.Div0 and XLError.NA to Double (could be Float, for example).