[libreoffice-users] Can I lock a row so it doesn't move when scrolling?
Can I lock a row in spread sheet so it doesn't move out of view when I scroll down in long documents. I can do this in Excel but I haven't been able to find a way to do this in LibreOffice Calc. I have set up the first row in the spread sheet as a column titles row and I have over a 150 lines in the spread sheet. I would like that first row to remain in view as I scroll down the rows. Hope that makes sense. If there is a better way to set up column headers I welcome tips and tricks. -- StevenD So you want it fast, good, and cheap. Choose any two. A bad day at the beach is better than a good day at work. -- For unsubscribe instructions e-mail to: users+h...@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] Can I lock a row so it doesn't move when scrolling?
Thanks everyone for the input. If I had spend more time poking around I might have checked the Window menu. As a novice I wasn't expecting to go to that menu since I was working with cells and rows I was expecting to go to format or cell properties. Come to think of it I had to poke around Excel some time ago to figure out how to do this. And since I don't work with spread sheet much I forgot where to poke around. Anyway I hope I can remember for future reference. Thanks so much for the help. I hit reply to all. If that is not what I should do in the future please let me know. StevenD On Fri, Nov 23, 2012 at 10:40 AM, Jay Lozier jsloz...@gmail.com wrote: On 11/23/2012 12:18 PM, Steven Dayton wrote: Can I lock a row in spread sheet so it doesn't move out of view when I scroll down in long documents. I can do this in Excel but I haven't been able to find a way to do this in LibreOffice Calc. I have set up the first row in the spread sheet as a column titles row and I have over a 150 lines in the spread sheet. I would like that first row to remain in view as I scroll down the rows. Hope that makes sense. If there is a better way to set up column headers I welcome tips and tricks. Steve Yes, after selecting the columns or rows to be included then under Window select Freeze -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- StevenD So you want it fast, good, and cheap. Choose any two. A bad day at the beach is better than a good day at work. -- For unsubscribe instructions e-mail to: users+h...@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] Success
I just had to say that the find/change feature in Libre Office and macros work great. In fact the thing I tried to do in Word 2007 didn't work near as well. Now I'm not knocking Word because I like it alot. I have some text documents where I need to extract some segment numbers from and I am able to do it cleanly and very fast using a couple of find/change operations in a single macro. So the everything is striped out leaving just the 3 digit number separated by commas. The whole operation of setting the macro up was faster in Libre Office and it seems there are more regex option available than I was able to find in Word. Anyway the bottom line is I am pleased. I have moved MS Office off my laptop to the computer downstairs at home and am running Libre Office on my laptop. I'm liking it. -- StevenD So you want it fast, good, and cheap. Choose any two. A bad day at the beach is better than a good day at work. -- For unsubscribe instructions e-mail to: users+h...@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] Cannot find the record macro feature
I installed Libre Office recently and today I am working on learning about Macros. I want to record a macro and the direction in Help say to go to Tools Macros Record Macro but I get no Record Macro option that appears in the Macros menu. I am working with LibreOffice 3.4.3 (OOO340m1 (Build:302)) on my Windows 7 laptop. sd -- For unsubscribe instructions e-mail to: users+h...@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
