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.
![[toggle]](javascript:icntoggle('mod-GFIFl0','module.png'); "[toggle]"){kind=small}
![[Toggle Vertically]](javascript:flip_class('main','minimize-modules-left','maximize-modules');icntoggle('modv-GFIFl0','vmodule.png'); "[Toggle Vertically]"){kind=small}
![[toggle]](javascript:icntoggle('mod-ApplicationMenul1','module.png'); "[toggle]"){kind=small}
![[Toggle Vertically]](javascript:flip_class('main','minimize-modules-left','maximize-modules');icntoggle('modv-ApplicationMenul1','vmodule.png'); "[Toggle Vertically]"){kind=small}
Wiki
