0️⃣ The Magic 0-0 that forces empty cells to be ZEROES

TL:DR

In any math column, use 0 - 0 + ... to force empty values to be zeros! Huge thanks to @ThinhDinh for leading me to this solution!

11 Likes

Honestly I still don’t know how this works :rofl:

1 Like

Funny!

By chance I had the same problem on Monday but I fixed it in this way:

image

Feliz día!

3 Likes

So…any sort of 0 math seems to work!

  • 0 - 0 + ...
  • -0 + 0 + ...
  • 0 / 1 + ...
  • 0 * 0 + ...
  • 0 ^ 1 + ...
  • log(1) + ...
4 Likes

Right but the Sum cases don’t work if they are at the end of operation. I mean:

if X=empty:

a)  0-0 +X   =>  0 
b)  X+ 0-0   =>  empty

The others work perfectly no matter where you put them.

Saludos!

This is … eerie?! Is Mark aware of this? It’s like there is a ghost in his code.

I’m not sure at all, but it could be that the ‘0’ symbol represents both “zero” and the “empty set” in the language that’s used in Glide’s backend (Typescript?).

If there is the case, then inserting any math operation whose output is 0 and then adding the empty cell will return the number “0” instead of simply returning the empty set “0” without the math. So 2-2+… would also work I think.

What I don’t understand is why 0+0 or 0-0 at the end of the math would be considered the empty set, but not at the beginning. Coders would probably now. Maybe it’s just the grammar of the language?

3 Likes

This pink text on grey background is somewhat hard to read. Is this new? Could someone adjust this?

@SantiagoPerez @George-Glide

2 Likes

Uh…pink text on grey background?

image

I see this. No biggy, it’s just hard to read.

Agree that it’s not good. Fine on dark mode though.

1 Like

Oh weird. I see that too…on my phone it looks different.