Honestly I find so many illogical things in Calc. Is MS Excel more logical? I could write an encyclopedia on Calc’s deficiencies after using it for a few months. I’d love to make it work properly. Is this typical or am I just dumb with spreadsheets? Like so many conventions we’re used to in Word or text programs don’t work in Calc even though they could. So often I start typing in a field and the formatting is different for no logical reason. Obviously I’ve changed it somehow by copying and pasting something into it. I’m trying to always paste unformatted to minimize this from happening.
Today I noticed one column’s SUM didn’t look right and sure enough 2 of the fields weren’t being included in the =SUM(A1:A5) formula. I subtracted the Calc SUM from what it should be and found them and entered them manually and all was well. There should be a way of pasting things without changing formatting. Isn’t that obvious to any sane person? If the whole spreadsheet is in a set format why would anyone want to change that when pasting info into it? It’s like this program was designed by crazy people with no semblance of logic.
All the time a column’s formatting will change as well, especially in terms of alignment when pasting stuff. Drives me nuts. Obviously a column should retain it’s alignment!!!
Is there really no option to retain formatting when pasting other than always pasting unformatted text which isn’t as fast?
Spreadsheets are a miraculous idea. Now to get them to work well. I admit I’m a newer user and am learning things all the time whereas I’ve been using text based software for decades. They should really teach spreadsheets in high school. Few things could be more useful in life for keeping track of things.