Google Docs

• SQL query
• Use a formula to apply conditional formatting.
  • Example: Consider the following spreadsheet:

    	A	B
    1	TIPO	DINNER
    2	Plenary
    3	Talk

    In order to automatically fill the background of the cell to red:
  1. Select the full column,
  2. Right click and choose "Conditional formatting..."
  3. Switch to the "Custom formula" option in the drop-down menu.
  4. Add in the relevant formula, rules (background red), and cell range. The formula could be "=A1==len(7)"
  5. Click Save rules.

• Crear el grupo en Google Apps
• editar el alias en /etc/aliases y actualizar la base de datos de alias con

  # newaliases

1. Go to https://script.google.com
2. Follow the tutorials

Google recently upgraded their docs interface and they made big improvements within Google Docs. I have always been comfortable with their word processor, but recently I decided to take the plunge and begin using their spreadsheet doc.

Things seemed to be a bit streamlined and I was okay with the clean, simple interface. My biggest challenge was inserting multiple rows.

Clicking on every menu, right-clicking on single rows, or trying the traditional ctrl + did not do the trick. It is a little cumbersome, but here is how I got around this annoyance:

This what Google gives you by default:

After all my cutting and pasting, I decided to highlight multiple rows, this did not work. What you need to do is highlight the row numbers (headers?) and not the actual rows. Once they are highlighted, right-click on the row numbers column and you will see the menu change, like so:

Although this is a bit clunky, it did resolved my issue of adding one row at a time. I really hope Google brings shortcut support to this little, yet important task.