I have observed that values in cell got precised when we open excel/csv and save without changing any value.
if original value while opening excel is
123.45678989
change to
123.4567899 (after 10 digit it gets roundoff not considering decimal)
0.0000000089
change to
0.000000009 (after 10 digit it gets roundoff not considering decimal)
1.0000000089E-12
change to
1.000000009E-12
As i didinot change any value in excel but it automatically changed the value while saving i face issue in my code.
In code i need original value as well as changed value , if there is changed value , we need to create a delta. But here i didnot change any value but excel automatically change the value so in code i get original as well as changed value and it by default create delta which i dont want.
How to fix this issue /handle in java code , while saving excel without any change the original value or changed value remain same.
Please give your inputs.
Bookmarks