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 <madd...@madduck.net> wrote: > also sprach Tom Davies <tomc...@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.bo...@madduck.net > -- To unsubscribe e-mail to: users+unsubscr...@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