[libreoffice-users] libreoffice math formula editor color
Hi all, I would like to write some mathematical equations in Writer with LO Math. Unfortunately the formula editor background is dark grey with black letters. How could I change the background color. I use LO in openSUSE, tried to change desktop color schemes, window color schemes but to no avail. I also tried to modifx LO setting, but obviously, did not find the correct one. In LO I also use a dark scheme but now I cannot change it. I have LO 6.1.2.1 and KDE . Thanks, Albert -- 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] overlap(?) objects in draw
2018-05-22 19:15 keltezéssel, Regina Henschel írta: Hi Albert, Albert Oszkó schrieb am 22.05.2018 um 18:43: Hi all, I've never used Draw up to now, but I got a task and thought I could do it with that. I am reading and viewing tutorials but did not find the method for the following: how to overlap, combine, or be it called something else, two objects. I mean for example: how can I draw a tube that is pushed into a ring. That would be possible in 3D and Draw is able to have true 3D objects. But the UI is so bad, that I do not recommend it for beginners in Draw. You will likely need to make a "fake" 2D drawing. Ok, I could do it by drawing two tubes, one is above, the other is below the ring, but can it be done in a simpler and cleverer way? I would draw one tube and do not use a closed ring, but an open one, which touches the tube at its open part and lays in front of the tube at the opposite side. Of cause you can build union, combination, or group of objects. But it will not be possible, that one part of an object is in front and one part is behind another object in 2D. Kind regards Regina Thank you, Regina! I am experimenting. In the meantime I found freeCAD but it is not meant to my level of knowledge. Regards, Albert -- 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] overlap(?) objects in draw
Hi all, I've never used Draw up to now, but I got a task and thought I could do it with that. I am reading and viewing tutorials but did not find the method for the following: how to overlap, combine, or be it called something else, two objects. I mean for example: how can I draw a tube that is pushed into a ring. Ok, I could do it by drawing two tubes, one is above, the other is below the ring, but can it be done in a simpler and cleverer way? Thanks: Albert -- 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] need some help with custom number format code
2018-03-19 19:33 keltezéssel, Brian Barker írta: At 15:06 19/03/2018 +0100, Oszkó Albert wrote: I would like to create a custom number format code in Calc, to spare some work. This would be like this AB-01/2018. I would like to increment only the 01 part by dragging that little rectangle on the lower right of the cell. So I created as custom formats "AB-"##"/2018" or "AB-"\/. Unfortunately in either case only the year number is incremented and not what I wanted. I'm not sure that's true - but it depends anyway on the actual values you propose to enter into the cells. Are you suggesting entering the number 1 and filling down to produce 2, 3, and so on - or to enter the date 1 January 2018 (in whatever format) and filling that down to 1 February 2018 and so on? In addition, is the 2018 part fixed, or do you want that eventually to change? Do you want 12/2018 to be followed by 13/2018, that is, or by 01/2019? Your first form works if the cells contain just the numbers 1, 2, and so on - not dates - though it would have to use "00" in place of "##" if January were to appear as "01" and not as "1" and so on. And it runs out if you want 2019 to appear when appropriate. How to proceed? You could easily assemble this using a formula by concatenating the text with a formatted version of the relevant date. For example, put 1 January 2018 (as a date) in A1. If you fill down from this, you will get 2 January and so on, which is not what you want. Instead enter 1 February 2018 in A2. Now select A1 and A2 together and drag the fill handle: that will give you 1 March, 1 April, and so on. Now in B1 enter ="AB-"&TEXT(A1;"MM/") and fill that down the column. You can hide the unwanted column A or put it away on another sheet if you prefer. You could avoid the extra column by generating the date in the formula: ="AB-"&TEXT(DATE(2018;ROW();1);"MM/") Fill that down to achieve the desired effect. If your values start in a row other than the first, you will need to change "ROW()" to "ROW()-x", where "x" is some appropriate value. Note that this formula relies on the ability of the DATE() function to interpret the thirteenth month of 2018 as January 2019 and so on. But yes: you can achieve this by formatting dates. Just use the format "AB-"MM/. Once again, you will need to enter your first two dates (1 January and 1 February 2018) into the first two cells, select both, and then drag the fill handle so as to create dates one month apart, not one day apart, as would happen if you try to fill from a single prototype. I trust this helps. Brian Barker Thank you very much for this short tutorial! These codes are for numbering documents. The first part - in this case AB or AB- refer to the type of the course these documents belong to. 01 etc are serial numbers from 01 to -say- 60. the last part /2018 refers to the current year and should not be incremented. Regards, Albert -- 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] how to insert video
2017-02-22 22:36 keltezéssel, Paul D. Mirowsky írta: Are you sure you have the right video CODEC installed. I use Ubuntu, but you should try here: https://software.opensuse.org/package/opensuse-codecs-installer?search_term=opensuse-codecs-installer On 2/22/2017 2:49 PM, Albert, Oszkó wrote: Hi all, Well, theoretically I know the answer, I read quite a bit of text and watched youtube videos. But I simply cannot make it work. I try it on openSUSE with KDE (Plasma) and LO 5.2.3.3. I read somewhere that only .ogg videos work - but not for me. I saw a tutorial where .avi also worked. OK, it is a container format. When I insert a video file, it is seemingly embedded, but when I try to play it, LO freezes. Sound files work. And one more thing: I tried to choose the insert reference option (or something like that), but it does nothing. It would be comfortable and acceptable if I could open videos in an external player What could be wrong? Help, please! Albert Thanks for the suggestion, but it does not work. In them meantime I tried in Virtualbox Linux MInt: worked out of the box. Tried Ubuntu: did not work first, but offered to install some more packages which then drew in even more packages. But then worked. So I do not know what is wrong with my installation. Albert -- 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] how to insert video
Hi all, Well, theoretically I know the answer, I read quite a bit of text and watched youtube videos. But I simply cannot make it work. I try it on openSUSE with KDE (Plasma) and LO 5.2.3.3. I read somewhere that only .ogg videos work - but not for me. I saw a tutorial where .avi also worked. OK, it is a container format. When I insert a video file, it is seemingly embedded, but when I try to play it, LO freezes. Sound files work. And one more thing: I tried to choose the insert reference option (or something like that), but it does nothing. It would be comfortable and acceptable if I could open videos in an external player What could be wrong? Help, please! Albert -- 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] mail merge is incomplete
2016-12-28 14:20 keltezéssel, Cor Nouws írta: Hi Alberto, Albert, Oszkó wrote on 24-12-16 20:42: I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge wizard in LO writer there are only 5 steps included. I cannot figure out what is missing to complete the wizard to 8 steps and being able to send the letters via email. There is a new: View > Tool bars > Mail Merge Ciao - Cor That's it! Thank you for your help. Albert -- 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] mail merge is incomplete
Hi all, I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge wizard in LO writer there are only 5 steps included. I cannot figure out what is missing to complete the wizard to 8 steps and being able to send the letters via email. Any help is welcome. Best regards, Albert Oszkó -- 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] inserting an odg file covers text below
2016-04-04 21:31 keltezéssel, libreoffice-ml.mbou...@spamgourmet.com írta: Albert Oszkó wrote: Hi all, In a Writer text (Libreoffice 5, windows XP, linux mint and opensuse) I inserted some picures made with printscreen. Now i would like to write some explanatory text on these pictures. I did this in Draw. I finally managed to insert the odg file into Writer, in place of the original picture without text. Unfortunately, the new odg file covers the text below. How can I eliminate this? Format > Wrap > Wrap Off (or whichever option you prefer). You might also want to look at Format > Anchor to control how the image will move as you edit the text around it. Thank you very much, wrapping solved my problem. Albert -- 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] inserting an odg file covers text below
Hi all, In a Writer text (Libreoffice 5, windows XP, linux mint and opensuse) I inserted some picures made with printscreen. Now i would like to write some explanatory text on these pictures. I did this in Draw. I finally managed to insert the odg file into Writer, in place of the original picture without text. Unfortunately, the new odg file covers the text below. How can I eliminate this? Thanks Albert -- 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] Android version
There is also Eurooffice, which is free for Android and can be downloaded from GooglePlay. It has also (non-free) versions for Windows and some linuxes. 2015-09-14 14:41 keltezéssel, Tom Davies írta: Hi :) Has anyone here used the AndrOffice or the LibreOffice version on Android? Does anyone know if it installs onto the device itself so that it's usable off-line? I have a friend who is going off to a distant land where they won't be able to use their hand-held phone but has created a spreadsheet to help convert between the various currencies they will encounter. I've never used an Android so i have no idea what to recommend but i'd rather suggest a LibreOffice or OpenOffice solution. Any ideas? Regards from Tom :) -- 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] Page break is not correct with printing
2014-08-03 13:00 keltezéssel, Mark Bourne írta: Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format > Page > Sheet > Scale > Fit ... on number of pages > 1 2. Format > Page > Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Mark. Dear Mark, Thank you for the hint. Your 1st suggestion did not work, but another option from the same menu sequence did the job: Format > Page > Sheet > Scale > Fit printing regions for width/height (or something similar, my locale is Hungarian) Thanks, Albert -- 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] Page break is not correct with printing
Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. Thanks and regards, Albert -- 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