Reply To: Export Rounding issue

Home Forums Quform WordPress Export Rounding issue Reply To: Export Rounding issue

#33385
PCLSIT
Participant

Thanks, Ally!

We are using Quform 2.14.2 and Excel 2016 (16.0.5188.1000).

It turns out I hadn’t tested the CSV export with the fix (# version). With the # fix, the Excel export still has the rounding issue, but the CSV is actually correct!

With no fix and with the @ fix, both CSV and Excel 2007 are incorrect (CSV has the number in scientific notation; Excel does as well, and when you click the cell, the function bar shows the number in regular format, but rounded).

Interestingly – exporting as Excel 2005 is correct, even with no fix in place.

I’m still interested in a fix for Excel 2007 format if possible, but I’m glad to have some export options that preserve the number!

I appreciate the help!
-Alice

Be inspired. © 2020 ThemeCatcher Ltd. 20-22 Wenlock Road, London, England, N1 7GU | Company No. 08120384 | Built with React | Privacy Policy