To a limited degree, PowerPoint's advantages can be reduced by installing extensions in Impress. In particular, users might want to download from their distribution's repositories the Presenter Console, which gives a view of a running slide show on the computer, and the Presentation Minimizer, which reduces the size of slide shows to make them more portable. Both these features are built-in to PowerPoint.
However, even with these extensions, Impress lags behind PowerPoint in advanced features. Impress has the basics tools for creating and running a slide show, and it creates diagrams more easily than PowerPoint, and for most users, is more than adequate. But in advanced features, especially for sound, Impress still has some catching up to do with its proprietary rival.
Calc has always been highly compatible with Excel. Even more than Writer, it is the LibreOffice app whose files are imported most frequently to MSO formats, and a spreadsheet without precision is useless. Without this compatibility, Calc would be like Gnumeric, the spreadsheet begun as part of the long-ago abandoned GNOME Office: perhaps powerful in its own right, and admired by its users, but little used outside the free software community.
Calc's and Excel's cell and page formatting features vary occasionally in the names of the feature. Otherwise, they closely resemble each other, aside from minor differences.
For instance, Excel can vary text direction in cells and use fill patterns for backgrounds, while Calc supports embossed and engraved effects, and can add diagonal borders and borders with shadows to cells.
Calc's greatest advantage is that it can selectively delete types of contents from cells, removing formatting, for example, while leaving the contents untouched. Otherwise, the available features for formatting, fonts, alignments, borders, backgrounds, cell protection and printing are next to identical. Excel might use themes, while Calc uses page styles, but the features and ease of use are much the same if you examine them.
Calc offers two tools for entering functions, the Function List and the Function Wizard. The Function List opens in a pane on the right side of the editing window, and is suitable for experts who know the functions they need. The Function Wizard is closer to Excel's Insert Function dialog, but does a better job of showing formulas as they are built, and of warning of errors. Its main fault is that errors are cited by number, and are meaningless unless looked up. However, the Function Wizard could also benefit from Excel's function search field, which allows you to describe what you would like a function to do.
Excel lists 392 functions to Calc's 406, but these numbers tell only part of the story. Although function categories are named differently, close examination shows few differences in the functions themselves.
Usually, both the names and the options for the functions are identical. The only exceptions are Excel's seven Cube functions for creating a data pilot-like connection to information stored in a database and Calc's functions with an "a" suffix that are minor variations of Excel-compatible function, most of which have to do with how text-formatted cell contents are handled.
The tools to manipulate data are equally similar. Basic sorting and filtering tools are much the same, but Excel has a few extra that allow sorting by cell value as well as formatting choices like color or font color. Both have the ability to rearrange data with data-pilots or into charts, to which Excel adds sparklines, miniature graphs that give a quick impression of overall trends.
Other tools are more confusing because of differences in names. However, once you realize that Calc's Detective is Excel's Error Checking, and Calc's Scenarios are Excel's What-If, the differences are next to non-existent.
Unlike the case with Impress and PowerPoint, neither Calc nor Excel could be said to have major functionality that the other lacks. In the past, I have heard criticisms of Calc's slowness when making long calculations. But with LibreOffice's recent efforts to clean up the code and focus on speed in the latest 3.5.4 release, the problem seems to have disappeared since I last compared the two spreadsheets several years ago. Possibly, too, the amount of RAM on modern computers has helped to eliminate the problem.
The most you can say is that Excel has refinements that advanced users might appreciate. However, these refinements are far from necessities, and the average home or office users of Calc might not miss them, assuming they are aware of them at all.
Users will always have features that they can't live without. Some, too, will be tempted, based on changes in feature's names and positions, to assume that the features of one app doesn't exist in its equivalent.
However, a close comparison of LibreOffice's and MSO's presentation and spreadsheet apps suggests that the differences are steadily diminishing, especially for average users. If Excel offers more than Calc, the victory is more a technical than a practical one.
Admittedly, PowerPoint still outperforms Impress, yet not by such an extent that the difference couldn't be overcome in a release or two. In fact, the lack of improvements in Impress over the last few years -- particularly in its audio capabilities -- suggests that for most users the deficiencies are unimportant.
LibreOffice boasts a superior word processor to Microsoft Office, a spread sheet that is a close second to its MSO equivalent and an inferior but adequate slide show app. This record has room for improvement, but it's enough to prove LibreOffice is a serious match for MSO.
If you insist otherwise, you might want to do some self-evaluation and ask yourself if you are seeing what you expect rather than what is actually there.