[libreoffice-users] Calc, paste special, transpose and link
Hello and a happy new year Calc, paste special, transpose and link I've done this before but can't get it to work again - I'm blaming the brain cells In one spreadsheet I select a range of vertical cells and copy In the second spreadsheet I right click a cell go paste special and select paste all, transpose, link (all selections then go grey) Click ok and the cells are pasted vertical *not horizontal* as required I've done it before ?? But I'm doing a bit of head scratching now Can anyone help - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407.html Sent from the Users mailing list archive at Nabble.com. -- 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
[libreoffice-users] Re: Calc, paste special, transpose and link
On 01-01-2014 12:22, IGraham wrote: Hello and a happy new year Calc, paste special, transpose and link I've done this before but can't get it to work again - I'm blaming the brain cells In one spreadsheet I select a range of vertical cells and copy In the second spreadsheet I right click a cell go paste special and select paste all, transpose, link (all selections then go grey) It seems that, because of this gey, all functions, including the 'transpose' do not work.. Click ok and the cells are pasted vertical *not horizontal* as required I've done it before ?? But I'm doing a bit of head scratching now Can anyone help This works the same as in Office2013, where it is also not possible to 'transpose' and 'link' together. -- 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
Re: [libreoffice-users] libreoffice writer freezes in ubunt 12.04
I just add MATE to Ubuntu, using the instructions on MATE's download/install pages. Takes a few commands in Terminal, but the downloading and install of them can take some time, depending on the connection speed and the speed of the computer. I hate Unity, but I sometimes log into that DE instead of MATE, but rarely now. In a few months Ubuntu 14.04LTS will be out. Then I will be doing a new install of everything instead of a upgrade cycle to 14.04LTS from 12.04LTS. It works better in the long run to do the clean install, as long as you have a good set of backup files. I have 3 drives internal and 3 more as USB backups. So it matches and will be easy[er] than the last time I switched LTS versions. On 12/31/2013 04:00 PM, Tom Davies wrote: Hi :) Blimey!! That sounds quite extreme!! 'Just' uninstalling the DE is quite a major undertaking isn't it? Switching to a new one and leaving the existing one intact is fairly easy but i guess that wouldn't have solved it. Huge congrats on solving that!!! :) Regards from Tom :) On 31 December 2013 20:38, Bala subramanian bala.biophys...@gmail.com wrote: Hi all, Thank you all for your inputs. I could solve the problem just by installing gnome-desktop. I tried re-installing libreoffice. With ubuntu unity, ubuntu 2D. The problem persists. I installed gnome-desktop and now i am able to use the office or highlighting or font changes without any problem. I could conclude that it is the problem with the desktop (for a reason that i dnt understand) and not the libreoffice. Bala On Tue, Dec 31, 2013 at 8:18 PM, M Henri Day mhenri...@gmail.com wrote: 2013/12/31 Don C. Myers donmy...@myersfarm.com Hi, I have no problems with LibreOffice 4.1.4.2 in Ubuntu 13.10 on several different computers.I use the version from The document foundation, and not from Ubuntu. If you are using the Ubuntu version and wish to try The Document Foundation version, you must purge your system of all of the Ubuntu version. Instructions can be found here: http://askubuntu.com/questions/180403/how-to-uninstall-libreoffice Don On 12/31/2013 12:43 PM, tk wrote: Bala subramanian wrote: I am using libreoffice Version: 4.1.4.2 in ubuntu 12.04. I am able to Known bug in Ubuntu 12.04. AFAIK, the only work around is to use a different distro. Specifically a distro that nebver came close to Ubuntu, as its base.(That rules out Mint, which exhibits the same bug, albeit far less frequently.) jonathon Don, I can - and probably should - mention that I'm running 1:4.1.4~rc2-0ubuntu1~saucy1~ppa1, i e, the Ubuntu version installed via the PPA on my machine, without experiencing the difficulties described by Bala on Ubuntu 12.04 Henri -- 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 -- C. Balasubramanian -- 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 -- 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
Re: [libreoffice-users] Calc, paste special, transpose and link
On 2014-01-01 06:22, IGraham wrote: Hello and a happy new year Calc, paste special, transpose and link I've done this before but can't get it to work again - I'm blaming the brain cells In one spreadsheet I select a range of vertical cells and copy In the second spreadsheet I right click a cell go paste special and select paste all, transpose, link (all selections then go grey) Click ok and the cells are pasted vertical *not horizontal* as required I've done it before ?? But I'm doing a bit of head scratching now Can anyone help - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407.html Sent from the Users mailing list archive at Nabble.com. IGraham: Both versions listed below allow paste link transpose at the same time to a new sheet. Vista Home Premium LibreOffice Portable Version: 4.1.4.2 Vista Home Premium LibreOffice RC1 Version: 4.2.0.1 TomW -- 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
Re: [libreoffice-users] Calc, paste special, transpose and link
On 2014-01-01 10:49, TomW wrote: On 2014-01-01 06:22, IGraham wrote: Hello and a happy new year Calc, paste special, transpose and link I've done this before but can't get it to work again - I'm blaming the brain cells In one spreadsheet I select a range of vertical cells and copy In the second spreadsheet I right click a cell go paste special and select paste all, transpose, link (all selections then go grey) Click ok and the cells are pasted vertical *not horizontal* as required I've done it before ?? But I'm doing a bit of head scratching now Can anyone help - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407.html Sent from the Users mailing list archive at Nabble.com. IGraham: Both versions listed below allow paste link transpose at the same time to a new sheet. Vista Home Premium LibreOffice Portable Version: 4.1.4.2 Vista Home Premium LibreOffice RC1 Version: 4.2.0.1 Tom Upon rereading the e-mail, I had used paste special | link transpose to a new sheet within the same workbook. Trying to perform this operation to a new workbook gives me a #502 error (invalid argument??) on both versions. TomW -- 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
[libreoffice-users] File
I have a file which I would like someone to look at to let me know what the problem is. My question is who can I send it to? It's a CALC file. Thanks Angelo R DeJesus -- 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
Re: [libreoffice-users] File
On 01/01/2014 01:10 PM, Angelo R DeJesus wrote: I have a file which I would like someone to look at to let me know what the problem is. My question is who can I send it to? It's a CALC file. Thanks Angelo R DeJesus Angelo If the file does have any confidential information you can post it on Nabble and post a link on the user page. Please do not post confidential information because it will become public. Do you have a specific error message? Also, please advise the LO version you are using and your OS. This information will help us pin down the problem. I can look at the file if you send it to me off-list. -- Jay Lozier jsloz...@gmail.com -- 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
Re: [libreoffice-users] File
On Wed, Jan 01, 2014 at 02:10:57PM -0400, Angelo R DeJesus wrote: I have a file which I would like someone to look at to let me know what the problem is. My question is who can I send it to? It's a CALC file. Thanks How about describing your problem? -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279 -- 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
Re: [libreoffice-users] File
Someone is looking into it thanks all Angelo R DeJesus On Jan 1, 2014, at 4:54 PM, Robert Holtzman hol...@cox.net wrote: On Wed, Jan 01, 2014 at 02:10:57PM -0400, Angelo R DeJesus wrote: I have a file which I would like someone to look at to let me know what the problem is. My question is who can I send it to? It's a CALC file. Thanks How about describing your problem? -- Bob Holtzman Your mail is being read by tight lipped NSA agents who fail to see humor in Doctor Strangelove Key ID 8D549279 -- 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 -- 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
[libreoffice-users] Re: Calc, paste special, transpose and link
How i managed to do it before I've no idea ? - the brain cells must be even more diminished than i thought however this worked =TRANSPOSE(the cells) then press SHIFT CONTROL ENTER thanks for looking at the problem people and apologies for distracting you from your new year celebrations - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407p4090468.html Sent from the Users mailing list archive at Nabble.com. -- 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
Re: [libreoffice-users] Happy 2014 and Calendar
Hi :) Thanks for the best wishes! The calendar has been translated into Greek by Kostis Mousafiris: * https://db.tt/gLtodcDX * https://db.tt/bRANY7EW * https://db.tt/5EVfyuxw Eliane created another version with Sunday as the 1st day of the week for the US: * ODG file: https://owncloud.documentfoundation.org/public.php?service=filest=d2962eac004c6066ab45a6463391fdf1 * PDF file: https://owncloud.documentfoundation.org/public.php?service=filest=131f422910ea8dddcc429393ea4552a6 Regards from Tom :) On 1 January 2014 01:46, RODRIGUEZ FONSECA JORGE ALBERTO jrodrigue...@cpcecr.com wrote: Happy New Year Tom ... thanks for all your support in this years and thank you too for all in this e-mail list with your help ! Regards, Jorge Rodríguez - Mensaje original - De: Tom Davies tomc...@gmail.com Para: users@global.libreoffice.org Users@Global.LibreOffice.Org, documentat...@global.libreoffice.org documentat...@global.libreoffice.org, accessibil...@global.libreoffice.org accessibil...@global.libreoffice.org CC: Eliane Domingos de Sousa elianedomin...@libreoffice.org Enviados: Martes, 31 de Diciembre 2013 14:57:15 Asunto: [libreoffice-users] Happy 2014 and Calendar Hi :) I'm guessing quite a lot of you are already well into 2014 (or whichever year number you have recently moved into) but for those of us who aren't yet, here is another message of good-will from Eliane and i guess it does go for everyone who is already in their new year already too. Happy New Year all, especially each of you :D Regards from Tom :) On 30 December 2013 20:59, Eliane Domingos de Sousa elianedomin...@libreoffice.org wrote: Dear Community, I would like to wish you all a magnific and splendid new year! 2014 is coming and it's time to celebrate. I offer for you this simple card and calendar: Card: https://owncloud.documentfoundation.org/public.php?service=filest=2411f4e6c737a523e639dd01750b8113 Calendar: https://owncloud.documentfoundation.org/public.php?service=filest=df37a6b4294ff4ff0a0a686f71731fe3 I'm sharing the source file and feel free to use. Card: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=89566bb10ea5269d2082b03f8e080367 Calendar: SVG file: https://owncloud.documentfoundation.org/public.php?service=filest=fb01a48e1f06ceceac91d831664d6c77 Best, -- Eliane Domingos de Sousa Comunidade LibreOffice Brasil Brazilian LibreOffice Community Liberte-se, para editar textos, planilhas e apresentações usehttp://pt-br.libreoffice.org/ é totalmente de graça. Experimente o sistema de perguntas e respostas da Comunidade LibreOffice Brasil:http://ask.libreoffice.org/pt-br/questions/ -- 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 -- 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
[libreoffice-users] Re: Calc, paste special, transpose and link
El 2014-01-01 04:42 p.m., IGraham escribió:
How i managed to do it before I've no idea ? - the brain cells must be even
more diminished than i thought
however this worked
=TRANSPOSE(the cells) then press SHIFT CONTROL ENTER
thanks for looking at the problem people and apologies for distracting you
from your new year celebrations
-
IGraham
W764 LibreOffice 4.1.0.4
--
View this message in context:
http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407p4090468.html
Sent from the Users mailing list archive at Nabble.com.
I didn't know of TRANSPOSE. I used it *without* Ctrl+Shift+Enter and it
transposed the complete matrix and automatically included { and }.
--
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
