Okay
  Public Ticket #1850985
Number Range Filter for Google Spreadsheets not working with decimals
Closed

Comments

  • nonpro started the conversation

    Hi there!

    I tried using the "number range" filter with a Google Spreadsheet source and the filter works for integers but not for floats with decimals ("2,7" or "2.7").

    Instead it simply ignores the "." or "," and so it works like entering "27".

    Could you please let me know why this happens and how to solve this?

    Thanks in advance.

    Philip

  •  231
    Aleksandar replied

    Hello Philip.

    Thank You for Your purchase.

    Sorry for late response. 

    Our company is located in Serbia and our working time is from 10:00 to 17:00 CET. business days.

    Please provide me a temporary WP-admin login 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 party. You can write credentials here just check Private Reply so nobody can see them except us.

    Best regards.

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  •   nonpro replied privately
  •   Aleksandar replied privately
  •   nonpro replied privately
  •  231
    Aleksandar replied

    Hello again Philip.

    I am sorry to disappoint you, but unfortunately when you are using float as a column type in order to find a value you must enter the value in filters with decimals, but in that case you can't use the Number Range filter when the source values' filter is different from what you set in wpDataTables. Like I mentioned in the previous reply, the number range filter recognizes only numerical values, and a decimal point. But, since the decimal point in Google Spreadsheet document is actually a comma, it can't see that point.

    What you can do to make the number range filter work is change the formatting in Google Spreadsheets, so the number value is stored as 12.00 instead of 12,00. Then, you can change the Number Format in main settings of wpDataTables and it should be working normally.

    I've created a simple Google Spreadsheet document and added some Float values (I believe you should have access if you want to try it for yourself Google Spreadsheet Float Test). I changed the format of that column to be Number 1,000.12 (attachment 1). Then, I changed the Number format in wpDataTables settings (attachment 2); and created a table using that Google Sheet table.

    As you can see from attachments 3 and 4, the number range filter works, but only when the values are typed in fully. What I mean by this is - if I enter from 20.33 to 25 - it's going to say "No matching records found"; if I enter 20.33 to 25.0 it's also going to say "No matching records found", but when I add 25.00 it filters the correct data.

    Please let me know if this solution works for you.

    Best regards.

    Attached files:  attachment 1.png
      attachment 2.png
      attachment 3.png
      attachment 4.png

    Check out our new Support Help Center!

    Check out our newest product - Amelia - Enterprise-Level WordPress Appointment Booking Plugin

    Kind Regards, 
    Aleksandar Vukovic
    aleksandar.vukovic@tms-outsource.com

  •   nonpro replied privately
  •   Aleksandar replied privately