negative numbers in Excel export left aligned (text instead of number format)

[jaapmurre]

Does anyone know how to remedy this? When I use the export to Excel (in Paramquery Pro 6.0, with the dataExport function and format .xlsx) it works fine except that all negative numbers (floats and integers) turn out as left-aligned and Excel cell format as Text instead of Number. BTW This is also the case with all official Demos (juist change a few numbers to negative and export). Is there an easy fix? Using 'align: right' does not work/help. Thanks! -- Jaap

[jaapmurre]

Just noticed that the same problem occurs with numbers in scientific notation: 1.0973e-37. My guess would be that there is a regex somewhere trying to guess the type and assuming that only, say, digits and dot . can occur in a number and not also - (and +) and e (and E).
.

[paramvir]

Thanks for pointing it out. Looking into it..

[paramvir]

This is fixed for -ve numbers in v6.1.0. Numbers in scientific notation are not supported yet.