Oscar,
I'm afraid what you are asking for stretches Google docs beyond the
capabilities of a spreadsheet.
At the moment, the status of the spreadsheet is automatically driven
from doc versions coming from subversion, and doc review status (from
another spreadsheet). The downside of this automation (as you note) is
that line numbers change with each status update, which means your
manually entered information doesn't align.
The workaround which is being used on the "es" worksheet is to copy the
values of the "File" column into a separate column (J). Now the
automatically updated lines will still change, but the static lines will
stay aligned. (Note, by convention, I use BLACK for cells with a formula
and BLUE for cells without a formula).
On 1/08/2012 5:15 PM, Oscar Fonts wrote:
Hi,
Regarding "osgeo_livedvd_trans_planning" spreadsheet, we're using the
K column "notes for off-line translation coordination" for Catalan
translations.
Every time spreadsheet contents are updated, this column becomes
misaligned. With the last changes we can no longer figure out how to
realign it.
Maybe those who master google docs magic (aka Cameron?) could take
this into account for the next time... keeping this column synced
would be much appreciated.
Thanks,
Oscar.
_______________________________________________
Live-demo mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc
--
Cameron Shorter
Geospatial Solutions Manager
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254
Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
http://www.lisasoft.com
_______________________________________________
Live-demo mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc