DATA AHEAD toolkit support Discussions

cancel
Showing results for 
Search instead for 
Did you mean: 

Set precision as displayed - XLR8

Wanted to see if anyone can confirm this behavior:

Anytime I do a save or a save as to Excel using XLR8 the newly saved xlsx data file will have the "set precision as displayed" checkbox marked. This box is found in Excel by going to file, options, advanced, and scroll down to the "When calculating this workbook:" section.

 

This is scary because with that box checked anytime you read that spreadsheet it will only give you the number that is displayed (as it is formatted), not the actual value of the cell.

 

Attached is a simple vi that can be used for testing, it just writes random data to a file.

 

I am using LabVIEW 2014 with XLR8 version 2.3.1.7 and Excel 2013.

0 Kudos
Message 1 of 3
(3,836 Views)

Confirmed and currently on our agenda for the upcoming next release of XLR8.

 

Regards,

Data Ahead

Kudos are welcome...
0 Kudos
Message 2 of 3
(3,808 Views)

This will be resolved with the upcoming release v2018.2 of XLR8 - hopefully online within the next week.

Regards, Data Ahead

Kudos are welcome...
0 Kudos
Message 3 of 3
(3,780 Views)