Re: [libreoffice-users] Search-and-add in Calc
Thank you, Brian. That works perfectly! On Tue, 02 Jan 2018 04:35:46 + Brian Barker wrote: > At 22:41 01/01/2018 -0500, Eddie Noname wrote: > >I have a number of spreadsheets in which one column contains text; > >each cell has different contents. I would like to be able to select > >regions in this column and add a semi-colon to the end of each > >selected cell, without disturbing the rest of the contents. Can this > >be done? > > Yup. Search for .* (that's dot-asterisk) and replace with &; (that's > ampersand-semicolon). In the Find & Replace panel, click More Options > and ensure that both "Current selection only" and "Regular > expressions" are ticked. Click Replace All. > > How does it work? In the "Search for" box, the dot matches any > character and the asterisk extends this to match zero or more of such > characters - in other words, all the text you have in any cell. In > the "Replace with" box, the ampersand represents the original matched > string and the semicolon is the character you want added. > > I trust this helps. > > Brian Barker > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Search-and-add in Calc
At 22:41 01/01/2018 -0500, Eddie Noname wrote: I have a number of spreadsheets in which one column contains text; each cell has different contents. I would like to be able to select regions in this column and add a semi-colon to the end of each selected cell, without disturbing the rest of the contents. Can this be done? Yup. Search for .* (that's dot-asterisk) and replace with &; (that's ampersand-semicolon). In the Find & Replace panel, click More Options and ensure that both "Current selection only" and "Regular expressions" are ticked. Click Replace All. How does it work? In the "Search for" box, the dot matches any character and the asterisk extends this to match zero or more of such characters - in other words, all the text you have in any cell. In the "Replace with" box, the ampersand represents the original matched string and the semicolon is the character you want added. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Search-and-add in Calc
Hi, I have a number of spreadsheets in which one column contains text; each cell has different contents. I would like to be able to select regions in this column and add a semi-colon to the end of each selected cell, without disturbing the rest of the contents. Can this be done? Thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] installed disc usage for LO
And yet somehow, WordPerfect and Lotus 123 only took up 2mb of my 10mb hard disk (that was 1990)... On Jan 1, 2018 8:12 PM, "Tim-L" wrote: > > I hoped that my figure of 896 MB was not out of the norm. > > I know many people might not get why people are concerned with the > installed size of the packages. They figure that you could just add a > larger drive to the laptop or another drive [2nd or 3rd] to the desktop. My > newest laptop came with a 1TB drive. The one I am typing from has 500GB. I > have seen a number of 2TB laptop drives for under $100. I have seen larger, > as well, but between the price and the heat issues, these larger ones may > not be best for low to mid level laptops. Also some people have had trouble > getting a desktop to boot up from a drive larger than 2TB. Desktops uses > one boot disk 2TB or smaller, and then add the 3, 4, or larger data > drives. Not an option for laptops. > > NOW, after that you can see there are limits for laptops for drive size. > > For me, I notice my laptops get down to under 20 GB free very quickly. I > have to have a USB 2TB drive [military grade] on hand to off load data > files so I can continue to do "my thing". Then I have to try to find room > in my data storage desktop for them. Of course, I have an old style PATA > drive for boot and three 2TB drives installed with maybe maybe 100 GB left > between the 4 drives. There is no more room in the case and I had to rig > up a lot of fans to keep it cool enough to work. Of course for whatever > reason it crashes every time I try to install Ubuntu 16.04. OK, that is a > pet peeve. > > Of course, if you grew up before the PC was invented, or before there was > an Internet, you will know how I feel about all these "new technologies" > came out. > > "on the other hand" - I remember having to install Adobe packages and MS > Office on a 50-80 gig hard drives at a computer work area. Of course, how > many of you remember having to install Windows via floppy discs - twelve if > I am correct - on desktops with no CD drive [before I was allowed to add a > temporary CD drive to use for the installs]. > > > > On 01/01/2018 12:08 PM, Remy Gauthier wrote: > >> Hi, >> >> As an FYI, on Fedora 25, the 64-bit version of 5.4.4-2 comes in at >> 879MB (result of the command "dnf erase libreoffice*" for a >> French/English installation with local help in both languages >> installed). Interestingly, LO 5.4.4.2 on my Windows 10 platform (64- >> bit, VmWare WS player 14) uses 550MB of disk space (size reported by >> right click -> Properties on the installation folder in Program Files). >> >> On the other hand, MS-Office on that same Windows platform has a disk >> footprint of slightly over 3 GB. >> >> Happy New Year! >> >> Rémy Gauthier. >> >> >> Le lundi 01 janvier 2018 à 09:41 -0500, Tim-L a écrit : >> >>> I was changing versions of LibreOffice and saw something that I am >>> wondering at. >>> >>> I ran "sudo apt-get remove libreoffice?" and at one point the process >>> asked to continue showing that 896 MB will be freed. >>> >>> This was the 64 bit DEB version of 5.3.6. >>> >>> Since I was not "purging" LO, I thought that figure was a little high, >>> but this was the first time I looked at the space being freed up before >>> installing the next version. >>> >>> >>> >>> >>> > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un > subscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] installed disc usage for LO
I hoped that my figure of 896 MB was not out of the norm. I know many people might not get why people are concerned with the installed size of the packages. They figure that you could just add a larger drive to the laptop or another drive [2nd or 3rd] to the desktop. My newest laptop came with a 1TB drive. The one I am typing from has 500GB. I have seen a number of 2TB laptop drives for under $100. I have seen larger, as well, but between the price and the heat issues, these larger ones may not be best for low to mid level laptops. Also some people have had trouble getting a desktop to boot up from a drive larger than 2TB. Desktops uses one boot disk 2TB or smaller, and then add the 3, 4, or larger data drives. Not an option for laptops. NOW, after that you can see there are limits for laptops for drive size. For me, I notice my laptops get down to under 20 GB free very quickly. I have to have a USB 2TB drive [military grade] on hand to off load data files so I can continue to do "my thing". Then I have to try to find room in my data storage desktop for them. Of course, I have an old style PATA drive for boot and three 2TB drives installed with maybe maybe 100 GB left between the 4 drives. There is no more room in the case and I had to rig up a lot of fans to keep it cool enough to work. Of course for whatever reason it crashes every time I try to install Ubuntu 16.04. OK, that is a pet peeve. Of course, if you grew up before the PC was invented, or before there was an Internet, you will know how I feel about all these "new technologies" came out. "on the other hand" - I remember having to install Adobe packages and MS Office on a 50-80 gig hard drives at a computer work area. Of course, how many of you remember having to install Windows via floppy discs - twelve if I am correct - on desktops with no CD drive [before I was allowed to add a temporary CD drive to use for the installs]. On 01/01/2018 12:08 PM, Remy Gauthier wrote: Hi, As an FYI, on Fedora 25, the 64-bit version of 5.4.4-2 comes in at 879MB (result of the command "dnf erase libreoffice*" for a French/English installation with local help in both languages installed). Interestingly, LO 5.4.4.2 on my Windows 10 platform (64- bit, VmWare WS player 14) uses 550MB of disk space (size reported by right click -> Properties on the installation folder in Program Files). On the other hand, MS-Office on that same Windows platform has a disk footprint of slightly over 3 GB. Happy New Year! Rémy Gauthier. Le lundi 01 janvier 2018 à 09:41 -0500, Tim-L a écrit : I was changing versions of LibreOffice and saw something that I am wondering at. I ran "sudo apt-get remove libreoffice?" and at one point the process asked to continue showing that 896 MB will be freed. This was the 64 bit DEB version of 5.3.6. Since I was not "purging" LO, I thought that figure was a little high, but this was the first time I looked at the space being freed up before installing the next version. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] installed disc usage for LO
Hi, As an FYI, on Fedora 25, the 64-bit version of 5.4.4-2 comes in at 879MB (result of the command "dnf erase libreoffice*" for a French/English installation with local help in both languages installed). Interestingly, LO 5.4.4.2 on my Windows 10 platform (64- bit, VmWare WS player 14) uses 550MB of disk space (size reported by right click -> Properties on the installation folder in Program Files). On the other hand, MS-Office on that same Windows platform has a disk footprint of slightly over 3 GB. Happy New Year! Rémy Gauthier. Le lundi 01 janvier 2018 à 09:41 -0500, Tim-L a écrit : > I was changing versions of LibreOffice and saw something that I am > wondering at. > > I ran "sudo apt-get remove libreoffice?" and at one point the process > asked to continue showing that 896 MB will be freed. > > This was the 64 bit DEB version of 5.3.6. > > Since I was not "purging" LO, I thought that figure was a little high, > but this was the first time I looked at the space being freed up before > installing the next version. > > > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] installed disc usage for LO
I was changing versions of LibreOffice and saw something that I am wondering at. I ran "sudo apt-get remove libreoffice?" and at one point the process asked to continue showing that 896 MB will be freed. This was the 64 bit DEB version of 5.3.6. Since I was not "purging" LO, I thought that figure was a little high, but this was the first time I looked at the space being freed up before installing the next version. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted