# Rounding in vision?

**URL:** <https://forum.inductiveautomation.com/t/rounding-in-vision/11119>\
**Category:** Ignition\
**Created:** [January 26, 2016, 2:16pm UTC](https://forum.inductiveautomation.com/t/rounding-in-vision/11119 "2016-01-26T14:16:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [January 26, 2016, 2:16pm UTC](https://forum.inductiveautomation.com/t/rounding-in-vision/11119/1 "2016-01-26T14:16:02Z")

</div>

Hi, guys!  
It’s very important, help please.  
I have dataset with 2 columns: t\_stamp and Value.  
Then I export this dataset to Excel on my Desktop.  
When I make an export from Designer all the values are good and have 4 numbers after comma (1,5234 and 5,2314).  
[attachment=1]Designer.xls[/attachment]  
BUT when I make an export from Viewer all the values stay rounded (1 and 5).  
[attachment=0]Viewer.xls[/attachment]  
Why it happens?

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 26, 2016, 4:23pm UTC](https://forum.inductiveautomation.com/t/rounding-in-vision/11119/2 "2016-01-26T16:23:05Z")

</div>

What version of Ignition are you using? By ‘Viewer’, do you mean the Dataset Viewer that pops up when you view the dataset property on say, a table? What steps did you take to get that dataset into an excel file?

I wasn’t able to replicate this in 7.7.7-beta1 in either an English environment or a French VM (in case the comma as a decimal separator was causing the issue), but I’m probably not doing it exactly the way you are.

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [January 29, 2016, 9:19am UTC](https://forum.inductiveautomation.com/t/rounding-in-vision/11119/3 "2016-01-29T09:19:48Z")

</div>

Ignition 7.7.5 x64  
I don’t know what happens but it is works fine now.

Here is the code, where dataset has 2 columns (datetime, float) and i need to add one more row before export to Excel with Summ of floats (diffLine):

csv = system.dataset.toCSV(resultDataset, 1, 1)  
csv = csv.replace(’“date”’, ‘“str”’, 1)  
csv = system.dataset.fromCSV(csv)  
csv = system.dataset.addRow(csv,diffLine)  
system.dataset.exportExcel(“d:\data.xls”, 1, csv)