We'd like to remind Forumites to please avoid political debate on the Forum... Read More » This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Openoffice

pollyanna24 · 2007-01-12 13:30:33

I have downloaded this free from the net and use it for my budgeting spreadsheet. I am quite proficient and it works well for me, but is there a formula for transferring the sum of one cell onto another page within the same document, i.e. I have one page which states our incomings, then on another page this sum is used to…

Options

Comments

kingmonkey Posts: 846 Forumite

17 January 2007 at 1:16PM

Blagalot wrote:

Have you tried entering '=' in the cell on Sheet 1 then clicking the cell on Sheet 2 and pressing enter. Works in Excel so should be the same in OpenOffice.

I use oo almost daily. And this is the method I use.

If you want more control then copy the cell then go to the cell you want to paste to and right click and go to paste special. You can then choose if you want to paste the formula, the reference or just the plain string result.

0

This discussion has been closed.

★ ★ ★ Meet your Ambassadors

Confirm your email address to Create Threads and Reply

MSE News

British Airways passenger? Book and travel using your old Covid vouchers NOW – or lose them
If you had a British Airways (BA) flight or holiday disrupted by the Covid-19 pandemic, check if you've got an old voucher as millions of pounds' worth are still unclaimed. You'll need to use it to travel before the end of September 2025 – or risk losing it. Below we explain how to search for unused vouchers and how to use them.

View All

Openoffice

Comments

Confirm your email address to Create Threads and Reply

🚀 Getting Started

Categories

Is this how you want to be seen?

Get our FREE Weekly email full of deals & guides - and it’s spam-free