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 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-24 09:20 UTC by Mayur Jain
Modified: 2018-04-02 00:00 UTC (History)
0 users



Attachments

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