Google Blogoscoped

Forum

Google docs Easter egg hunt  (View post)

Achille [PersonRank 2]

Wednesday, December 3, 2008
11 years ago6,342 views

From an email I received:
=====
After fixing loads of bugs in this most recent release, one of our
engineers needed a change of pace and spent a lunch break doing
something festive and fun. He created a tiny "easter egg " in our
product, just for the holiday season and just for you. See if you can
find it!

We'll give you one hint: it's a function. If you think you know which
one were are talking about, submit your answer through this form:
=====

I've tried guessing, but ran out of guesses, I'm not terribly good
with spreadsheets but I'm writing some python code to generate
a spreadsheet with all possible =function() combinations...
whch I can then hopefully concat in one. I'm assuming the
function has no parameter something like PI() ... but I have not
decided how to concat all the combinations together.

Anyone got any ideas? Shoot me a tip here:
> spreadsheets.google.com/ccc?ke ...

Achille [PersonRank 2]

11 years ago #

Here's the 'official' announcement on the Google docs google group page: groups.google.com/group/GDSupd ...

David Mulder [PersonRank 10]

11 years ago #

A pity its not a javascript version of =game() and =game("StarWars") (openoffice.org)

WebSonic.nl [PersonRank 10]

11 years ago #

Did anyone find it already?

Tony Ruscoe [PersonRank 10]

11 years ago #

Has nobody found this yet?

Tony Ruscoe [PersonRank 10]

11 years ago #

Ah, after spending another 5 minutes on this I just found it!

James Xuan [PersonRank 10]

11 years ago #

Really? Wow!

Did you submit your answer?

I tried looking but I don't use Spreadsheets that much, so I gave up after a few minutes.

Anyway Good Luck in the Competition!

And hopefully soon you can reveal to us all what it is!

Tony Ruscoe [PersonRank 10]

11 years ago #

Yeah, I've submitted my answer. It's not very exciting to be honest!

I've searched for the answer (now that I know it) and can't seem to find anyone discussing it anywhere online, so for all I know I might even be the first to have found it!

I've asked about this in their new help forums:
google.com/support/forum/p/Goo ...

TOMHTML [PersonRank 10]

11 years ago #

It seems you're still the only guy who have found it, congratz.

Tony Ruscoe [PersonRank 10]

11 years ago #

Well I've still had no confirmation from Google yet. Maybe I should submit it again another 14 times... ;-)

James Xuan [PersonRank 10]

11 years ago #

I'll submit it for you! (Under my name :P)

Jérôme Flipo [PersonRank 10]

11 years ago #

Winner: Tony Ruscoe
Answer: GoogleHoliday()
Source: google.com/support/forum/p/Goo ...

Congrats Tony!

James Xuan [PersonRank 10]

11 years ago #

Congrats Dude!

Above 13 comments were made in the forum before this was blogged,

TBolt [PersonRank 1]

11 years ago #

I pasted =GoogleHoliday() into a cell, and all it returns is "Happy Holidays".
Is that really all there is? lol. Or, do I have to change the cell format from the default?

Congrats anyway.

Hebbet [PersonRank 10]

11 years ago #

Congrats Tony :)

Mrrix32 [PersonRank 10]

11 years ago #

How did I miss that? :P
Congratulations!

TOMHTML [PersonRank 10]

11 years ago #

Congratulations Tony! :)

Tony Ruscoe [PersonRank 10]

11 years ago #

> Is that really all there is? lol. Or, do I have to change the cell
> format from the default?

It displays "Happy Holidays" and links the cell to this festive "Collaborative Spreadsheet Art" video on YouTube:

+ Show video

photoactive [PersonRank 10]

11 years ago #

Brilliant! Your discovery, I mean, not the Easter egg itself . . . But how did you find it in five minutes????

Tony Ruscoe [PersonRank 10]

11 years ago #

But how did you find it in five minutes????

Pure guesswork. I tried for about 30 minutes first with stupid guesses like MakeSnow(), BuildSnowman() and ChristmasTree(). Then a couple of days later, after I posted above saying "Has nobody found this yet?" I tried again. This time, I figured the function name would probably start with "Google" otherwise it could conflict with other standard functions. I just tried things like:

GoogleXmas()
GoogleChristmas()
GoogleWinter()
GoogleSnow()
GoogleSnowman()
GoogleHolidays()

and, finally

GoogleHoliday()

Stephen Tordoff [PersonRank 10]

11 years ago #

'More grunt, less elegance' :p

Nice work Tony, Congratulations

This thread is locked as it's old... but you can create a new thread in the forum. 

Forum home

Advertisement

 
Blog  |  Forum     more >> Archive | Feed | Google's blogs | About
Advertisement

 

This site unofficially covers Google™ and more with some rights reserved. Join our forum!