Spreadsheet widget - decimal separators

  • AJSonline
    Asked on May 1, 2024 at 11:55 PM

    Hi,

    I have discovered that the spreadsheet widget recognises commas as decimal separators i.e 1,234 is treated the same as 1.234. I know that this is because some countries use the comma as the decimal separator. However I am in a country where we use commas as thousands separators and not for decimals. Is there a way we can turn this off for our form? I know that it is an option on the calculation widget.

    Spreadsheet widget   decimal separators Image 1 Screenshot 20

  • Kenneth JotForm Support
    Replied on May 2, 2024 at 1:50 AM

    Hi AJSonline,

    Thank you for reaching out to Jotform Support. While, the feature you're looking for isn't available at Jotform right now. We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

    Thanks for your patience and understanding, we appreciate it.

 
Your Answer