Umm, okay deleting columns can mess up calculations because the damn thing doesn't realize that it needs to adjust equations when empty columns are deleted or inserted (YES, even equations where static references using the $ sign are present, because deleting a column is not the same as copy/paste an equation cell).Īnd there's dozens of other little stuff like that, that's just grrr. Else something simple like that would be obvious. But it's the evidence of bad design, that the people who maintain it don't even use it. Okay this extra step only costs me a few seconds. Let's see, when I want to add/remove zeros after the decimal, it doesn't work if I select a column with a header, because it's confused about the fact that the header is not numerical data, and so I have to select JUST the numbers and not the header. There's so so SO many other things that are just bad. No hand-coding allowed in cells for that one. EDIT: Okay freq funct isn't exactly broken, I realize that you have to use the function wizard. And now it decided for some reason to just delete a few tabs when I closed it. Simple functions like '=frequency' are just broken, yes fkn broken, as in it doesn't work, not even when I dump the example from help into some cells.

Any amount of reasonably sized data is going to lag.

But I have a never ending stream of frustration when trying to use it for anything beyond basic stuff. Is it better than having no free spreadsheet software? Yes, of course. I'm not a coder, I'm not a dev, so I'm sorry, I can't fix this but it needs to be stated somewhere so that maybe someone who has the ability to do something will. I would willingly pay for a libreoffice calc that actually worked properly.

Libreoffice sheets