

The big compatibility challenge to LibreOffice is macros and Visual Basic for Applications (VBA) – which is hardly surprising if you know the history of Excel.

data tools like filter, sort and subtotal.


Here is a short list of things you will also recognise: It is not surprising that LibreOffice is so familiar – the intention of the project is to allow people to move away from Microsoft Office and so naturally LibreOffice tracks features in Microsoft Office 2003 and copies them. Alternatively, “Print Preview” needs an option to preview just the highlighted cells (probably even simpler, since it would be the same drop-down box already available in the “Print” dialogue.Libre Office Calc - Charting options in Excel compared Other familiar features The programme just meeds to point to those options. It’s exceedingly frustrating, as I have NO desire to use MS Excel.Īnd it isn’t like the code to correct the formatting doesn’t exist it’s right there in the “Print Preview” dialogue. This is the ONE thing where I find MS Excel works far better printing highlighted cells without major hackery (such as just deleting everything else in the file but the specific thing you want to print). However, now the print dialogue gives you NO way to correct the print formatting, and it may cut off the edges of your printout because it will quite happily put cells out behind the margins (where it won’t print). If, however, you highlight the cells, bring up “Print”, you can tell it to print just the highlighted cells. You may highlight a group of cells to be printed, but “Print Preview” ignores this, and therefore you can’t adjust your print settings because it’s showing you a different set of cells to print You say how to make a printout fit on one page, but this presumes the programme has a clue of WHAT you want to do a print preview on. Not a solution, but an additional problem.
