![]() Only absolute references to the source (a serious flaw). Excel 2003 knew how to work with dynamic ranges (using the OFFSET function), and Calc still does not know how, if we are talking about using pivot tables or expanding charts. This means that we are at the level of Excel 2003 in this sense. Feel the difference between the terms Insert and Add. You still have to get used to inserting new rows/columns correctly, and not just adding them by filling data in new rows below or columns to the right. Click on the cross in the lower right corner of the cell. The formula itself, of course, won’t fill down the rows. ![]() Gordon Guthrie loves spreadsheets so much he has written his own one – Vixo, like spreadsheets but better, which you can explore at just want to edit the first row and have Calc automatically update the rest.įorget. need a lot of VBA/macros in your spreadsheets.share a lot of complex spreadsheets with business partners who use Excel.have a large suite of existing Excel spreadsheets which are business critical.LibreOffice might not be suitable if you: want a spreadsheet that runs on Windows, Mac's and Linux.LibreOffice assumes you want to save as HTML to publish something and you wont be opening it back up in LibreOffice – so its HTML is quite lean and sparse and manageable – so if you need to bodge it into your blog it is a lot easier to do. This means it produces very verbose HTML output with lots of classes and formatting and other gumph. Microsoft's strategy with export to HTML is to try and make a good two way process – you can write as HTML and read it back in. Sometimes you just need to publish some figures in your WordPress blog. There are tools that let you do this in Excel but it is a faff to find them, install them and make sure they do a good job. The second is that you can export to a PDF natively. Sometimes you just want to zoom out to see the structure of the worksheet to find a cell before zooming back in to where you working – this makes it a cinch. The first is that zoom is built into the spreadsheet frame in the bottom right hand corner: While LibreOffice has modelled Calc on Excel there are a few features that are unique to Calc. ![]() Only a tiny fraction of spreadsheets use Macros but these spreadsheets tend to be important for big companies and also tend to have a lot of time and effort invested in them. Microsoft's major source of revenue from Excel comes from corporate licensing. To make the scripting language compatible you have to copy the internals of the other programme as well. To open ordinary spreadsheet files you only have to copy the 'surface' of the other spreadsheet. The team at Microsoft were determined not to let anyone steal the crown from them – and Visual Basic was the mechanism they settled on. Microsoft won the spreadsheet market from Lotus-1-2-3 by ensuring the Excel could open 1-2-3 files and do everything 1-2-3 could do. 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.
0 Comments
Leave a Reply. |