[gautaml]

I'd rather be allowed to choose rather than forced to accept

That's one problem I see with UX/UI designers; sometimes they don't really think about what the end user wants.

And this statement is just bull-crap:

"All this got me thinking about if I’m truly designing a solution to a problem if all I’m doing is replicating the features of a spreadsheet in a web app. Why wouldn’t a user just use a spreadsheet then?"

Because you're building an application not a spreadsheet viewer.