OpenOffice.org Calc

OpenOffice.org Calc is the Tableur integrated after free office automation OpenOffice.org, comparable with the spreadsheet Excel.

Functionalities

In Calc 1.x, the number of lines was limited to 32000, but in Calc 2.0 this number increases to 65536 what puts it at the same level that Excel and thus increases its compatibility. Indeed, in the version 1.x, the files exceeding the limit of the 32000 lines are quite simply truncated, which involves problematic losses of information, in particular in professional environment.

The functions of graphics package associated with the spreadsheet are simple and do not require so to speak reading of documentation. Only the cells which are not masked in the worksheet are taken into account for the diagram, which makes it possible to work conveniently, for example, to measures slipping by fortnights. The functions of linear Regression exist out of standard in the graphic menu.

Although its function Pilote of data (equivalent of the dynamic cross Table of Excel) is in on this side spreadsheet of Microsoft, Calc to a more advanced function Sous-total .

The update of the formulas is particularly facilitated in Calc by an automatic association of colors to the elements of the formula associated with a discrete indication in the corresponding color with each cell or groups cells associated (see figure). That constitutes a good means also of documenting its worksheets.

The developers also thought of a Easter egg, which launches a play Star Wars if you type =GAME (" StarWars")

Format of file

OOo Calc works out of standard with the format sxc (XML) or the format ods (format OASIS) also in XML. It can import and to export data with the formats Microsoft Excel (xls), DBASE (dbf), Data Interchange Format (dif), Hypertext markup language (HTML), or text ASCII (txt). It also makes it possible to export with the format Portable document format (pdf) without requiring of conversion program of the trade.

However, its macros being rather distant from those of Excel, it is necessary to think of a quasi complete rewriting of the code if one wants to be essential of it since another format of file that the format sxc or ods.

Examples of use

External bonds

  • Site of the Community OpenOffice.org
  • Tutoriels and models for OpenOffice Calc as well as a space of mutual aid
  • the Calc spreadsheet for the example

See too

Random links:Brigades of the Swords of the right | Great days of Auvergne | Pascal Rebetez | Walt Disney Music Company | Triton (comics) | Thoughtcrime