Ask Your Question

How to make one cell equal another in Calc?

asked 2017-04-14 23:03:29 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am going crazy right now. I am trying to enter a value in one cell and have it show up in other cells elsewhere in the sheet. Should be a really simple task but I'm screwing something up somehow.

For example, I enter a value in A1. I want the same value to then show up in cells A2 and A3. I thought I should just put =A1 in those other cells - always used to work - but now those cells just say "=A1" rather than the value I entered into A1. Do I have a setting wrong somewhere?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-04-14 23:09:38 +0200

Lupp gravatar image

updated 2017-04-14 23:10:03 +0200

Two possibilities I can see:
1) You enabled 'Formula' under
'Tools'>'Options'>'LibreOffice Calc'>'View'>'Display'
2) All the cells you entered =A1 in are set to the fake 'Numbers' format 'Text' , code: @.

edit flag offensive delete link more


It was the second one. Thank you so much!

lchristianp gravatar imagelchristianp ( 2017-04-16 05:06:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-14 23:03:29 +0200

Seen: 276 times

Last updated: Apr 14 '17