Re: [libreoffice-users] sum text column of common unit of measure numbers
Correction Last line should read Save as *.ods file Regards, MalJaros - Original Message - From: "maljaros" To: "Global Users@" Sent: Thursday, 7 May, 2020 22:00:43 Subject: Fwd: [libreoffice-users] sum text column of common unit of measure numbers Hi James >My cell phone provider only provides me a CSV with a text field for the >usage. >I want to =sum( it so I need it to be numbers. >Is a macro the easiest way to make a new column of common unit of >measure (GB?) numbers? > >15 KB >5 KB >10 KB >15 KB >5 KB >5 KB >5 KB >1.8 MB >5 KB >5 KB >15 KB >215 KB >130.2 MB >9.2 MB >475 KB >11.7 MB >10 MB >15 KB >12.1 MB >5 KB >10 KB >7.1 MB >5.3 MB >4.9 MB >15 KB >240 KB >130 MB >2.9 MB I suggest the following procedure. Open the *.TXT file in CALC, ticking "Separated by" and "Space" boxes. Should produce spreadsheet with Numeric values in Column A and Text (either MB or KB) in column B. In Cell C1 put =IF(B1="MB",A1*1000,A1) Copy Cell C1 down to bottom of table. Save as *.odt file Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Fwd: [libreoffice-users] sum text column of common unit of measure numbers
Hi James >My cell phone provider only provides me a CSV with a text field for the >usage. >I want to =sum( it so I need it to be numbers. >Is a macro the easiest way to make a new column of common unit of >measure (GB?) numbers? > >15 KB >5 KB >10 KB >15 KB >5 KB >5 KB >5 KB >1.8 MB >5 KB >5 KB >15 KB >215 KB >130.2 MB >9.2 MB >475 KB >11.7 MB >10 MB >15 KB >12.1 MB >5 KB >10 KB >7.1 MB >5.3 MB >4.9 MB >15 KB >240 KB >130 MB >2.9 MB I suggest the following procedure. Open the *.TXT file in CALC, ticking "Separated by" and "Space" boxes. Should produce spreadsheet with Numeric values in Column A and Text (either MB or KB) in column B. In Cell C1 put =IF(B1="MB",A1*1000,A1) Copy Cell C1 down to bottom of table. Save as *.odt file Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] How to prevent Impress from changing font size?
Using Impress Version: 6.0.7.3 in Ubuntu 18.04 LTS, when I add to text in a slide the font size automatically reduces to keep the text within the text box. Can I prevent this auto resizing of the font? If so, how do I do this? Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Draw changes font when opening pdf text file.
Thank you all for the informative and helpful responses. Much useful knowledge about both LO and PDF has come to light (and solved my original problem). More strength to the LibreOffice community! MalJaros - Original Message - From: "Paul D. Mirowsky" To: "Global Users@" Sent: Monday, March 18, 2019 4:41:12 PM Subject: Re: [libreoffice-users] Re: Draw changes font when opening pdf text file. I am using "Version: 6.1.5.2 (x64)". Supposedly, you can force font substitution. I have not tried it. Choose *Tools - Options'* /- LibreOffice - Fonts' From: https://help.libreoffice.org/Common/Fonts/ You must click in the box next to "Apply replacement table" before you can select the substitute fonts. Hope this helps. -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Re: Draw changes font when opening pdf text file.
It occurs to me that Draw does not recognise, or does not have, the font used for the original document and substitutes one that it does have. My problem is that the original, serif, font is being substituted by a monopitch font. Regards, MalJaros - Original Message - From: "Malcolm Jaros" To: "Global Users@" Sent: Monday, March 18, 2019 3:27:05 PM Subject: [libreoffice-users] Re: Draw changes font when opening pdf text file. I do apologize for not pointing out that I am using 6.2.1.2 on Ubuntu 18.04 Regards, MalJaros From: "Malcolm Jaros" To: "Global Users@" Sent: Monday, March 18, 2019 3:24:12 PM Subject: Draw changes font when opening pdf text file. Greetings All. I would like to add a few words to the text embedded in a pdf file. When the file is opened in Draw the text is displayed, and subsequently saved, in a different font from the that in the original file. This unfortunately changes the line length and hence the page layout, which makes the amended copy unusable. How can I prevent this? Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Re: Draw changes font when opening pdf text file.
I do apologize for not pointing out that I am using 6.2.1.2 on Ubuntu 18.04 Regards, MalJaros From: "Malcolm Jaros" To: "Global Users@" Sent: Monday, March 18, 2019 3:24:12 PM Subject: Draw changes font when opening pdf text file. Greetings All. I would like to add a few words to the text embedded in a pdf file. When the file is opened in Draw the text is displayed, and subsequently saved, in a different font from the that in the original file. This unfortunately changes the line length and hence the page layout, which makes the amended copy unusable. How can I prevent this? Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Draw changes font when opening pdf text file.
Greetings All. I would like to add a few words to the text embedded in a pdf file. When the file is opened in Draw the text is displayed, and subsequently saved, in a different font from the that in the original file. This unfortunately changes the line length and hence the page layout, which makes the amended copy unusable. How can I prevent this? Regards, MalJaros -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] corrupt letter
Just a thought. Ubuntu 18.10 is a new distro and less thoroughly tested than the LTS version 18.04. If you do not get this problem in 18.04 perhaps you should stay with that for a while. Regards, MalJaros - Original Message - From: "Michael H" To: "James" Cc: "Remy Gauthier" , "Global Users@" Sent: Monday, November 26, 2018 2:06:39 AM Subject: Re: [libreoffice-users] corrupt letter I had a problem similar to this on windows 98, after I installed a legal copy of word perfect and all 1100 fonts it came with. Apparently windows 98 had a limit of about 500 fonts ... and above that it would get confused after a while. However, more recently I used Ubuntu studio 12, which ships with about 1200 fonts, and ported those to wasta 14 and 16 en mass. I had no issues. I haven't ported this many to wasta 18 yet. On Sun, Nov 25, 2018, 4:45 PM James It is not a format problem because sometimes it works. > It seems to corrupt something in the OS after a while that shows up in > libreoffice. > The most recent problem was '2' was garbled. > > On 2018-11-25 12:09 p.m., Remy Gauthier wrote: > > Hi, > > > > It almost looks like if the "Monthly car payment" string was displayed > > using the date format of the A1 cell. What are the language and > > formats used in the A1 and B1 cells? > > > > Rémy. > > Le mercredi 21 novembre 2018 à 20:05 -0500, James a écrit : > >> I use lubuntu-18.10. > >> Sometimes, a letter gets corrupted but I only see it in libreoffice. > >> > >> This example the 'p' displays as a ',': > >> http://lockie.ca/lubuntu_/libreoffice.jpg > >> > >> I've also seen it when '2' displays garbled. > >> > >> Any ideas about how to track down what software has the problem? > >> > >> > > -- > 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/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Two formulas in one cell?
That is an impressive solution from Michael but, not knowing the layout of your spreadsheet, I wonder why you cannot simply insert a new column adjacent to the cell in question so that each formula can be in a separate cell. Regards MalJaros - Original Message - From: "Michael D. Setzer II" To: "Brian Barker" , users@global.libreoffice.org, "Carl Winerich" Sent: Sunday, 3 June, 2018 03:44:39 Subject: Re: [libreoffice-users] Two formulas in one cell? =3DTEXT(A3+3, D, )60;TEXT(A4,#) A3 was1/15/18 in my case and A4 was 27 result in cell is: Thursday, January 18, 201827 Would be nice if you could put actually wanting with examples. You can get the formating you need using the text command, and you can see the diffiernt format option using the cell format, and it shows examples of the format code. Just picked a longer one for the date format. Then just a regular number format used for the second. On 2 Jun 2018 at 20:54, Carl Winerich wrote: To:;Brian barkerb.m.bar...@btinternet.com, users@global.libreoffice.org From:60;Carl winerichl...@ipadring.net Subject:;Re: [libreoffice-users] Two formulas in one cell?Date sent:60;Sat, 2 Jun 2018 20:54:49 -0400 Concatenate works...to a point. Another problem is that first formula must provide a result formatted as a date, let's say June 2.The second formula must provide a result as a day-number-of-the-year (which I haven't figured out how to do yet). Using concatenate the result is a 5 digit number returned for the first formula even though the cell is formatted as a D. How can these format requirements be maintained? Thanks, Carl On 06/02/2018 06:10 PM, Brian Barker wrote: At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote: In cell A2 the following formula is placed =F30-2 In the same cell (A2) I want to place a second formula which is =A10+4 How can I add this second formula into A2 and obtain the results of both formulas in the same cell (A2) but each separated by several spaces so the results are distinct? Thank you, Carl The answer to this question is very similar to that for the almost identical question that you asked (and had answered) last November 21st: http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html . If a cell contains a formula, the result of that formula is what appears in the cell, so having two formulae would be simply contradicting yourself. As you already know, if you wanted F30-2 you would not expect to use =F30 and then =-2 separately but instead =F30-2. In the same way, you must construct a single formula that creates the combination of values that you ask for. You can combine results using the CONCATENATE() function or, more simply, the operator.Try: =F30-260;A10+4 Incidentally, do please put your name in the real name field of your mail messages: it's an elementary courtesy to those offering to help you. 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/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy -- 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/ Privacy Policy: https://www.documentfoundation.org/privacy