Author Topic: negative numbers in Excel export left aligned (text instead of number format)  (Read 60 times)

jaapmurre

  • Newbie
  • *
  • Posts: 2
    • View Profile
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

  • Newbie
  • *
  • Posts: 2
    • View Profile
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).
.

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3894
    • View Profile
Thanks for pointing it out. Looking into it..

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3894
    • View Profile
This is fixed for -ve numbers in v6.1.0. Numbers in scientific notation are not supported yet.