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
