Autofit a Column Using Selected Cells in OpenOffice Calc

The Autofit feature in Calc and other spreadsheet programs is an extremely helpful feature. You can simply double-click on the right divider line in the column title, and the column will automatically expand to fit the longest piece of data. But what if you don't want to fit the longest piece of data but, instead … Continue reading Autofit a Column Using Selected Cells in OpenOffice Calc

OpenOffice.org Calc: Avoiding the Delete Contents Dialog Box

If you've used OpenOffice.org Calc at all, I know that you've found the Delete Contents dialog box. How could you not? Every time you select a cell or range of cells and try to clear their contents you automatically hit the Delete button and that annoying dialog box appears. Okay, so maybe you like this … Continue reading OpenOffice.org Calc: Avoiding the Delete Contents Dialog Box

Incompatible Formulas in OpenOffice Calc and Excel

OpenOffice.org Calc: Why Are My Formulas Behaving So Badly? If you've used Excel in the past with any regularity, you may find yourself experiencing some difficulty with formulas - whether creating them in Calc or trying to open an Excel file in Calc. While I can't guarantee that I've got the answer to your problems, … Continue reading Incompatible Formulas in OpenOffice Calc and Excel