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

Hi :)
Weird!  I was expecting the last part to work.  Just to check that we are
talking about the same thing - in that last part i meant;

Create (perhaps by inserting a new row 3 temporarily?)

B3 = '=B2'
C3 = '=C2'
D3 = '=D2'
E3 = '=E2'
etc and then select all them, copy and transpose 'into' A2 and onwards.

Does that not work?
Regards from
Tom :)


On 19 September 2014 12:44, martin f krafft <madduck@madduck.net> wrote:

> 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