this post was submitted on 26 Dec 2024
102 points (98.1% liked)
chat
8246 readers
293 users here now
Chat is a text only community for casual conversation, please keep shitposting to the absolute minimum. This is intended to be a separate space from c/chapotraphouse or the daily megathread. Chat does this by being a long-form community where topics will remain from day to day unlike the megathread, and it is distinct from c/chapotraphouse in that we ask you to engage in this community in a genuine way. Please keep shitposting, bits, and irony to a minimum.
As with all communities posts need to abide by the code of conduct, additionally moderators will remove any posts or comments deemed to be inappropriate.
Thank you and happy chatting!
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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 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
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
I feel you, I nowadays prefer doing the calculations in python and export the results in .csv for the freaks who prefer excel
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
.*\..*
)