📨 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

2»

Comments

  • 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.
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 355.9K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.2K Spending & Discounts
  • 248.4K Work, Benefits & Business
  • 606.1K Mortgages, Homes & Bills
  • 179K Life & Family
  • 263.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.