We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Cells not being calculated [closed]

asked 2018-02-08 23:07:35 +0200

moon gravatar image

updated 2021-05-23 01:20:18 +0200

Alex Kemp gravatar image

Hi there,

I'm facing a strange problem as after upgrading to version 6 (even if I can't tell if it's the reason), the cells that use to be calculated are now just static. The display is correct as soon as I dont edit it. If I make any change then no result, only the formula is displayed. Knowing of course that all is set to "AutoCalculate F9" and the option is NOT at "Display Formulas" in the options. Struggling !

All help appreciated. Best

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-10-29 20:40:06.900419


Just a little input. When copy/pasting in another cell it works fine ! Is that because of any specifics that cells gets from the various manipulations ?

moon gravatar imagemoon ( 2018-02-08 23:18:59 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-02-09 00:38:46 +0200

erAck gravatar image

no result, only the formula is displayed

sounds like you enter the formula in a cell that is formatted to type Text. Menu Format -> Cells (or Ctrl+1) and then tab page Numbers, apply General. Then edit the formula string, for example append and delete a space and Enter.

edit flag offensive delete link more

answered 2018-02-09 00:59:33 +0200

moon gravatar image

Thanks erAck. Appreciated. I thought basically that the "equal" sign to enter a function will overload the field. Looks like I was totally wrong. I'll put this question as answered correctly. M

edit flag offensive delete link more


A cell of type Text preserves any input as literal text, not changing cell type or number format. For comments please use add a comment instead of creating another answer that is not an answer.. ;-) Also please mark the correct answer as correct by clicking on the check mark and vote it up. Thanks.

erAck gravatar imageerAck ( 2018-02-09 01:07:18 +0200 )edit

@moon: Click on the checkmark next to the start of the accepted answer. Other users searching for a ready-made answer to their similar question will get that information. To close the question is not really helpful.
Expecting your conscious decision I will reopen the question now.

Lupp gravatar imageLupp ( 2018-02-09 11:49:42 +0200 )edit

Question Tools

1 follower


Asked: 2018-02-08 23:07:35 +0200

Seen: 83 times

Last updated: Feb 09 '18