Export to Excel - localisation

Comments

3 comments

  • Dale Martens

    Hello Dmitriy - I am opening a support ticket for this issue.  Thanks!

    0
    Comment actions Permalink
  • Jorge Aguilar

    Another issue related to Dmitriy's and the export to excel but in my case to Spanish: the number formatting options give me the possibility to put
    Space
    Dot
    Comma
    But they do not allow me not to choose any of the three above. When exporting to excel with space in the thousands and dot in the decimals the program assumes as text what should be numbers. I have been able to remove the space in the thousands and correct the problem manually but it involves a series of steps that could be eliminated if I had the option of not placing space, dot, or comma, in the thousands place. Could you please include that possibility?

    Otro tema relacionado con el de Dmitriy y la exportación a excel pero en mi caso al español: las opciones de formato de número me dan la posibilidad de colocar
    Espacio
    Punto
    Coma
    Pero no me permiten no escoger ninguno de los tres anteriores. Al exportar a excel con espacio en los miles y punto en los decimales el programa asume como texto lo que deberían ser números. He podido eliminar el espacio de los miles y corregir el problema manualmente pero implica una serie de pasos que podrían eliminarse si tuviera la opción de no colocar espacio punto o coma en el espacio de los miles. Podrían incluir esa posibilidad por favor?

    0
    Comment actions Permalink
  • Dale Martens

    Hi Jorge - That seems like a reasonable request.  We will consider it for a future update.

    Regarding Dmitriy's issue, the solution is to import the CSV file using Excel's Data From Text / CSV feature and ensure the File Origin is set to UTF-8.

    0
    Comment actions Permalink

Please sign in to leave a comment.