ParamQuery grid support forum

General Category => Bug Report => Topic started by: jaapmurre on May 03, 2019, 03:45:07 am

Title: negative numbers in Excel export left aligned (text instead of number format)
Post by: jaapmurre on May 03, 2019, 03:45:07 am

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

Title: Re: negative numbers in Excel export left aligned (text instead of number format)
Post by: jaapmurre on May 03, 2019, 06:30:28 pm

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).
.

Title: Re: negative numbers in Excel export left aligned (text instead of number format)
Post by: paramvir on May 04, 2019, 10:23:13 am

Thanks for pointing it out. Looking into it..

Title: Re: negative numbers in Excel export left aligned (text instead of number format)
Post by: paramvir on May 20, 2019, 01:17:08 pm

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