02-08-2018 11:33 AM
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.
02-08-2018 04:38 PM
Confirmed and currently on our agenda for the upcoming next release of XLR8.
Regards,
Data Ahead
02-23-2018 09:26 AM
This will be resolved with the upcoming release v2018.2 of XLR8 - hopefully online within the next week.
Regards, Data Ahead