Apache OpenOffice's Calc application contains a handy feature for restructuring spreadsheet tables or data lists. Hidden in Calc's Paste Special option, the Transpose feature enables you to convert ...

Like other OpenOffice.org applications, Calc has several dozen options in how it is formatted and operates. These options are available from Tools -> Options -> OpenOffice.org Calc. Thanks to ...

Located at the top of each column in your OpenOffice Calc spreadsheet are the letters of the alphabet. These headings differentiate between the columns, and allow you to sort and manipulate the data ...

For novices, functions are one of the most intimidating features of OpenOffice.org's Calc. Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, ...