Ask Your Question

click on cell shows formula, cell appears blank

asked 2019-07-11 12:38:10 +0200

Kagiso gravatar image

updated 2019-07-11 13:40:08 +0200

The cell appears blank on the screen and when printed, however when you click on the cell the formula appears, and the value is used in other cells, how do I make the value visible?C:\fakepath\t2Addendum SASAMS Mark sheet MLIT.xls

The following cells: Grade 10k1 spreadsheet cell: K12; S12; S18; s 27 Grade 11K3 spreadsheet Cell : K38; K39; S27; S 42

edit retag flag offensive close merge delete


Which os and LO-Version do you use?

ebot gravatar imageebot ( 2019-07-11 13:03:19 +0200 )edit

What you describe depends on the formula, the references and may be some formatting. So it might be an expected behaviour and I think there is no way to clarify without an anonymized example and a description of what you would exprect (with respect to the example). Thus please consider to upload an example file using edit you question an the clip symbol.

Opaque gravatar imageOpaque ( 2019-07-11 13:09:27 +0200 )edit

Please also tell which cell to look at. Thanks!

Possibly you mean some cells like AG37 - which are controlled by conditional formatting making font white when value is small.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-11 13:34:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-07-11 15:04:59 +0200

updated 2019-07-11 15:19:47 +0200

Hello @Kagiso, I removed all the conditional formatting and the file went back up and running. except the k12 cell with the wrong formula, which I copied from K11 and pasted into k12, worked.

On the Div / 0 errors use the formula: =IFERROR(your formula;"")

Review the need for Conditional formatting.

Here is the file with the conditional formatting excluded from the worksheets 10K1 and 11K3 and in 10K1 I used the IFERROR formula.


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-11 12:38:10 +0200

Seen: 25 times

Last updated: Jul 11