News for hackers. Stuff that matters.
Re:We're five members of the Google Docs team - ask us anything by orofino on Monday June 13, 2011 @10:10PM (#2651534)
Sad I didn't see this earlier. Would love to see a couple issues addressed in spreadsheets. Namely conditional formatting based on a formula and merging of cells vertically.
Re:We're five members of the Google Docs team - ask us anything by gruseom on Monday June 13, 2011 @11:21PM (#2651682)
What do you like to use conditional formatting for?
Re:We're five members of the Google Docs team - ask us anything by orofino on Tuesday June 14, 2011 @09:33AM (#2652865)
Formatting like this is helpful for things like...

if cell < 0 make entire row red

This isn't currently possible because the conditional can only check the value of THIS cell, not others. As the other comment indicates, it also helps expand what values you can evaluate. I use excel heavily and this is one of the largest gaps between it and google docs for me.

Re:We're five members of the Google Docs team - ask us anything by gruseom on Tuesday June 14, 2011 @11:36AM (#2653432)
I work on this kind of thing (not at Google) and your answer here is helpful. If you'd be up for an offline discussion about other gaps between Excel and web-based spreadsheets, please email me (address in profile).
Re:We're five members of the Google Docs team - ask us anything by Flenser on Tuesday June 14, 2011 @05:27AM (#2652340)
Conditional formatting based on a formula is great for highlighting cells with values that don't make semantic sense.