Hacker News new | ask | show | jobs
by noja 2401 days ago
Why is that? Nobody ready to improve LibreOffice Calc? Calc is not good enough to start improving on?

Do we need a list of missing features? I would also add:

* Copy paste from Writer does not work

* Summing a column (not a range) isn't possible

* Type detection is not as good

* Auto-update doesn't work at all

3 comments

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

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.

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.

Isn't that the job of brew or whatever package manager you're using on apple?
Copy and paste on linux when using multiple apps and remote vms/vnc/rdp etc, is a pain. Depending on what app you use, its looking for which clipboard buffer and what commands to copy/paste. Mixing Os's and apps, is a clusterfuck on a multiheaded desktop with excel in a windows rdp session and libre office in another, then throw google sheet in because work decided to switch to google office at 1/2 the price of office 365 per user.

Sigh.

I absolutely hate type detection in Excel. It's at least comparable to type coercion in Javascript, maybe even more capricious. I know the type thank you very much.