If it don’t start with = it ain’t a damned FORMULA!
I’m lookin at you Microsoft Office/Quirks Excel, LibreOffice/OpenOfice Calc, Corel Office Quattro-Amateur, and yer ilk!
None of you sons of bitches seem to get this. There is NO SETTING to tell these fuckers to knock this shit off!
If I want to type “+/- “ or anything remotely similar I have to prefix it with an apostrophe... to make this worse, calc then SHOWS THE APOSTROPHE! This seriously slows work flow and pisses me off, distracting me from my work while I fight the Google to try to find anyone in the fucking world who has EVER mentioned this problem... guess what that fucktarded engine said about this...
And don’t even get me started on Corel’s overpriced garbage-ware!
Again, if I didn’t type a mother fucking EQUALS sign as the FIRST CHARACTER in a cell, then I am 100% fucking sure I didn’t ask you to make a fucking formula out of it! Turn that shit off or let ME turn that shit off!!!!!
Also, a NUMBER RANGE, FRACTION, OR DECIMAL IS NOT A FUCKING DATE YOU DUMB MOTHER FUCKERS! If I wanted it to BE a date, I would have FORMATTED IT AS ONE!
1-10 is ONE TO TEN. It is NEVER January 2010 or January 10, Year(Now())
1/5 is ONE FIFTH in an UNFORMATED or NUMERIC CELL, it should ONLY be treated as a date IF THE CELL IS DATE FORMATTED!
Same goes for 1.5!
Now, if I type 1/1/2000 in a cell, then type 1/2 (god damn it, tumblr, you keep your fucking auto-replace to yourself too, I didn’t ask to replace 1 / 2 with the half-fraction symbol/character (1/2)!) in the cell directly below it, THEN you can assume 1/2 is a DATE, but you should ALSO ASSUME IT FALLS IN THE SAME YEAR!
So, can we stop converting TWO-PART potential dates when we are NOT FUCKING ASKED TO? Because they could just as easily NOT BE DATES! And, the DEFAULT FORMAT IS/SHOULD-BE NUMERIC, therefor 1-10, 1.2, and 1/3 ARE NOT DATES!
Reminder, asshole devs:
^[=].*$ IS A FORMULA
^[^=].*$ IS NEVER EVER EVER A FUCKING FORMULA!!!