Losing decimal value o import

  • Resolved aMartini

    (@amartini)


    7 years, 2 months ago

    Hello,

    First off, great plugin. It was exactly what I was looking for.

    I’m having an issue when importing a CSV with decimal values. I try to import 1,000.00 and it gets converted to 0.00. The CSV file has a dollar sign and comma, could this be what is doing that? And if so, is there an easy way to hook into this to have it format the cell on import? A client will be using this to import CSV files and I dont to make them change their CSV formatting.

    Thanks
    Alex

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author samwilson

    (@samwilson)

    Good question!

    Yes, it’s because of the dollar sign and comma that it’s not interpreting the value as a proper decimal number.

    The tricky thing is how to solve this…

    I shall have to investigate a bit, but off the top of my head unfortunately the easiest thing to do will be to change the spreadsheet formatting before import. Sorry!

    But I’ll let you know if there is a better way.

    Thread Starter aMartini

    (@amartini)

    Sounds good, thanks for the response.

    Plugin Author samwilson

    (@samwilson)

    It seems that it’s pretty hard to solve this for all the different varieties of currency input value (multiple languages, formats, etc.). Perhaps someday we’ll have a better import system that allows you to specify formats at import time (like LibreOffice etc. do), but it’s not coming this year I think. ?? Sorry!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Losing decimal value o import’ is closed to new replies.