Home Forums Support Report Export – XLSX and CSV Amount format

This topic contains 6 replies, has 3 voices, and was last updated by  zjenko 2 months, 2 weeks ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #19115

    marcassin
    Participant

    InvoiceNinja : 4.5.9
    Debian GNU/Linux 9.7 (stretch)
    Nginx : 1.10.3
    MariaDB : 10.1.37
    White labeled

    Hello,

    in the exports, the amounts and the currency symbol are joined in the same field and is formatted (-3’500.00 CHF). This is interpreted as text, not number, with LibreOffice.

    It would be nice if the amount and the currency symbol will be inserted in separated columns and if the amount would be a pure number, without formatting…

    Marc

    #19118

    Hillel Coren
    Keymaster

    Thanks for the feedback! We’ll look into it.

    #19119

    marcassin
    Participant

    Wooww, what a fast answer !

    Thank you for your quick reaction and professionalism !

    Marc

    #20348

    zjenko
    Participant

    Hi,

    I second the problem with “Amount” being formatted as text – you have to manually change the formatting and fix stuff up if you want to create any relevant reports based on the export. I also noticed today that some amounts are exported as 99.00 whereas some other suddenly have 99,00 – so some amounts have dot and some have a comma – which also further complicates things.

    Would really appreciate if this would be fixed 🙂

    Cheers

    #20349

    zjenko
    Participant

    The comma and dot thing actually seems to be also present in the UI:

    View post on imgur.com

    View post on imgur.com

    #20366

    zjenko
    Participant

    Checked the DB and the values are stored correctly in the database itself – they just seem to be shown wrong randomly in the web UI and in the export.

    #20367

    zjenko
    Participant

    Since currencies are a table of its own and the amount column only includes the amount as number – it would be ideal if the export function would have a separate column for currencies – that way you can easily filter by currency and the amount column can be formatted as number since it would not contain currency text anymore.

    I’ll put this on github as feature request as well.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Posted in: