Re: [libreoffice-users] Fill down with a twist

At 13:44 19/09/2014 +0200, Martin F Krafft wrote:
> At 11:37 19/09/2014 +0100, Tom Davies wrote:
> > At 09:01 19/09/2014 +0200, Martin F Krafft wrote:
> > > If a cell A1 contains '=B1' and I fill-down 
> > > from A1 to A3, I get references to B2 and B3 
> > > for the two new cells. Is it possible to fill 
> > > down, but scan right? E.g. make A2 become C1 and A3 become D1?
> >
> > Maybe what you are looking for is something 
> > involving Edit - "Paste Special" - tick the "transpose" box
>
> This does almost what I want, except it copies 
> values, and it does not insert references.

So use Edit | Paste Special... and tick both 
Transpose and Link under Options. Voilà!

Note that your intermediate column copy of your 
data can be out of the way elsewhere on the 
sheet, out of any print range - or even on a separate sheet.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted