Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I export a table to excel numeric columns are exported as text.
On the document "QlikView 11 SR2 Beta Release Notes" there is a bug number related to this problem
46971 Exporting excel as numbers does not work correctly.
Environment: QV 11 SR2 64-bit + Windows XP Pro x64 v 2003 SP2 + MS Office 2010 32 bits
I've tested all combinations (54) of Document Preferences Encoding (3x) by User Preferences Number Formatting (3x) and Encoding (3x) and Use Regional settings (2x). 3x3x3x2=54. None of the combinations works fine.
Between every preference change a every click on Export to Excel I've closed and open QV ... not only thq qvw document.
Hi:
Following the instructions on this article https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=... at the customer portal I've found the way to export numeric fields as numeric cells ... but unformatted.
Hi:
Following the instructions on this article https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=... at the customer portal I've found the way to export numeric fields as numeric cells ... but unformatted.