Number column, when saved – inserts comma – read by DF as a decimal

Home Forums Classic DFFS Number column, when saved – inserts comma – read by DF as a decimal

Viewing 7 reply threads
  • Author
    Posts
    • #7504
      Alexander Bautz
      Keymaster

        Hi,
        I have tried to fix this in the v4.268 update of DFFS frontend. You find the change log here: https://spjsblog.com/dffs/dffs-change-log/

        Let me know how this works out.

        Best regards,
        Alexander

      • #7534

        The issue does not appear to have been resolved – once the comma is inserted (result of saving the newform.aspx) – it is still being read as a decimal on edit or display forms – so the rules with less than, equals, greater than in the form do not work properly.

        Confirmed that version on this subsite is in fact v4.268

      • #7549
        Alexander Bautz
        Keymaster

          Which number format are you using (locale settings in SharePoint)? – it looks like your number is in fact 225 and not 225000. You might have to change the locale in SP, or enter the number in another manner.

          You can also use a single line of text field to store this value as SharePoint will not mess with the format in a text field.

          Alexander

        • #7550

          The subsite’s regional settings – under locale – set to English (United States)… We are Canadian but I don’t have English (Canada) to choose from…

          If I change the locale – what do I change it to, and how will it affect other parts of the subsite?

          The number is saved as 225000 (value of your home). When saved, SP automatically inserts the comma to separate the thousands. Edit and Disp form are reading the comma as a decimal… You are welcome to have a look if it will help – let me know.

        • #7556

          Also – I will assume that if I change the field type to single line of text now, I will lose the data in the existing column? Trying to avoid that as this is live, in production.

        • #7560
          Alexander Bautz
          Keymaster

            Hi,
            I had a bug related to the operators “Gt”, “Geq” and “Leq” in the latest “fix” – please check if this sorts out some of these issues: https://spjsblog.com/dffs/dffs-change-log/

            Best regards,
            Alexander

          • #7568

            You were absolutely correct – it was the GT, LT and GTE/LTE issue – it is now working with the latest download.

          • #7579
            Alexander Bautz
            Keymaster

              Thank you for the feedback.

              Alexander

          Viewing 7 reply threads
          • You must be logged in to reply to this topic.