Okay
  Public Ticket #2770055
Import excel file
Closed

Comments

  • Andrea Lughi started the conversation

    When I import an excel file the values are modified: if one cel is 100,00 the values imported is 10.000,00.

    Here I can't attach the excel file.

    Could you help me?

    Thanks

  •  1,688
    Miloš replied

    HI Andrea,
    Thank you for your purchase.

    Can you please check if the number format in the file is the same like in the wpDataTables main settings (attachment)

    Both number formats must be the same.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    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

  • Andrea Lughi replied

    Yes, it the same see attached

  • [deleted] replied

    Hi Andrea

    Could we kindly ask you to share the file with us? You can simply send us the link to the file where we can download it and we will try to recreate the issue on our end and try to find the best solution.

    Thank you

  • [deleted] replied

    Hi Andrea

    In the file you sent us the decimal separator is a point

    6387718295.png

    If we create a table with this file and the number format is 15.000,00 we will get this result

    4629998248.png

    but if we change it to 15,000.00, we will get the correct format

    3703898153.png

    Please try reformatting the excel file and give it another go.

    Let us know if it works.

  • Andrea Lughi replied

    Hi Blaženka, thank you!

    I have an other issue with a table.

    I've set the "show a horizontal scroobar" as image attached but using iphone with safari, chrome and firefox the scrollbar is not visible. Could you help me? 

    The table is the "track record" here: http://www.barroccu.com/dev/sicav/products/

  • [deleted] replied

    You are most welcomesmile.png

    Could you please check if the Scrollable option is enabled, if yes please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


  •   Andrea Lughi replied privately
  • Andrea Lughi replied

    Hi Blaženka,

    were you able to access the website?
    Do you need further information?


    Thanks in advance!



  • [deleted] replied

    Hi Andrea

    I forwarded this to our developers to have a look. We were able to log in, thank you for providing the information.

    I will update you as soon as hear back from them.

    Thank you for your time and patience.

  • [deleted] replied

    Hi Andrea

    Thank you for your patience.

    After our testing we can see the scrollbar works on Chrome and Safari on an iPhone 11, and on Android devices. On an iPhone, though, it shows up only when you start scrolling, so that may be a bit confusing, but that's coming from iPhone, not wpDT. 

    If you can't scroll either way, try deleting cache and let us know if it works.

  • Andrea Lughi replied

    Hi Blaženka,

    we have tested on iPhone X and 12 but the scroll bar is not visible neither when we start scrolling.

    We have tried deleting the cache but the bar doesn't show up (only on Apple device). Attached 2 sample from the devices.

    There is an other way to show the scroll bar?


    Thanks in advance!

  • [deleted] replied

    Hi Andrea

    I forwarded this to my colleagues in development to take another look.

    I will update you with any new information I get.

    Thank you for your time and patience.

  • [deleted] replied

    Hi Andrea

    Thank you for your patience.

    Please try adding the CSS code from this thread and do let us know if helps.