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

also sprach Tom Davies <tomcecf@gmail.com> [2014-09-19 12:37 +0200]:
> I'm not completely sure why you are trying to do this.  Context could be
> useful.

I have a table with assumptions about conference days in a budget,
and the days are in columns left-to-right.

In the overview, I need the days to appear top-to-bottom. It's
*painful* to do this by hand.

> Edit - "Paste Special" - tick the "transpose" box

This does almost what I want, except it copies values, and it does
not insert references.

> If you extend that idea so that
> B2 = B1
> C2 = C1
> D2 = D1
> E2 = E1
> and then select B2-E2, cut (or copy), click in A2 and then do
> Edit - PasteSpecial - transpose
> then
> A2 = B1
> A3 = C1
> A4 = D1
> A5 = E1

Right, except I would like A2 to be '=B2' and A3 to be '=C2' etc.

Does this make sense?

-- 
@martinkrafft | http://madduck.net/ | http://two.sentenc.es/
 
"i might disagree with what you have to say,
 but I'll defend to the death your right to say it."
                                                           -- voltaire
 
spamtraps: madduck.bogus@madduck.net

-- 
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