QUESTION : I would like to write the formula (in OpenOffice, but I imagine it won’t be any different than […]

# Tag: openoffice-calc

## Repeat rows at top of printed page

QUESTION : In Excel, under Page Setup, there is an option for “Print Titles”, where you can specify a number […]

## Database access through odbc driver and excel

QUESTION : Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then […]

## Excel or open office calc how to remove last white space? [closed]

QUESTION : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]

## How to subtract (compute delta) between two sheets?

QUESTION : I have two snapshots of data in big tables on two different sheets. Basically the sheets have identical […]

## Spreadsheet- How to update the value of the same cell

QUESTION : I want to update the value of a the cell based on the current value of that cell […]

## Advanced spreadsheet auto-formatting

QUESTION : Is it possible to autoformat spreadsheet like this IF A1 = C1 then A1:E1 cells background becomes light […]

## How can I open a subset of a large (35MB) .xlsx file?

QUESTION : I have Ubuntu 10.04 running on a Dell Optiplex with 4GB of memory and two 3.16GHz processors. I […]

## Are there nonlinear optimization implementation for OpenOffice Calc?

QUESTION : Are there nonlinear optimization implementation for OpenOffice Calc? I found one: http://extensions.services.openoffice.org/project/NLPSolver . But the methods provided there […]

## What is the least-error-prone way to share CSV data?

QUESTION : One of my jobs is to upload product data to the company store. The data is initially pulled […]