It has been expanded from 65 536 to one million. or the rows and columns need to be transposed.

This greatly reduces the number of situations in which a spreadsheet either needs to be split into several ones. Increased number of columns – the standard number in Excel for many years was limited to a maximum of 256 columns – Calc overcomes this limitation, allowing you to create 1024 columns.Sharing spreadsheets with multiple users, while keeping track of changes made by each of them.The extended functionality is aimed at professionals (for example, there is a possibility to do regression equations) as well as at amateurs (numerous charts wizards). More possibilities for creating charts.This functionality is not available in all versions of Microsoft, so it is best to use Calc as an alternative to Excel. Solver – a tool to help you calculate the optimal value for a given calculation.Another reason is the additional functionality that makes it the best choice for many applications. It is one of the most popular programs in OpenOffice because of the great compatibility with the competitive programs. Performs the same functions as Microsoft Excel and Lotus 1-2-3 OpenOffice Writer – text editor Calc Spreadsheet

Openoffice review 2017