My reasoning is that the period is a "stronger" punctuation mark than the comma, and it should be used for the more important separation.

https://en.wikipedia.org/wiki/Decimal_separator

  • kleeon [he/him, he/him]
    ·
    2 days ago

    I wouldn't use excel as an example, it's most likely going to interpret it as a date no matter what you type

    I mentioned excel because it's been my arch enemy for the past 3 years to the point where I had to spend a substantial amount of time writing my own library for reading excel files maddened The thing I'm specifically talking about is how formulas may look different across localizations. For example the sum function looks as follows in english:

    =SUM(1,2,3)

    while in russian it looks like this:

    =СУММ(1;2;3)

    and excel will not allow you to type the english version

    This brought back my biggest grievance with parsing numbers, chat apps interpreting any 5+ character long numbers as phone numbers

    No, I don't want to call 10.000

    funnily enough, phone number parsing is one of my previous arch enemies. Having to turn whaterver bullshit user has typed into a phone number probably reduced my life expectancy by several months

    • mayo_cider [he/him]
      ·
      2 days ago

      I feel you, I nowadays prefer doing the calculations in python and export the results in .csv for the freaks who prefer excel

      funnily enough, phone number parsing is one of my previous arch enemies. Having to turn whaterver bullshit user has typed into a phone number probably reduced my life expectancy by several months

      This reminds me of my futile attempts of parsing URLs with regex in my teenage years when I was trying to make a guestbook for my website with PHP (the solution is .*\..*)