[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 jmc...@gmail.com changed: What|Removed |Added Severity|major |critical --- Comment #16 from

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #17 from Javen O'Neal --- Refer to http://poi.apache.org/who.html Please always remember: nobody is paid to work on POI, the team is a bunch of volunteers who look at things in their free time. Because of that

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #15 from Javen O'Neal --- More authoritatively, [1] which specifies > FeatureMaximum limit > Number precision 15 digits [1]

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #14 from jmc...@gmail.com --- When you read this for instance : https://support.microsoft.com/en-us/kb/269370 We understand that Excel never gives more than 15 digits, so neither should POI, whatever the format put with more than 15

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 jmc...@gmail.com changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|INVALID

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #7 from jmc...@gmail.com --- I forgot to declare and define evaluator : final FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator(); -- You are receiving this mail because: You are the assignee for the

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #8 from jmc...@gmail.com --- Also, workbook is of type XSSFWorkbook. Can it have an effect on my issue ? -- You are receiving this mail because: You are the assignee for the bug.

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #9 from jmc...@gmail.com --- Sorry about the different small comments, I am trying to give as much relevant information as possible... So I must say that I read a xlsm file. -- You are receiving this mail because: You are the

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #10 from jmc...@gmail.com --- (In reply to jmclej from comment #8) > Also, workbook is of type XSSFWorkbook. Can it have an effect on my issue ? I have tried using WorkBook instead of XSSFWorkbook with WorkbookFactory.create method

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #12 from jmc...@gmail.com --- Version of poi : 3.10.1 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail:

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #11 from jmc...@gmail.com --- Additional info : I am using Excel 2013 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe,

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #13 from Javen O'Neal --- > text.DecimalFormat("#.##")) > 2734111.4155508447 Looks like the DataFormatter is working as expected. The number of digits is conaistenr with the format string.

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 Nick Burch changed: What|Removed |Added Status|NEW |RESOLVED

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 jmc...@gmail.com changed: What|Removed |Added Resolution|INVALID |--- Status|RESOLVED

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 jmc...@gmail.com changed: What|Removed |Added OS|All |Windows 7 -- You are receiving

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 jmc...@gmail.com changed: What|Removed |Added Version|unspecified |3.10-FINAL -- You are receiving

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #3 from Javen O'Neal --- (In reply to jmclej from comment #2) > (...844174 cannot give ...8447) Sure it can. You're thinking of base 10 rounding, while the computer does base 2 rounding. The binary

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 --- Comment #4 from jmc...@gmail.com --- (In reply to Nick Burch from comment #1) > The number stored in the file is rarely what Excel shows. To get the value > that Excel shows, as a String, you must use something like DataFormatter to > apply

[Bug 58966] Row.getCell doesn't retrieve the same value than what VBA gives

https://bz.apache.org/bugzilla/show_bug.cgi?id=58966 Javen O'Neal changed: What|Removed |Added Status|REOPENED|RESOLVED