[gerdesj]

I've just pasted some data from Writer into Calc.

Could you elaborate on your column summation problem please. =sum(E:E) works as does the summation button.

Don't understand your third point but if it is text vs numbers and dates etc then I've had plenty of fun with this in Excel as well over the decades.

Auto-update - please elaborate where it fails

[noja]

I've just pasted some data from Writer into Calc.

Try to paste a table from Writer into Calc so that the structure is converted to rows and columns (like Word and Excel does).

Could you elaborate on your column summation problem please. =sum(E:E) works as does the summation button.

~I get Err:522 when I run =SUM(E:E)~

It works!

Don't understand your third point but if it is text vs numbers and dates etc then I've had plenty of fun with this in Excel as well over the decades.

Me too. It's annoying in Excel, but worse in Calc.

Auto-update - please elaborate where it fails

The built-in auto-updater doesn't so much fail, as hasn't ever worked at all (Mac, but I think Windows as well). iirc I get a %%PERCENT%% placeholder sometimes, and the rest of the time I have to download the update from the website instead. Same on several machines.

[gerdesj]

I can paste a table into Calc OK. It was a simple effort with a,b,c,d in row 1 and 1,2,3,4 in row 2. The numbers came in as numbers OK. Paste as unformatted text is rubbish (single column of data) and I think I might file a bug for that.

Sorry, I get you now about auto updater - software updater not [Google: Excel auto-updater]. That's not really a thing on Linux because when you update the system, the whole thing updates - apps and all.

The pace of development in LO is absolutely amazing but there are some horrendous bugs with near immortality status. If you can put up with them then use it. No software is perfect but LO is moving at increasing speed towards the light.

[stjohnswarts]

Isn't that the job of brew or whatever package manager you're using on apple?