4 ms·

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:

by noja 7y 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

IronWolve 7y ago
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.
chopin 7y ago
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.
gerdesj 7y ago
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 7y ago
  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 7y ago
    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 7y ago
    Isn't that the job of brew or whatever package manager you're using on apple?

by noja 7y ago

IronWolve 7y ago

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.

chopin 7y ago

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.

gerdesj 7y ago

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 7y ago
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 7y ago
  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 7y ago
  Isn't that the job of brew or whatever package manager you're using on apple?