Ask Your Question

How to create a format that shows empty cell regardless of content.

asked 2018-07-02 14:34:14 +0200

akostadinov gravatar image

Hi, I would like to create a format that will show the cell as empty when set.

The use case is that I have a timesheet that has dates filled based on a single field. But I want cells to appear empty when date falls outside current month (for this I write a formula).

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-07-02 14:38:10 +0200

akostadinov gravatar image

The first thing I tried was setting format to the empty string but it didn't work. Then I have set format to "" and this now worked. I didn't know formatting also has quoting. Leaving this here in case anybody else hit this question.

edit flag offensive delete link more

answered 2018-07-02 16:41:17 +0200

erAck gravatar image

Either "" to display an empty string but only for numeric (and date,time,...) data and formula results, or ;;; for four empty subformats that covers also text content and text results. Which is the same as [>0]"";[<0]"";"";"" and loaded as such once saved to .ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-02 14:34:14 +0200

Seen: 41 times

Last updated: Jul 02 '18