[libreoffice-users] printer paper size question
Mageia 3, KDE4, LibraOffice Version 4.0.3.3 (Build ID: 4.0.3.3-2.mga3) HP Laserjet 4m plus 9 MB memory Error message: PC Load DL where PC = Paper Cassette where DL = paper size (approx. 1/3 of A4 sheet) Printer paper is US Letter Printer installed on Mageia 3 as US Letter Printer in LibraOffice defaults to US Letter for full sheet Printer in LibraOffice defaults to DL for envelope Is this normal/expected behavior? Would not we have expected a default envelope size more related to the paper size? Navigation: (after inserting an envelope in a text document) File - Print - (select printer) - Properties - (Paper size reads: Env DL) Work around (on a per job basis): Change paper size - OK - OK - File - Save (or Save As) Another work around ... build templates Any help/hints/suggestions? Thank you Regards Fred James -- 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] printer paper size question
Kracked_P_P---webmaster wrote: I do not know about that printer anymore. It has been a while since I had a laser 4. But, my HP 2300dn has 48 MG of memory and sometimes the graphics/document gives me and not enough memory type of error. Do you have the ability to add more memory? You are printing envelopes, right? Are you using the Format Page Paper - Format DL envelope and then deal with it from there? I would format the page to the envelope I wanted instead of doing it on the printer side of the process. Also, there may be something in your profile that might be causing some issues with the printer. This has happened to be from time to time with LO and the OOo before that. I use Ubuntu 12.04 with MATE desktop environment. printers - in use: HP Laserjet 2300dn, HP inkjet 7000, Canon MG6220 printers on the shelf - Epson Artisan 810, several HP inkjets, plus 2 DELL inkjets. use to have HP 2600 color laser and a HP Laser 4 plus[?] but are dead now. so I have a bit of experience with printers. On 06/24/2013 12:07 PM, Fred James wrote: Mageia 3, KDE4, LibraOffice Version 4.0.3.3 (Build ID: 4.0.3.3-2.mga3) HP Laserjet 4m plus 9 MB memory Error message: PC Load DL where PC = Paper Cassette where DL = paper size (approx. 1/3 of A4 sheet) Printer paper is US Letter Printer installed on Mageia 3 as US Letter Printer in LibraOffice defaults to US Letter for full sheet Printer in LibraOffice defaults to DL for envelope Is this normal/expected behavior? Would not we have expected a default envelope size more related to the paper size? Navigation: (after inserting an envelope in a text document) File - Print - (select printer) - Properties - (Paper size reads: Env DL) Work around (on a per job basis): Change paper size - OK - OK - File - Save (or Save As) Another work around ... build templates Any help/hints/suggestions? Thank you Regards Fred James Kracked_P_P Thank you for your reply. I shall answer your question, but first to clarify the question: This question is not about workarounds or the mismatch of user interface and locale settings, but rather: Why, if LibreOffice knows the paper is US letter, does inserted envelope default to DL? Wouldn't it be more reasonable to expect a match between paper and envelope size as the default? Or is this not possible/reasonable? By the way, I did not have this issue under Apache OOo under Mageia 2. A second question, if I may: What do each of the settings control (user interface, and locale)? Answering your questions: Memory: not an issue with LibreOffice ... sometime with websites and some PDF's ... Ran OK under Apache OpenOffice, too. Memory: printer is maxed out. Envelope: printing fine Format Page Paper - Format DL envelope? No, I am doing it through File - Printer Settings Doing it through Format gives a nice result, too, if one remembers to set it to landscape And either method can be saved/applied to the document Thanks again Regards Fred James -- 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] styles for plays?
Helen wrote: I've volunteered to edit a one-time publication of a collection of plays. The plays came to me in different styles -- three of the plays came to me with all the characters's speaking lines centered -- the characters's names centered a line above. Some of the writers seem to have centered the names with a centering code -- I can highlight the name and use the left margin code to move the name to left margin. Others seem to have centered by spacing over! (yes) and I have to backspace until I get the name to the left margin. None used a colon after the speaker, and the publisher wants it. I've made some progress with Search Replace -- Search for all incidents of TOM and replace with TOM colon space. But the most tedious part is moving TOM from center to left and bring his speaking lines up to begin on the same line. Is there any way I can put these plays into a style sheet and save this work, or would creating the style sheet take as long as what I'm doing? I've never used styles. And this is a one-time job so if I have to do it all by hand, at least it's only once. Thanks for any advice, Helen Not sure this is helpful ... Things are so context dependent ... Let me preface my remarks with: (1) send a sample file to me (off line, if you like) and I could take a look at it and see what I might be able to do? (2) depends on the results of step 1 And so, on to what I have thought of so far ... First I thought Macro (which I don't do anything with, so no help there) Second I thought gawk ... and I played with that with some degree of success ... Steps: (1) save document as (plain) txt (no encoding) (2) in a terminal window, apply this command to the *.txt file ... awk '{gsub(/^[ \t]+|[ \t]+$/,)};1' filename.txt newfilename.txt ... this removes all leading (and trailing) white space, and everything is left justified. It takes out spaces, tabs, and centering, and the result would look like this ... Tom said one Tom said two Tom said three ... and LibreOffice can open and edit the new *.txt file. That doesn't get the speaker's line adjoined or insert the necessary : either, but depending upon context something might be made to do the job? Regards Fred James PS: credit where credit is due: I found that little one-liner at http://www.pement.org/awk/awk1line.txt -- 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] Need help with page formatting please...
Al Vesper wrote: Hi list! I am trying to create mini cue cards, 3x2.5, meaning I want to print two mini-cards on a 3x5 card which I will cut in half. I want the text (one to three lines) to start at the same place on each mini-card. When I format the page for 3x5, I don't know how to get the text for the second mini-card to start at the same place each time (the first mini-card may have a varying number of lines). I need hundreds of these things, and I would like to format each page (two mini-cards) once for all the cards. I've played with the paragraph spacing, frames, page formatting, and almost everything else, but haven't gotten it figured out yet. Any suggestions (especially ones that might actually work) will be gratefully appreciated. Many thanks... Al Vesper Have you looked at label formatting? Example: Avery labels? I haven't done this in a long time (maybe 1993-4), but I used to modify Avery label formats to make custom layouts. In your case you would want the 3x5 sheet size with two 2.5x3 labels on it, no? Will your printer handle that size stock? None of mine will. Hope that helps Regards Fred James -- 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] spelling correction
Walther Koehler wrote: Salute, LO-fans, I have a problem with spell check: given: This is a rong sntence with man mistokes. spell check f7 marks with a red underline what should be changed. So far so well. but 1) When adding manually w before rong and pressing change, spell check will jump back to the start of the paragraph and start checking it again while deleting all hard-formats (like bold) in that very paragraph. 2) When adding manually y at the end of man, the next red mark ist not mistokes but a black m and red istokes. Now you can replace istokes with mistakes, however the text will read as mmistakes. This shift of the red mark ist continued with the following words. This misbehaviour occurs only, when two incorrect words follow each other. Debian Linux, LO 4.0.4 (download 11.07.13), checked with german. Can someone confirm this? In that case, I would submit a bug (I screened the bug list already without finding a reference). Walther Walther Koehler Perhaps I am not doing this the way you are? But I copied/pasted This is a rong sntence with man mistokes into a new LO text document and ran spell check on it with the end result of This is a wrong sentence with man mistakes without encountering any difficulties. I don't see a way to manually add a w within the spell check dialog box ... perhaps I am just not looking in the right place? Regards Fred James PS: Mageia3, KDE4, LO Version 4.0.3.3 (Build ID: 4.0.3.3-2.mga3) (uname -a) Linux localhost.localdomain 3.8.13.4-desktop-1.mga3 #1 SMP Thu Jul 4 13:56:21 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux -- 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] doesn't see selected sheet or page
Mageia 3 KDE4 LibreOffice 4.0.4.2 (Build ID: 4.0.4.2-2.mga3) LibreOffice has been working just fine all along, and then this printing problem showed up just this morning (see details below). So far this is only happening in this one file ... other LibreOffice files I have tried print fine ... other apps print fine. Any suggestions? Thanks. Regards Fred James Problem scenario: working spreadsheet open Navigate: File - Print preview area has text in it that says No pages same no matter which printer is selected and of course ... nothing prints Currently using this workaround: working spreadsheet open select a range of cells Navigate: File - Print preview area shows a page w/only selected cells page prints w/only selected cells -- 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
SOLVED: Re: [libreoffice-users] doesn't see selected sheet or page
Sorry ... just a bit more google and I found ... ...did you define a print range? (Check Format Print Ranges from the main menue) So problem solved! Don't know how that got undefined, but it works now! Thanks Regards Fred James Fred James wrote: Mageia 3 KDE4 LibreOffice 4.0.4.2 (Build ID: 4.0.4.2-2.mga3) LibreOffice has been working just fine all along, and then this printing problem showed up just this morning (see details below). So far this is only happening in this one file ... other LibreOffice files I have tried print fine ... other apps print fine. Any suggestions? Thanks. Regards Fred James Problem scenario: working spreadsheet open Navigate: File - Print preview area has text in it that says No pages same no matter which printer is selected and of course ... nothing prints Currently using this workaround: working spreadsheet open select a range of cells Navigate: File - Print preview area shows a page w/only selected cells page prints w/only selected cells -- 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: oops! Re: [libreoffice-users] Re: [libreoffice-users] Fedena 2.3.4 is Now Available
Fred James wrote: Luuk wrote: On 07-09-2013 20:33, Tom Davies wrote: Hi :) Fred has been looking into it a bit more but we still haven't worked out if it really is bad. It's still looking like a good product but it is more comparable with these; http://open-school.org/ http://akuraschools.org/ http://centresis.org/ Above three sites seem commercial, offering services on the web.. http://www.projectfedena.org/ Is opensource, WITH the option to download source (which i think is important for opensource!) Demo-site is here: http://www.projectfedena.org/demo But i'm still guessing what this has to do with libreoffice ;) ... to do with LibreOffice? Nothing, obviously. Side note ... daughter teaches at a university that uses Moodle ... hates it ... says it is painfully slow (your mileage may vary ... sigh) Regards Fred James -- 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] spreadsheet - sum one column based on the value of other
Brian Barker wrote: At 12:58 08/09/2013 -0300, Bruno Schneider wrote: (omissions for brevity) =SUMPRODUCT(B$2:B$5=E1;C$2:C$5) so you can fill this down into F2. How does this second method work? Well, the test of equality gives a value which can be interpreted as a number: 1 for TRUE and 0 for FALSE. Multiplying this by your value switches each value on or off in the sum. I trust this helps. Brian Barker Typo found : switch the B's and C's so that the function reads: =SUMPRODUCT(C$2:C$7,E1=B$2:B$7) and it works. Thanks ... I did enjoy that, and I learned something! Regards Fred James -- 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] spreadsheet - sum one column based on the value of other
Brian Barker wrote: At 13:42 08/09/2013 -0400, Fred James wrote: Brian Barker wrote: =SUMPRODUCT(B$2:B$5=E1;C$2:C$5) so you can fill this down into F2. Typo found : switch the B's and C's so that the function reads: =SUMPRODUCT(C$2:C$7,E1=B$2:B$7) and it works. Er, there is no typo, just some confusion on your part. The original formula works. You have changed the test from X = Y to Y = X and the product X x Y into Y x X. As any elementary mathematician knows, equality and multiplication are commutative, so these are the same thing: x = y and y = x are the same test; and 2 x 3 and 3 x 2 are the same value! Brian Barker Sorry ... yes: x=y is the same as y=x, but when testing the original function the results were incorrect. Switching the b's and c's made the function return the correct results. Assumption (on my part): the first part (C$2:C$5) is the column of values to be summed the second part (E1=) is the value we want to match in the third part the third part (B$2:B$5) is the column/range of values to be matched by the second part ¿Sí? So if we used column B for the first part we would be trying to sum labels/text, and if we used C in the third part, we would be trying to match labels/text to numbers? Or did I miss something? In any case, I must thank you for pointing to this solution ... it is great ... I really enjoyed this. Regards Fred James -- 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] Created PDF files to not appear as recently created / used
James Knott wrote: Robert Orzanna wrote: I noticed that LibreOffice's PDF creator does not add the created PDF to the list of recently created files. Through google I found a related bug report but without any comments on it yet. My understanding of that recent files lists are files you recently edited and are therefor likely to be editing again. That would not be the case with PDFs. Creating PDFs would be more like printing the document and I don't recall there being any recently printed documents list. Test results ... opened a new LibreOffice text document added some text File - Export as PDF check box to Embed OpenDocument file exported closed LibreOffice text document without saving PDF file was created, and could be opened with Okular PDF file did not appear in File - Recent Documents PDF file could be opened by LibreOffice for editing. Hope that helps Regards Fred James -- 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] Created PDF files to not appear as recently created / used
Robert Orzanna wrote: Hello, I noticed that LibreOffice's PDF creator does not add the created PDF to the list of recently created files. Through google I found a related bug report but without any comments on it yet. Bug report: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=66412 Would anyone like to comment on this and state how this might be resolved? Thanks, Robert Question: how are you looking for the file, through LibreOffice, such as in File - Recent Documents ? Since a PDF file is not normally a LibreOffice format, I don't believe it should show up there. I say normally because when exporting a document as a PDF, one does have the option to Enable OpenDocument File ... I have not tested that, but it is supposed to make the PDF editable in LibreOffice, and possibly it would then appear in File - Recent Documents? Maybe? Regards Fred James -- 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: [libreoffice-users] Re: [pt-br-usuarios] Estudantes da rede estadual de SP terão Office gratuito para até 5 PCs após parceria
Urmas wrote: Jay Lozier: Microsoft did not develop the first office productivity packages. There were no 'office packages' before Microsoft Office. Several predated any MS offerings and were available before the IBM-PC was released. They didn't design the first, but they have designed the best So tell me, Urmas, if you find MSO to be the best, why are your here on an LO list? Regards Fred James -- 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: [libreoffice-users] Re: [libreoffice-users] Re: [pt-br-usuarios] Estudantes da rede estadual de SP terão Office gratuito para até 5 PCs após parceria
Virgil Arrington wrote: (omissions for brevity) Last I saw, this is a *user's* list, not necessarily a *cheerleader's* list. Virgil (omissions for brevity) So tell me, Urmas, if you find MSO to be the best, why are your here on an LO list? Regards Fred James Neither a booster or a trasher, am I. I am on this list to learn, full stop. Religious wars still annoy me ... I shall have to work on that. Regards Fred James -- 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] SOLVED: ODS question
Tom Davies wrote: Hi :) There's an even easier way! Sorry this is probably too late! :( 1. Open both files but get into the one you want to copy from 2. Right-click on the tab at the bottom of the work-sheet 3. Choose Move or Copy worksheet 4. in the dialogue choose copy and use the drop-down to select the other file. I suspect you can do multiple worksheets/tabs at a time. Of course another way is to simply copy the entire file and then you have all the tabs/worksheets in the new file. Maybe need to add or delete a couple. Regards from Tom :) On 2 January 2015 at 01:35, Fred James fredj...@fredjame.cnc.net mailto:fredj...@fredjame.cnc.net wrote: OS: Mageia 4, 64bit (if that makes a difference?) LibreOffice: 4.1.6.2 I have two separate ODS files: 2014 and 2015 I want to copy a sheet (the entire sheet) from 2014 to 2015. Is this possible, and if so, what is the recommended method? Actually, there are a few sheets I want to copy from 2014 to 2015, but one at a time. Thank you Regards Fred James Sorry ... silly me ... the answer is too easy ... 1) go to file to copy from 2) go to the sheet to copy 3) Edit - Select All 4) go to file to paste into 5) go to (or make) sheet to paste into 6) select cell A1 7) Edit - Paste Special Bingo! Thanks Regards Fred James Tom Davies Thank you for your reply and your solution ... I shall put that in my notes for the future, as I do this same operation periodically ... but too far apart to trust memory. My original approach was to just copy the whole file and modify as needed ... the problem I have with that is that I do the file copy a few weeks early (for example early in December for a new file that begins in January) ... reason: some December activity actually needs to be recorded in January as well. That leaves me with certain sheets that will need a lot of updating, and just replacing them is so much simpler ... your mileage may vary, of course. Either copy solution (the one I stumbled upon, or the one suggested by Tom) will do what I need quite nicely ... in the case of Tom's solution, I will have to delete an older sheet in the new file, after copying in the newest version (I have tested it), but that shouldn't be a show stopper, eh? The copy process does not allow duplicate names (or overwriting), and so appends a _2 (for example) to the name of the newly inserted sheet. Thanks again for your help Regards Fred James -- 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] SOLVED: ODS question
OS: Mageia 4, 64bit (if that makes a difference?) LibreOffice: 4.1.6.2 I have two separate ODS files: 2014 and 2015 I want to copy a sheet (the entire sheet) from 2014 to 2015. Is this possible, and if so, what is the recommended method? Actually, there are a few sheets I want to copy from 2014 to 2015, but one at a time. Thank you Regards Fred James Sorry ... silly me ... the answer is too easy ... 1) go to file to copy from 2) go to the sheet to copy 3) Edit - Select All 4) go to file to paste into 5) go to (or make) sheet to paste into 6) select cell A1 7) Edit - Paste Special Bingo! Thanks Regards Fred James -- 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] ODS question
OS: Mageia 4, 64bit (if that makes a difference?) LibreOffice: 4.1.6.2 I have two separate ODS files: 2014 and 2015 I want to copy a sheet (the entire sheet) from 2014 to 2015. Is this possible, and if so, what is the recommended method? Actually, there are a few sheets I want to copy from 2014 to 2015, but one at a time. Thank you Regards Fred James -- 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] positive comment
LibreOffice Version: 4.3.6.1 Build ID: 4.3.6.1-3.mga4 ... does a very interesting thing ... (1) I backup some documents on a daily basis, to a USB stick, which I remove when not in use (2) When I opened earlier versions of LibreOffice, the Recent Documents list showed all documents from the hard drive, and from the USB stick, whether or not the stick had been removed (3) Now, when I open LibreOffice (3.1) If the stick is still in place from the last use, all of the recent documents on the hard drive, and on the USB stick, are also shown (3.2) If the stick has been remove, whether replaced or not, the documents on the USB stick are not shown ... I do like that. And I do like the new graphical display of the Recent Documents list, even though I can only see it when all documents are closed. Thanks Regards Fred James -- 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] help track an issue
If anyone can help me understand how to track/trace this issue, I would appreciate it. Software OS: Mageia4 64 bit KDE4 LibreOffice 4.3.7.2 (Build ID 4.3.7.2.1.mga4) Physical HP Pavilion p6-2419 Kingston USB memory stick, (DT 101 G2 ... 16GB) Filesystem Ext4 in both cases Procedure (1) Insert USB drive (2) Access USB drive with Dolphin (3) Close Dolphin (4) Open LibreOffice (4.1) Close empty text document (4.2) Open existing spreadsheet on local drive (4.2.1) Compete task(s) in spreadsheet (4.2.2) Save changes to local drive under same name/same location (4.2.3) Save As to USB drive with similar name ... date added to name (4.3) Close spreadsheet (5) Exit LibreOffice Problem Sometimes (seems to be random) at step 4.2.3 the Save As fails ... error message indicates that the original document is opened by another user? Sorry, I cannot find the actual error message at the moment ... will be able to supply it when it happens again, of course. Note I follow the above procedure carefully because it seems to experience this particular issue the least. The only exception would be if steps 1 through 3 have already been done, and the USB drive is still attached (has not been removed). Question What can I do to track/trace this issue on my machine? Thank you Regards Fred James -- 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] copying a ODS file and setting some cells to value in old file
(Please forgive me if this is a duplicate ... thank you) I do this every year, but this year I am experiencing problems OS Mageia 7, Plasma LibreOffice 6.2.8.2 The original file is an 18 sheet ODS file used for budget purposes I can successfully copy the original file (in original location) to the new file (in new location), either by ... open the old file and save-as (File -> Save As) or open Dolphin file manager, copy the old file, paste the file into a new location, and rename it to the new file or open a terminal and perform the copy operation there (cp oldlocation/oldfilename newlocation/newfilename Then in the new file, I delete unwanted sheets and data to start the year fresh. Next I set the values of some cells in the new file, to the values of some cells in the old file. (Example: ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD December 2019'.F114) This has always worked well in the past, but this year, I am getting an error in the destination cell ... at first that was ErrL514, and now it is Err:540. Can you advise, please? Thank you Regards Fred James -- 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] copying a ODS file and setting some cells to value in old file
Johnny Rosenberg wrote: Den ons 11 dec. 2019 kl 19:55 skrev Fred James : (Please forgive me if this is a duplicate ... thank you) I do this every year, but this year I am experiencing problems OS Mageia 7, Plasma LibreOffice 6.2.8.2 The original file is an 18 sheet ODS file used for budget purposes I can successfully copy the original file (in original location) to the new file (in new location), either by ... open the old file and save-as (File -> Save As) or open Dolphin file manager, copy the old file, paste the file into a new location, and rename it to the new file or open a terminal and perform the copy operation there (cp oldlocation/oldfilename newlocation/newfilename Then in the new file, I delete unwanted sheets and data to start the year fresh. Next I set the values of some cells in the new file, to the values of some cells in the old file. (Example: ='file:///home/fredjame/mystuff/budget/2019/budget_2019.ods'#$'TD December 2019'.F114) This has always worked well in the past, but this year, I am getting an error in the destination cell ... at first that was ErrL514, and now it is Err:540. Can you advise, please? https://help.libreoffice.org/6.3/ar/text/scalc/05/0214.html?DbPAR=CALC Thank you for the URL. I found the definition of Err:540 ... "External content disabled". From there I looked at LibreOffice help and found the instructions for inserting the reference/link to the cell in the other ODS file "To Reference a Cell in Another Document", which I followed right up to "Confirm the formula by clicking the green check mark.", but I don't have a green check mark to click. Then I tried looking for where the external content might be disabled/enabled ... no luck so far. Answers to the question(s) at Google seem to be written for other versions of Libreoffice, because they don't match too well to anything in this version (6.2.8.2) Can you advise, please? Thanks again Regards Fred James -- 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] filter bank transactions and then sum
James wrote: I've got a spreadsheet of all my bank transactions and I want to filter them by type and them the results. eg. Tran Type Amount 1 A 1.5 2 B 2.0 3 A 3.5 I can use Data/More Filters/Standard Filer to get: Tran Type Amount 1 A 1.5 3 A 3.5 but sum(C1:C3) gives 7.0 (the sum of the unfiltered spreadsheet. I can copy but filtered rows but that is too easy. :-) What is the hardest overkill way? :-) Maybe a template or macro that I can reuse. I just want to filter them so I can add up the interest I got. Assuming the above is in columns A, B. and C, and rows 1, 2, 3 and 4 ... In Cell D2 place ... =IF(B2="A",C2,0) In Cell E2 place ... =IF(B2="B",C2,0) Drag those down to fill the relevant cells, and SUM those columns. Hope that helps Regards Fred James -- 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] Printing Many Columns
charles meyer wrote: As computer end-users, we're often confronted with which software tool is best for a certain task. I'm at that juncture again. I have a heading for each column from A - J and thought Calc or Excel would handle that. But, when I print that file in Calc or Excel it doesn't print all the columns. It was then suggested I try Word Tables (Writer equivalent?) but then I read Word Tables would be no better an accommodator. Would Libre Writer be a better choice? I'm not expert using Libre Writer (Tables?) Thank you. Both LO Calc and MSO Excel will do this task for you ... In LO Calc the navigation is ... Format -> Page, select the "Sheet" tab, and at the bottom use "Scaling Factor" to set a reduction percentage. ... you may have to experiment to determine the percentage required for the particular sheet. Also you may want to change the orientation of the page (Portrait - Landscape) ... Format -> Page, select the "Page" tab ... the radio buttons for Portrait and Landscape are a little less than 1/2 the way down Hope that helps Regards Fred James -- 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
Second reply with a REAL answer: WAS: Re: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
Budge wrote: Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. I searched one more time and found this useful information ... Navagate: File -> New -> Label and do all the normal stuff including ... Label Tab enter text for label content select sheet select label brand select label type Format Tab probably just leave that stuff alonw Options Tab select entire page check Synchronize Content (the printer and setup can also be done here) Select New document Along with the "new document" you will get a little dialog box for "Synchronize Labels" Now ... edit the top left label to achieve your desired formating, edge spacing, etc. Click on the Synchronize Labels button. Done Here is the URL for the YouTube that supplied this knowledge. https://www.youtube.com/watch?time_continue=278=qP3NCdRlO8Q=emb_logo Hope that helps Regards Fred James -- 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] Printing 18 labels per sheet on Avery A4 sheet L7161
Budge wrote: Two questions please. I am using Avery A4 L7161 adhesive labels and have opened using the new>label option which gives me the grid in which to type the text. Having selected font and size I find the print is too close to the edge of the label. How may I adjust the margin between the first line of text and the actual label edge. I think the word is kerning and I need to move the text a fraction of the line down on the paper? Once I have typed one label and edited it to suit, is there a quick way to copy the one label to all the labels on the the whole sheet? Grateful for your help please. What I have seen so far is that the LO label is intended to print from a database (such as a list of addresses, and doesn't allow for what you desire ... and by the way, I desire. Sorry, I am no help there. There is a way to change the top and right margins, but that is the distance from the top and left edges of the sheet to the top and left edges of the top, left label ... not really a good answer, eh? Assuming that one wants all the labels on a sheet to be identical, all I have ever been able to do is (as you say) format one label as desired, select and copy the desired area of that label, and past that into each of the other labels on the sheet ... one at a time. Not much help there, I am sure ... I wish to know this as well, if there is any way to do this. But thank you for asking ... it prompted me to search once again for the answer, although the answers I found (once again) point to stuff that is not in LO, at least not in the version I have. Possibly out of date answers? Possibly the answer would vary a lot between OS's? Regards Fred James -- 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] accent characters - RESOLOVED
RESOLVED - compose key was mapped to a key that was being used for something else Regards Fred James Mageia 8 Plasma LibreOffice 7.0.4.2 Liberation Serif In older versions this worked by pressing stuff like , letter but not now? How does one add accented characters to a text document today? Thanks Regards Fred James -- 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] accent characters
Mageia 8 Plasma LibreOffice 7.0.4.2 Liberation Serif In older versions this worked by pressing stuff like , letter but not now? How does one add accented characters to a text document today? Thanks Regards Fred James -- 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] Open two sheets from the same spreadsheet on Mac
I just tested that on Mageia 7, HP p6-2419 ... Linux 5.10.46-desktop-1.mga7 #1 SMP Thu Jun 24 14:55:57 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux ... using LO 6.4.7.2 ... works well Regards Fred James Regina Henschel wrote: Hi Eric, Eric Beversluis schrieb am 15.07.2021 um 00:24: Is there a way to keep two sheets from the same spreadsheet open at the same time, both live? Use menu "Window" > "New Window". Using LO 6.2.8.2 on Mac 10.12.6. I use Windows, I cannot text Mac. Kind regards Regina -- 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] Watermark
Cool! I add my thanks for that ... and I also saw the "watermark" option under "Format/Page style" as well (LO Version 7.4.5.1, under Mageia 8 Linux) ... thanks again Regards Fred James Tom wrote: On 10/28/23 2:41 PM, Joe Conner wrote: I want to use one of my images (.jpg) to a writer page as a watermark. I cannot figure out how to make this work. 1. Can this be done? 2. If yes, then how? Thanks in advance. Yes, this is possible and I've done it in the past. What I've done is: * Use the "Format/Page" menu and click "Area" to set the page background image. Use the "Fill" menu to choose a bitmap, and import your JPEG image. * Then, I use the "Transparency" tab to set transparency of the image, creating a "watermark". This works in Writer 5.1.x and should function similarly in a more current version. Hope this helps! Peace... Tom W -- 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] Sort issue qustion
This may be Linux specific, but please allow the question in case it is not In the file manager (Dolphin) there are options to configure how the sort of directory and file names will appear in the window, for example (the desired output) here) ... 001_zFILE.odt 01_aFILE.odt 01_bFILE.odt 01_cFILE.odt 01_dFILE.odt 01_zFILE.odt whereas in Libreoffice these same file display as ... 01_aFILE.odt 01_bFILE.odt 01_cFILE.odt 01_dFILE.odt 001_zFILE.odt 01_zFILE.odt The issue is more annoying in the "File->Save" window, than in the "File->Open" window, although I would assume that addressing it in one might effect the other? Anything I am missing here? Any help or advise? Thank you Regards Fred James -- 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] pdf forms (OT?)
Mike Scott wrote: Hi all. I've just been looking at making pdf forms with Writer. Easier than I'd thought. I've been able to create a sample form with text fields and open this with xreader, evince or firefox. Firefox is able to display, edit and save a form whatever the content. However, evince and xreader refuse to even show data for radio buttons or a checkbox control and will not alter the settings. Similarly, pdftotext does not print the setting of such a control. I'm not sure this is strictly an LO issue, but has anyone met similar problems with LO-produced forms? I'm working on Mint 21.2 (LO 7.3.7.2), but will need the resulting pdf's to be usable by Windows users too. Oh, and is there any known way (CLI) of extracting the data fields from a pdf form? pdftotext seems rather ham-fisted: surely there's something better! Apologies if this is too far OT; but any advice would be helpful, thanks. Mike Scott Sorry ... not much experienece with LO pdf forms, or LO forms in general, but should very much like to know how your forms might function under Okular. I am willing to try testing that for you, if you could send one of your forms to me attached to an email, but if you have access to Okular, your results would do as well. As a side note: I have had success in using both Firefox and Okular to complete, save, and print, downloaded Adobe Acrobat pdf forms, but not with any other pdf reader. And I have never tested anything recently, on a Windows system as I don't have one. Regards Fred James Mageia 8 64bit, Plaama desktop $ uname -a Linux localhost.localdomain 5.15.126-desktop-1.mga8 #1 SMP Fri Aug 11 21:17:00 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux LO 7.4.5.1 -- 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] pdf forms (OT?)
Mike Scott wrote: On 08/02/2024 18:14, Fred James wrote: Mike Scott wrote: Hi all. I've just been looking at making pdf forms with Writer. Easier than I'd thought. I've been able to create a sample form with text fields and open this with xreader, evince or firefox. Firefox is able to display, edit and save a form whatever the content. However, evince and xreader refuse to even show data for radio buttons or a checkbox control and will not alter the settings. Similarly, pdftotext does not print the setting of such a control. .. Oh, and is there any known way (CLI) of extracting the data fields from a pdf form? pdftotext seems rather ham-fisted: surely there's something better! Apologies if this is too far OT; but any advice would be helpful, thanks. Mike Scott Sorry ... not much experienece with LO pdf forms, or LO forms in general, but should very much like to know how your forms might function under Okular. I am willing to try testing that for you, if you could send one of your forms to me attached to an email, but if you have access to Okular, your results would do as well. Thanks for replying and for the offer. I've now installed Okular, and it does (once forms are enabled) allow editing and saving of the form. Presumably, evince and xreader are both buggy. As well as my own efforts to see how things tick, I've also used the examples at the foot of this useful instructional page: <https://www.linuxuprising.com/2019/02/how-to-create-fillable-pdf-forms-with.html> It still leaves the question of how to extract the data from the completed form. Perhaps I've not hit the right keyword, but I've found /nothing/ on the net. Surely if there's a way of filling in a form, there's one of reading it!! Mike Scott Thank you for your reply on the Okular results ... that answers my question, and I appreciate it. As to extracting data in CLI, my first thought would be to use BASH scripting, Sed or Gawk (or a combination thereof) ... even the Vi editor has some search ability. ... does that help? Regards Fred James -- 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] Emailing calc spreadsheet
Sus Spencer Send the spreadsheet file as an attachment to the email Regards Fred James Sue Spencer wrote: Good afternoon I have made a spreadsheet using Libre calc. When I print the spreadsheet off, it runs to 19 pages. However, when I email the spreadsheet to another party, only the first sheet goes with the email. The calc spreadsheet, at the bottom, shows "sheet 1" but it is many pages long. Can you please tell me how I can email this spreadsheet in such a way that all of the pages are sent, in other words, so that the recipient can see all of the data and not only that which appears on the first page. Thank You and Best Regards, Sue Spencer -- 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] Labels created in Writer shifts downward while printed
Ian Bertram wrote: I've had similar issues with user defined labels. Make sure to check the spacing between labels is correctly set. If it is fractionally out, you will get this sort of cumulative increase in misalignment. On Mon, 25 Mar 2024, 22:27 Paul D. Mirowsky, wrote: A shat in the dark... * A blank or unseen line at last table row cell(s) * Incorrect metric vs decimal inch calculation forcing a mismatch between software and printer * header or footer is not zero in length * Select all and right click "clear direct formatting" Hope this helps. On 3/22/24 20:13, Hartman Tam wrote: Hello all, I'm creating some labels in Writer. After it being printed, each label shifted downward gradually. This happens with and without any formatting. I have checked I have my label setup correctly. I also tried disabled my printer's scaling but doesn't help. My printer is Brother MFC-L2710DW. Did I miss anything? How can I solve this? LibreOffice version: * Version: 7.3.7.2 / LibreOffice Community * Build ID: 30(Build:2) * CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 * Locale: en-GB (en_GB.UTF-8); UI: en-GB * Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4 * Calc: threaded Jumbo The label I'm using: https://www.amazon.co.uk/gp/product/B093TM72T7 Thanks, Hartman -- 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 Is it possible that there is a page size to paper size mismatch? Regards Fred James -- 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] Changing the color of the selected cell in calc
Thane K. Sherrington wrote: Hi all, Is there a way to change the colour of the selected cell in calc to make it easier to see which sell is selected? Even if the outline of the cell can be made darker. I'm on Windows 10. Do you mean that the selected cell should change colour only for the time during which it is selected? Regards Fred James -- 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