Bug 62217 - While reading a cell from Spreadsheet the precision is changed from 10 to 6 digits after decimal in 3.17
Summary: While reading a cell from Spreadsheet the precision is changed from 10 to 6 d...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.17-FINAL
Hardware: All All
: P2 regression (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-24 09:20 UTC by Mayur Jain
Modified: 2020-02-24 06:59 UTC (History)
1 user (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mayur Jain 2018-03-24 09:20:17 UTC 
While reading a cell from Spreadsheet the precision is changed from 10 to 6 digits after decimal in 3.17 version

org.apache.poi.ss.usermodel.DataFormatter dataFormatter = new DataFormatter();

String content = dataFormatter .formatCellValue(Cell);

Value in the spreadsheet is 1290.219821387213
Earlier version 3.12 value returned is 1290.2198213872 but the precision is reduced to 6 digits after decimal in latest version to 1290.219821