Number

Question

Date
(dd/mm/yy)

Length

1031

I open an Excel spreadsheet from another user using Calc. When I print the single page document the top part is in the unprintable region of the printer and is missing. It works under Excel but not Calc.

22/08/05

1707

959

By default Calc rounds numbers to two decimal places if you enter more than two decimals in a number. This answer shows you what to do to stop that happening.

22/08/05

4468

819

We currently provide a product using Excel. We would like to provide the product in OpenOffice.org Calc as well. What do we need to consider?

22/08/05

1570

795

Justification in Calc cells differs from Excel cells

22/08/05

859

567

In Excel I can double click on the square in the bottom right hand corner to copy the formula into all the cells below. How is this done in Calc?

22/08/05

514

565

In Excel I can centre text in a cell and it overlaps surrounding unused cells. In Calc it just appears left justified. How do I get the same effect as Excel?

22/08/05

405

561

In Page Preview mode I can't adjust the margins like I can in Excel using the mouse. How do I do this in Calc?

22/08/05

385

551

I have an Excel spreadsheet and in Calc only part of it is printing.

22/08/05

171

549

I like using the Format Painter in Excel. Is there an equivalent in Calc?

22/08/05

2138

264

I like the keyboard short cuts Control++ and Control+- in Excel. These don't exist in Calc.  These work really well combined with Control-space and Shift-space

22/08/05

622

237

Calc has a 32000 row limit. I have an Excel spreadsheet with 50000 rows. Is there a way to get around this limit?

22/08/05

641

194

How do I put a return or new line in the middle of text in a cell in a Calc spreadsheet?

22/08/05

413

128

How do I move a single cell in Calc?

22/08/05

1259