[Live-demo] Translation planning doc - misaligned column "notes for off-line translation"

[Cameron Shorter]

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
> Live-demo at lists.osgeo.org
> 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