Okay
  Public Ticket #3750994
Decimals are in wrong place Google API
Closed

Comments

  • Chipego Himonga started the conversation

    I am having endless problems with numbers/float/integers. They are being imported, but the decimals are not in the right places compared to the google sheet.

  • Chipego Himonga replied

    I am having to format all my numbers are strings which means I am losing calculation functionality.

  •  1,846
    Miloš replied

    Hi Chipego,

    I am not 100% sure if you are having a table linked to synchronize from the Google Sheet source - or if you are importing it to make an editable/manual table, so we will advise for both cases.

     

    1. If you use a table linked from the source Sheet, this is easy to solve :

      This is most probably an issue with the current Number Format and Decimal places selected in your settings.

      Please go in your Main Plugin settings/ and change the Number Format to the one you need;

      Also double-check how many decimal places you need and set this accordingly as well.

      3040442148.png
      2786521918.png

      Let me know if that solves the issue.

       

    2. Or, if you are importing the data into an editable table, here are more details on that :

    When we import the data in a new Manual Table - at the moment, there is this 'limitation' so to speak.

    By default, it is going to set a 4 decimals as the format;

    So during the Table creation, please choose for each Float column, edit this 'Type value' and leave the first number as 16,  just edit the second one from the "4"  as default decimal number to the decimal number you need :

    9522526855.png
    3231911153.png

    Then this field will be created in your SQL Database as the set decimal number.

    Also important to note, for presenting the default decimal number in the Plugin, you can set your desired number of decimals in the Main Plugin settings, too.

    7250484679.png

    Later you will also be able to override this per Column;

    So my Column here will become saved with 2 decimals - but i can go in Column settings/Data tab and change this to render as 4 to override it in the Table.

    That way you can have different columns with different decimal points ( if needed).

    8532543796.png
    6237492533.png

    Let me know if that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables