MyAnswers: OpenOffice.org Calc/Excel
Professional I.T. solutions at affordable prices.
From the creator and maintainer of the Australian English
spellcheck dictionaries now used by over half a million Australians.

NOTE: Only JustLocal advertisers can purchase MyAnswers solutions on the JustLocal page.
All other solutions are available to everyone.

(See the MyAnswers main page for more information.)

TIP: Use Control+F to search page.
Click on the item number to request solution.

Click link
to request

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

1600

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

4244

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

1486

795

Justification in Calc cells differs from Excel cells

22/08/05

801

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

486

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

370

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

364

551

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

22/08/05

149

549

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

22/08/05

1929

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

546

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

601

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

387

128

How do I move a single cell in Calc?

22/08/05

1172

Please read the conditions of use
Copyright © 2002-2006 – Online Connections
A JustLocal™ advertiser