Dear All, as promised, I have implemented that for SQLSheet (together with some more fixes of various errors I stumbled on and the POI 4.1.1 update). For anyone interested, here is the pull request: https://github.com/panchmp/sqlsheet/pull/33
Thanks to David and All! Cheers On Mon, 2019-10-21 at 07:13 +0700, Andreas Reichel wrote: > Dear All. > with David's help I have been able to read that XLSX correctly and > Iwill incorporate the following lines in SQLSHEET (XLSX JDBC driver) > inorder to avoid such problems in the future: > // @author David Law <[email protected]>private static final > MathContext CTX_NN_15_EVEN = new > MathContext(15,RoundingMode.HALF_EVEN);final String rawValue = > xssfCell.getRawValue();final BigDecimal rawBig = new > BigDecimal(rawValue, CTX_NN_15_EVEN); > double result = rawBig.doubleValue(); > // returns 0.1066913 as expected > Best regardsAndreas > On Sun, 2019-10-20 at 21:50 +0100, Nick Burch wrote: > > On Sun, 20 Oct 2019, David Law wrote: > > > the Cells have no Format. Take a look at the attached File, > > > cellF10. Andreas tells me it was entered as 0.1066913 & that's > > > how itsdisplayed too, although it has no format. > > > > Numeric cells have a default format if nothing else is applied, > > itcould be that perhaps?I know that David North did some work a few > > years ago on trying tounderstand + match the Excel floating point > > rules, it might be worthhaving a look at some of his mailing list > > posts for more details. Heisn't involved much in POI at the moment > > (day job priority changes),but we can always ping him to chime in > > if needed!Nick----------------------------------------------------- > > ----------------To unsubscribe, e-mail: > > [email protected] > > For additional commands, e-mail: [email protected]
