Spreadsheet[+]
- 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:
- Select the full column,
- Right click and choose "Conditional formatting..."
- Switch to the "Custom formula" option in the drop-down menu.
- Add in the relevant formula, rules (background red), and cell range. The formula could be "=A1==len(7)"
- Click Save rules.
Crear listas de correo en Google Apps (o usuarios con sólo cuenta de correo).[+]
- Crear el grupo en Google Apps
- editar el alias en /etc/aliases y actualizar la base de datos de alias con
Javascripts with the Google API[+]Inserting Multiple Rows in Google Docs – Spreadsheet[+]
From: here :
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.
|