People looking over my shoulder were shocked to see complex formula seeming to pop onto the screen as the prof wrote them on the board. With LO you can enter complex formula (calculus and eng formulas) almost as fast as you can read them. I could be in a class taking notes in LO and the prof would start a long string of formula on the board. However, when I was at Uni for Eng, LO always shocked my classmates. I haven't had as much luck with creating macros and such in LO but I also haven't had a need to look into it yet. The big area where excel, well, excels, is in programming. There always seems to be a way to do what I want in LO but I can't find a way to do it in WORD/EXCEL, etc. While I agree that Libreoffice might not be the prettiest UI of the bunch, after having tried many of your listed alternatives, as well as Microsoft Office standalone, I always come back to LO for my work.
I am not saying customizing LO will solve the problem, it is already far superior and has features that no standard MS user would ever use but features like Excel Macros, key bindings don't quite work well. I have used Office 2013 icons (2019 are available?) and MS like colors.
Here is my LibreOffice setup it's not possible to add anything more to it. If I were to recommend one of the options to a Windows user, which one would make more sense? (The folks have hatted LibreOffice on Windows) I haven't had time to try out all the features and hence I want community suggestions. Google Suite: Perfect for university students (me), good development but lacks many features. Microsoft Office Online: nice offering but is slow and sluggish (are they using asp?), lacks many features (I can't even draw a line). OnlyOffice: Web version + desktop + cloud solution available, decent compatibility with MS, mature?, new in the market. Gnome Office (Abiword, Gnumeric, Dia): Is it still a thing?įreeOffice: The best office suite after LibreOffice, not open source, good compatibility with MS, mature project, WPS Office: Pretty advanced alternative to MS suite, not open source, a mature project but seems not maintained.ĬalligraOffice: Actually KOffice, doesn't even come close to LibreOffice, slow development, difficult to switch for naive user. LibreOffice: Standard office suite for Linux, it just works, not very good support for docx, classic UI (new ribbon interface doesn't make it modern), better than online suites.Īpache OpenOffice: Same as LibreOffice but with better docx support. I tried these office suites currently offered on Linux ( bold are my best bet), I must say, both of these in-browser tools are nice but still don't come close to what LibreOffice has to offer (I have come across situations where I had to use LibreOffice because either of the other two didn't have the feature). Recently I switched to Office online like Microsoft suite and Google suite. And, I'm in the UK so the date format is set to UK date format for all of the cells containing dates.I have been using LibreOffice for past 2 years, hated it all the time because of the UI not being modern as compared to MS (not icons but simplistic design). I selected G2 so you can see the array formula.
I coloured some of the cells to make it clearer to read. Or alternatively you can use a specific cell like F2 below where you can enter the customer ID you want to check the dates for. When you've turned the formula into an array formula you can then drag the formula down to apply the array formula to the rest of the rows like the screen shot below. You can find out more about array formulas in this Microsoft support page: If you use the formula without the it can only be done by pressing Ctrl Shift and then Enter key. I think Eric has cracked your problem, so to explain it further.
0 kommentar(er)
