In Libreoffice Calc, to have the first two letters capitalized when the third letter is lowercase:

Tools → Autocorrect → Options → uncheck “Correct TWo INitial CApitals”