Ask Your Question

When referencing another sheet in calc the result is simply the formula [closed]

asked 2015-03-20 16:54:49 +0100

FranciThat gravatar image

updated 2020-08-17 22:06:39 +0100

Alex Kemp gravatar image

Whin I type an equal sign in a cell in Calc (LO and then click on the cell in another sheet (same workbook) the result is not what is in the referenced cell but rather the formula itself. (i.e. =Sheet1.K2) The format of both cells is text. Am I doing something wrong? Is there another/better way to do this?

I am running Linux (Kubuntu 1404), English

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-17 22:07:16.108258

1 Answer

Sort by » oldest newest most voted

answered 2015-03-20 17:34:28 +0100

m.a.riosv gravatar image

Yes don't set up format cell as text.

It's useful if you want enter numbers, dates or formulas as text, what this format forces, I think the main reason for this format.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-03-20 16:54:49 +0100

Seen: 21 times

Last updated: Mar 20 '15