[libreoffice-users] Re: [SOLVED] Calc sheet freezing
V Stuart Foote wrote Several ways of answering this come to mind, but I'll go with the gentler tact. You have some questions to ask yourself (and your collaborators). What is your desired end use--will this Excel 2003 spread sheet continue to be used on Excel 2003? If not will your use be exclusively on LibreOffice or a mix of Apache OpenOffice and LibreOffice? Do you or some number of your users understand what data is being charted and how? Are you (they) familiar with both the Microsoft macros and the LibreOffice macros? Where I'm going is that depending on your intended use, you will need to --port-- the spread sheet either for use in calc. But likely for use in Excel 2007, or 2010 or 2012-- there is that much variation in the macro scripting between the Microsoft products. Sorry, but without seeing the function and logic of your existing spread sheet, the most we'll be able to do is suggest steps in doing a port. Thanks for the insight. Sorry it's taken so long to reply. After discussing with 'the powers that be', the decision was to recreate the data and graphs in Calc. Our goal is to get rid of MSO, so we need to move forward. Some users will still use MSO until we can get everyone moved to Libre office. Their concern was in opening 'older. legacy versions' of the spreadsheet. We have that covered for now. After spending a couple of days working on the spreadsheet in Calc, we have not encountered the 'freezing up' problem. Must have been MSO that was acting strange! -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-freezing-tp4048140p4049026.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Frame Names vs. Table Names
Frame names can contain white space. Table names to not allow whitespace. This, IMNSHO, is annoying. Is there a reason for this distinction? Does anyone know of an open bug report relating to this issue? -- Adam Tauno Williams GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Bug 63388: Mail Merge Email
I have filed this bug because I can not get LibreOffice to test the settings I enter into Tools Options LibreOffice Writer Main Merge. It freezes everytime. All the information I enter is copied from the Account Settings in Thunderbird. I have verified that the password I entered will open Gmail on the Google website. I use IMAP rather than POP3. Do others have this problem? Is there something special that I am not doing to cause LO to freeze when running this test? --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [SOLVED] Calc sheet freezing
On Wed, 2013-04-10 at 05:49 -0700, Karen DInse wrote: V Stuart Foote wrote Several ways of answering this come to mind, but I'll go with the gentler tact. You have some questions to ask yourself (and your collaborators). What is your desired end use--will this Excel 2003 spread sheet continue to be used on Excel 2003? If not will your use be exclusively on LibreOffice or a mix of Apache OpenOffice and LibreOffice? Do you or some number of your users understand what data is being charted and how? Are you (they) familiar with both the Microsoft macros and the LibreOffice macros? Where I'm going is that depending on your intended use, you will need to --port-- the spread sheet either for use in calc. But likely for use in Excel 2007, or 2010 or 2012-- there is that much variation in the macro scripting between the Microsoft products. Sorry, but without seeing the function and logic of your existing spread sheet, the most we'll be able to do is suggest steps in doing a port. Thanks for the insight. Sorry it's taken so long to reply. After discussing with 'the powers that be', the decision was to recreate the data and graphs in Calc. Our goal is to get rid of MSO, so we need to move forward. Some users will still use MSO until we can get everyone moved to Libre office. Their concern was in opening 'older. legacy versions' of the spreadsheet. We have that covered for now. After spending a couple of days working on the spreadsheet in Calc, we have not encountered the 'freezing up' problem. Must have been MSO that was acting strange! -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-freezing-tp4048140p4049026.html Sent from the Users mailing list archive at Nabble.com. I use Calc a lot for various simulation tasks, and with the installation of F17, I have had numerous new spreadsheets behave very badly with any graph I put in them. The hard to believe part is that older spreadsheets, created with F15 and before all work well. I have basically held off on some new work because this is too difficult to resolve. Moreover, if I play with various things from time to time I will get it to run as before, but I cannot get a consistant setup that makes it so. I did submit a bugzilla earlier, but have not seen any response that showed a fix. Basically any new graph seems to completely refresh the screen and take a very long time, about 1 or 2 seconds for every cell used in the graph. If more information will help, ask and I will send what I can. Regards, Les Howell. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: [SOLVED] Calc sheet freezing
Hi :) I find that stuff converted from MSO formats is not always as good as a fresh re-write or rather create a new document and then copypaste all the old stuff in from the older document but use Shift v and paste in as Unformatted text. MSO likes to hide all sorts of weird nasty coding and formatting into their documents so a fresh start can be a huge step forwards and even odd extras such as reduced file-sizes a little bit. Office workers used to start new documents by grabbing an old one and deleting everything out of it and then starting from there. All sorts of information about previous authors and ancient systems logged in the coding. It would not surprise me to find documents mentioning Win95 and Word Perfect. Decluttering is a good move. Regards from Tom :) From: les hlhow...@pacbell.net To: Karen DInse kdi...@rrwrd.dst.il.us Cc: users@global.libreoffice.org Sent: Wednesday, 10 April 2013, 17:34 Subject: Re: [libreoffice-users] Re: [SOLVED] Calc sheet freezing On Wed, 2013-04-10 at 05:49 -0700, Karen DInse wrote: V Stuart Foote wrote Several ways of answering this come to mind, but I'll go with the gentler tact. You have some questions to ask yourself (and your collaborators). What is your desired end use--will this Excel 2003 spread sheet continue to be used on Excel 2003? If not will your use be exclusively on LibreOffice or a mix of Apache OpenOffice and LibreOffice? Do you or some number of your users understand what data is being charted and how? Are you (they) familiar with both the Microsoft macros and the LibreOffice macros? Where I'm going is that depending on your intended use, you will need to --port-- the spread sheet either for use in calc. But likely for use in Excel 2007, or 2010 or 2012-- there is that much variation in the macro scripting between the Microsoft products. Sorry, but without seeing the function and logic of your existing spread sheet, the most we'll be able to do is suggest steps in doing a port. Thanks for the insight. Sorry it's taken so long to reply. After discussing with 'the powers that be', the decision was to recreate the data and graphs in Calc. Our goal is to get rid of MSO, so we need to move forward. Some users will still use MSO until we can get everyone moved to Libre office. Their concern was in opening 'older. legacy versions' of the spreadsheet. We have that covered for now. After spending a couple of days working on the spreadsheet in Calc, we have not encountered the 'freezing up' problem. Must have been MSO that was acting strange! -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-freezing-tp4048140p4049026.html Sent from the Users mailing list archive at Nabble.com. I use Calc a lot for various simulation tasks, and with the installation of F17, I have had numerous new spreadsheets behave very badly with any graph I put in them. The hard to believe part is that older spreadsheets, created with F15 and before all work well. I have basically held off on some new work because this is too difficult to resolve. Moreover, if I play with various things from time to time I will get it to run as before, but I cannot get a consistant setup that makes it so. I did submit a bugzilla earlier, but have not seen any response that showed a fix. Basically any new graph seems to completely refresh the screen and take a very long time, about 1 or 2 seconds for every cell used in the graph. If more information will help, ask and I will send what I can. Regards, Les Howell. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Frame Names vs. Table Names
Le 10/04/2013 15:08, Adam Tauno Williams a écrit : Frame names can contain white space. Table names to not allow whitespace. This, IMNSHO, is annoying. Is there a reason for this distinction? Does anyone know of an open bug report relating to this issue? +1 This is an inconsistency. I'd add that image and section naming should be consistent with frame and table naming as well. -- Jean-Francois Nifenecker, Bordeaux -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Am I the only one with Err 522 problems?
Hi :) Are you sure the circular reference errors really are false? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Am-I-the-only-one-with-Err-522-problems-tp4047558p4049109.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Writer - word wrap problem when image is left of the margin.
Hi :) Sorry chap! Your message didn't reach the mailing list. Have you subscribed to the mailing list or only to Nabble? I'm not completely sure which margin you are talking about. 1. If you right-click on an image and choose Picture or Frame or whatever then a sophisticated pop-up appears with tons of tabs. One of the early ones, i think 2nd or 3rd, has wrap options a the bottom that relate to space around the image. If it's not behaving then set new values. Close the pop-up and then reopen again and set you values back to the way you wanted them. See if that shakes the problem loose. 2. If you mean page margins i'm sure you can figure at least 2 good ways to change them Regards from Tom :) Michael wrote I have a document with a 2 inch margin (on the left). If I place an image/picture in that paragraph, the word wrap around the picture wraps as expected. If I move that picture to the left of the left (2 inch) margin (starting 1.5 inches from the left) a 2 inch margin is created on the right side of the image. Does anyone have a work around for this? (can we remove the 2 inch margin from the right of the image) For more info (pictures and an uploaded writer document with a picture) please see bug: https://bugs.freedesktop.org/show_bug.cgi?id=62867 -- View this message in context: http://nabble.documentfoundation.org/Writer-word-wrap-problem-when-image-is-left-of-the-margin-tp4046935p4049111.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Auto capitalization doesn't work with auto curly quotes.
Hi :) Have you been able to solve this problem yet? If not it might be worth asking the list again. I think you were just unlucky with timing there. Good luck and regards from Tom :) From: Hillel Ḥayyim Lavery-Yisraëli hillel.yisra...@gmail.com To: users@global.libreoffice.org Sent: Wednesday, 3 April 2013, 18:52 Subject: [libreoffice-users] Auto capitalization doesn't work with auto curly quotes. When I am using automatic smart quotes, the Capitalize First Letter of Sentence feature doesn't work properly if the first word of the sentence contains an apostrophe or a quotation mark. Furthermore, it won't automatically capitalize the 'I' in words like I'll, I'm and so on if I'm using curly quotes. The following example was typed without hitting the shift key once: *This's how it looks when I am not using curly quotes. And now i’ve enabled curly ones. this’s how it looks now.* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Fractions in Maths
Hi :) I thought that was what Math was for? For simple equations as quoted it might seem strange to have a separate app to do that sort of thing but most people really don't need extra weight in Writer to do something they never do anyway. It might be nice if it could handle simple things like 1/2 but aren't there special characters for most of those anyway? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Fractions-in-Maths-tp4047979p4049128.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Fwd: [libreoffice-users] Re: Fractions in Maths
Forgot to include the list again, sorry… -- Forwarded message -- From: Johnny Rosenberg gurus.knu...@gmail.com Date: 2013/4/10 Subject: Re: [libreoffice-users] Re: Fractions in Maths To: Tom tomdavie...@yahoo.co.uk 2013/4/10 Tom tomdavie...@yahoo.co.uk: Hi :) I thought that was what Math was for? For simple equations as quoted it might seem strange to have a separate app to do that sort of thing but most people really don't need extra weight in Writer to do something they never do anyway. It might be nice if it could handle simple things like 1/2 but aren't there special characters for most of those anyway? Regards from Tom :) Yes, there are. I put some of them on my keyboardlayout: ⅛ ¼ ⅜ ½ ⅝ ¾ ⅞ ⅓ ⅔ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ These are all UTF-8 characters. There are also sub- and superscript numbers: ₀₁₂₃₄₅₆₇₈₉⁰¹²³⁴⁵⁶⁷⁸⁹, so things like ⁴/₉ can be done… But the OP wanted a horizontal division separator, on the other hand… Johnny Rosenberg -- View this message in context: http://nabble.documentfoundation.org/Fractions-in-Maths-tp4047979p4049128.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Fractions in Maths
Tom wrote: Hi :) I thought that was what Math was for? For simple equations as quoted it might seem strange to have a separate app to do that sort of thing but most people really don't need extra weight in Writer to do something they never do anyway. It might be nice if it could handle simple things like 1/2 but aren't there special characters for most of those anyway? Regards from Tom :) It's not in Writer. It's a separate app (at least in the LO meaning of separate) that provides the function of creating nice looking math equations, just like you see in text books. You don't have to use it, if you don't want to. As for special characters, use the U.S. International keyboard layout, so that you can easily use characters like: ¹²³¤£€¼½¾¥×÷ and more. https://en.wikipedia.org/wiki/AltGr_key#US_international -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Fractions in Maths
2013/4/10 Tom tomdavie...@yahoo.co.uk: Hi :) I thought that was what Math was for? For simple equations as quoted it might seem strange to have a separate app to do that sort of thing but most people really don't need extra weight in Writer to do something they never do anyway. I think he wants Writer (or even Calc) to be able to create a LibreOffice Math object with the auto correction feature. He types 355/113 and after hitting space, it will be replaced by a LibreOffice Math object that you normally create by opening LibreOffice Math and type ”355 over 113”. It seems like he also wants at least LibreOffice Calc to be able to use it for calculations, making the 355 over 113 object approximately equal to 3.14159292. Johnny Rosenberg It might be nice if it could handle simple things like 1/2 but aren't there special characters for most of those anyway? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/Fractions-in-Maths-tp4047979p4049128.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Fractions in Maths
On 04/10/2013 03:48 PM, Tom wrote: Hi :) I thought that was what Math was for? For simple equations as quoted it might seem strange to have a separate app to do that sort of thing but most people really don't need extra weight in Writer to do something they never do anyway. It might be nice if it could handle simple things like 1/2 but aren't there special characters for most of those anyway? Regards from Tom :) If you just want simple fractions, you can set up a compose key in Linux, or use AllChars in Windows, to make ½ ⅓ ¼ ⅕ ⅙ ⅛. This works in all apps, even in the terminal. It also makes lots of other things. like all the diacritical marks on letters ä, ö ü, ñ, ç ß à á è é ì and µ € ¥ £ ¢ etc. --doug -- Blessed are the peacemakers...for they shall be shot at from both sides. A.M. Greeley -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libreoffice and Gtk+-3's themes
The GTK3 port is not finished https://wiki.documentfoundation.org/Development/Gsoc/Ideas#Finish_the_Gtk.2B3_port. I don't think there's another way than rebuilding with GTK2. Am 29.03.2013 10:47, schrieb konsolebox: Hi. I have Libreoffice built with GTK+ 3. After building and running I noticed that the appearance of its dialog boxes, menus and buttons are just plain. Is LO really configured to be just that knowing that LO with GTK3 is still under development/experimental stage? I mean if it doesn't follow themes of Gtk3? I know we could just revert back to Gtk2 but I don't want to build LO again if possible. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] need tips on ledger/tabloid printing of newsletter
I need some tips on the best way to set up Writer for printing newsletter using the 11 by 17 inch ledger/tabloid paper stock, where there are two 8.5 by 11 panels per side of the sheets. I now have a printer that will use that wide format paper, but I never set up a document to use it. I want to have each half-sheet [letter size] to have 2 or 3 columns of text and graphics. So is there anyone on the lists that have set up a document with Writer to print out newsletter pages on this wide format paper? I normally took the letter size sheets and placed them sideby side on a 11x17 copier or had the office store printing department do the work for me. I think printing on a tabloid sheet and then folding it in half works much better than using letter size paper and putting a staple in the corner. Since this was the last box they had of the printer that was over half off, to make room for the newer model that had duplexing, I just had to buy it, since I would never see a wide format printer at this low of a price that included 2 years of replacement warranty. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Writer - word wrap problem when image is left of the margin.
Hi. I have confirmed the bug but can't change the status to confirmed. Steve. On 2013-04-11 06:46, Tom wrote: Hi :) Sorry chap! Your message didn't reach the mailing list. Have you subscribed to the mailing list or only to Nabble? I'm not completely sure which margin you are talking about. 1. If you right-click on an image and choose Picture or Frame or whatever then a sophisticated pop-up appears with tons of tabs. One of the early ones, i think 2nd or 3rd, has wrap options a the bottom that relate to space around the image. If it's not behaving then set new values. Close the pop-up and then reopen again and set you values back to the way you wanted them. See if that shakes the problem loose. 2. If you mean page margins i'm sure you can figure at least 2 good ways to change them Regards from Tom :) Michael wrote I have a document with a 2 inch margin (on the left). If I place an image/picture in that paragraph, the word wrap around the picture wraps as expected. If I move that picture to the left of the left (2 inch) margin (starting 1.5 inches from the left) a 2 inch margin is created on the right side of the image. Does anyone have a work around for this? (can we remove the 2 inch margin from the right of the image) For more info (pictures and an uploaded writer document with a picture) please see bug: https://bugs.freedesktop.org/show_bug.cgi?id=62867 -- View this message in context: http://nabble.documentfoundation.org/Writer-word-wrap-problem-when-image-is-left-of-the-margin-tp4046935p4049111.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Printing speed is glacial for large file
I have a project managed by an odm file that ends up being ca 1600 pages long and contains several OLE objects, many graphics (some comprising entire pages that started out as PDFs). I find LO unbelievably slow (even on such simple things as refreshing the window after remapping it). I've turned of recording/displaying changes, upped the graphics cache numbers, set the swap directory to a ram disk, and turned off all to-disk swapping; nothing helps. This is on a 2 CPU machine with gig's of ram. I'm currently trying to print the project to a file (postscript format). This takes 4-6 hours, with 1 of the CPU's running at 100% [BTW is LO multi-threaded?]. The resulting postscript file is big, (about 350M) but not that big. I'm on a Slackware Linux box. Any suggestions? David -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing speed is glacial for large file
On 04/10/2013 06:13 PM, David Ronis wrote: I have a project managed by an odm file that ends up being ca 1600 pages long and contains several OLE objects, many graphics (some comprising entire pages that started out as PDFs). I find LO unbelievably slow (even on such simple things as refreshing the window after remapping it). I've turned of recording/displaying changes, upped the graphics cache numbers, set the swap directory to a ram disk, and turned off all to-disk swapping; nothing helps. This is on a 2 CPU machine with gig's of ram. I'm currently trying to print the project to a file (postscript format). This takes 4-6 hours, with 1 of the CPU's running at 100% [BTW is LO multi-threaded?]. The resulting postscript file is big, (about 350M) but not that big. I'm on a Slackware Linux box. Any suggestions? David Which version of LO are you using? That might help with some answers. Have you made any modification the default settings of ToolsOptionsLibreOfficeMemory ? I know that some people have seen some good results with the increasing of the different options for the memory usage for a document. Large ones that has a lot of object/graphics/images could use more cache memoryand a larger number of objects. Then if you are not doing much editing, the reduction of the Undo - number of steps could free up some needed memory and response time for the document. The 1600 pages long and many graphics can slow down any system, when you are converting the file to a postscript format. By-the-way - what are you using for the print-to-postscriptprocess? I do not see that as a included part of LO 4.0.2. Are you printing it to a postscript printer but are saving it to a file instead of printing out to paper? That process would give our users some idea on the process and my have some of the try some things that might find some answers. I use Ubuntu 12.04 with 2 HP printers [inkjet and laser], 1 Epson inkjet, and 1 Canon inkjet. None defaults to a postscript, but the HP laser has a postscript driver. I may install it and do some testing myself. OK, I installed the foomatic-postscript driver for the laser printer. It can print to a file. But would I need it to usethe generic postscript printer driver to make it device independent as you seem to want it to be by printing the file to a postscript file? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] pasting numbers into Calc
This question seems to have been discussed before, but none of the replies I understand work for me. Here it goes: If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct text-to-column delimiters, all columns (including the numbers) are interpreted as text. On closer inspection I find that at the start of each number there is a single quote (invisible in Calc, but I can delete it with backspace, and then the number is recognized as such). Doing it manually cell by cell is the only way that works. Paste special as number or as text doesn't work. Search and replace doesn't work (or I do it wrong). I don't think it's the locale; else the aforementioned manual delete of the quote wouldn't work. Writing macros is beyond my abilities (I don't know the language and I don't know where and how to enter them. If something that straight-forward requires complex programming, the software is broken). This is LibreOffice 3.4 on Linux Mint. The column-based text is just copied from an xterm with the mouse. I have used OpenOffice and derivatives for years, but this one stumps me. Any ideas? Herbert -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] pasting numbers into Calc
On 2013-04-11 11:36, Herbert Fruchtl wrote: This question seems to have been discussed before, but none of the replies I understand work for me. Here it goes: If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct text-to-column delimiters, all columns (including the numbers) are interpreted as text. On closer inspection I find that at the start of each number there is a single quote (invisible in Calc, but I can delete it with backspace, and then the number is recognized as such). Doing it manually cell by cell is the only way that works. Paste special as number or as text doesn't work. Search and replace doesn't work (or I do it wrong). I don't think it's the locale; else the aforementioned manual delete of the quote wouldn't work. Writing macros is beyond my abilities (I don't know the language and I don't know where and how to enter them. If something that straight-forward requires complex programming, the software is broken). This is LibreOffice 3.4 on Linux Mint. The column-based text is just copied from an xterm with the mouse. I have used OpenOffice and derivatives for years, but this one stumps me. Any ideas? Herbert Hi. What are you copying from. A calc sheet, a document, a web page. The ' in front explicitly formats as text. Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Adding values to CSV File via Terminal
Hi All, I have files that have a ton of info and what I want to do is add a new column that's date pulled that is based on the file name (which is of course the date). So for instance I have 2013_01_15.csv I would like a column at the end of the data where every row in the file has 2013_01_15. Is there an easy easy to accomplish this? Thanks all! Best, Joel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Printing speed is glacial for large file
Hi :) I think swap doesn't get used much these days. Can you try free -m before and during the process? If swap is not being used even when it's in Ram then perhaps either stop using the ram-drive or increase swappiness? I have 2Gb Ram but only about half that ever gets used and that's only when i really push the machine with games and video Regards from Tom :) From: Kracked_P_P---webmaster webmas...@krackedpress.com To: users@global.libreoffice.org Sent: Thursday, 11 April 2013, 1:01 Subject: Re: [libreoffice-users] Printing speed is glacial for large file On 04/10/2013 06:13 PM, David Ronis wrote: I have a project managed by an odm file that ends up being ca 1600 pages long and contains several OLE objects, many graphics (some comprising entire pages that started out as PDFs). I find LO unbelievably slow (even on such simple things as refreshing the window after remapping it). I've turned of recording/displaying changes, upped the graphics cache numbers, set the swap directory to a ram disk, and turned off all to-disk swapping; nothing helps. This is on a 2 CPU machine with gig's of ram. I'm currently trying to print the project to a file (postscript format). This takes 4-6 hours, with 1 of the CPU's running at 100% [BTW is LO multi-threaded?]. The resulting postscript file is big, (about 350M) but not that big. I'm on a Slackware Linux box. Any suggestions? David Which version of LO are you using? That might help with some answers. Have you made any modification the default settings of ToolsOptionsLibreOfficeMemory ? I know that some people have seen some good results with the increasing of the different options for the memory usage for a document. Large ones that has a lot of object/graphics/images could use more cache memoryand a larger number of objects. Then if you are not doing much editing, the reduction of the Undo - number of steps could free up some needed memory and response time for the document. The 1600 pages long and many graphics can slow down any system, when you are converting the file to a postscript format. By-the-way - what are you using for the print-to-postscriptprocess? I do not see that as a included part of LO 4.0.2. Are you printing it to a postscript printer but are saving it to a file instead of printing out to paper? That process would give our users some idea on the process and my have some of the try some things that might find some answers. I use Ubuntu 12.04 with 2 HP printers [inkjet and laser], 1 Epson inkjet, and 1 Canon inkjet. None defaults to a postscript, but the HP laser has a postscript driver. I may install it and do some testing myself. OK, I installed the foomatic-postscript driver for the laser printer. It can print to a file. But would I need it to usethe generic postscript printer driver to make it device independent as you seem to want it to be by printing the file to a postscript file? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Writer - word wrap problem when image is left of the margin.
Hi :) Does it let you post a comment to say that you have been able to replicate the problem? Your OS and the version of LO might be helpful too It's a bit weird it doesn't let you change the status and the only work-around i can think of is to post a comment. Thanks, apols and regards from Tom :) From: Steve Edmonds steve.edmo...@ptglobal.com To: Tom tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org Sent: Wednesday, 10 April 2013, 22:25 Subject: Re: [libreoffice-users] Re: Writer - word wrap problem when image is left of the margin. Hi. I have confirmed the bug but can't change the status to confirmed. Steve. On 2013-04-11 06:46, Tom wrote: Hi :) Sorry chap! Your message didn't reach the mailing list. Have you subscribed to the mailing list or only to Nabble? I'm not completely sure which margin you are talking about. 1. If you right-click on an image and choose Picture or Frame or whatever then a sophisticated pop-up appears with tons of tabs. One of the early ones, i think 2nd or 3rd, has wrap options a the bottom that relate to space around the image. If it's not behaving then set new values. Close the pop-up and then reopen again and set you values back to the way you wanted them. See if that shakes the problem loose. 2. If you mean page margins i'm sure you can figure at least 2 good ways to change them Regards from Tom :) Michael wrote I have a document with a 2 inch margin (on the left). If I place an image/picture in that paragraph, the word wrap around the picture wraps as expected. If I move that picture to the left of the left (2 inch) margin (starting 1.5 inches from the left) a 2 inch margin is created on the right side of the image. Does anyone have a work around for this? (can we remove the 2 inch margin from the right of the image) For more info (pictures and an uploaded writer document with a picture) please see bug: https://bugs.freedesktop.org/show_bug.cgi?id=62867 -- View this message in context: http://nabble.documentfoundation.org/Writer-word-wrap-problem-when-image-is-left-of-the-margin-tp4046935p4049111.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Adding values to CSV File via Terminal
Hi. First thoughts I would do that with a bash or perl script. Steve On 2013-04-11 12:47, Joel Madero wrote: Hi All, I have files that have a ton of info and what I want to do is add a new column that's date pulled that is based on the file name (which is of course the date). So for instance I have 2013_01_15.csv I would like a column at the end of the data where every row in the file has 2013_01_15. Is there an easy easy to accomplish this? Thanks all! Best, Joel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users]
-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Adding values to CSV File via Terminal
On 04/10/2013 06:18 PM, Steve Edmonds wrote: Hi. First thoughts I would do that with a bash or perl script. Steve Suggestion on a quick script to do this? Would make some LibreOffice QA work quite a bit easier :) Best, Joel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Adding values to CSV File via Terminal
On 04/10/2013 08:47 PM, Joel Madero wrote: Hi All, I have files that have a ton of info and what I want to do is add a new column that's date pulled that is based on the file name (which is of course the date). So for instance I have 2013_01_15.csv I would like a column at the end of the data where every row in the file has 2013_01_15. Is there an easy easy to accomplish this? Thanks all! Best, Joel If the file has less than about 1,000,000 rows an easy why is to import into Calc, add the column, and then save it as a csv file. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] pasting numbers into Calc
On 04/10/2013 07:36 PM, Herbert Fruchtl wrote: This question seems to have been discussed before, but none of the replies I understand work for me. Here it goes: If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct text-to-column delimiters, all columns (including the numbers) are interpreted as text. On closer inspection I find that at the start of each number there is a single quote (invisible in Calc, but I can delete it with backspace, and then the number is recognized as such). Doing it manually cell by cell is the only way that works. Paste special as number or as text doesn't work. Search and replace doesn't work (or I do it wrong). I don't think it's the locale; else the aforementioned manual delete of the quote wouldn't work. Writing macros is beyond my abilities (I don't know the language and I don't know where and how to enter them. If something that straight-forward requires complex programming, the software is broken). This is LibreOffice 3.4 on Linux Mint. The column-based text is just copied from an xterm with the mouse. I have used OpenOffice and derivatives for years, but this one stumps me. Any ideas? Herbert I would do this: Import the data into a sheet (pasting), say column a In the adjacent column b enter the formula =value(a1) in cell b1. If you wish you can save the original data on another sheet (say Sheet2) and then the formula is =value(Sheet2.a1) -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] pasting numbers into Calc
At 23:36 10/04/2013 +, Herbert Fruchtl wrote: This question seems to have been discussed before, but none of the replies I understand work for me. So what have you tried, in fact? If I copy a column-based piece of text, containing numbers in some columns, into LibreOffie Calc and apply the (hopefully) correct text-to-column delimiters, ... I'm not sure what you mean here. What are delimiters? Do you mean that you have, say, quote marks around your data? Is this perhaps a .CSV file? ... all columns (including the numbers) are interpreted as text. Then you presumably don't have this part correct, in fact! On closer inspection I find that at the start of each number there is a single quote (invisible in Calc, but I can delete it with backspace, and then the number is recognized as such). That leading single quote does not really exist in the cell; instead it appears in the Input Line to show that what appears to be a number is actually being stored in the cell as a text string - exactly what you don't want. You will also notice that, by default, the numbers-as-text are left aligned, whereas true numbers are right-aligned. Doing it manually cell by cell is the only way that works. No, there is a better method: read on! Paste special as number or as text doesn't work. You cannot Paste Special *as* anything; you can select only *what* you paste. If, as here, you have text, you can use Paste Special to select whether or not you paste it somewhere else, but not to change it to numbers. Search and replace doesn't work (or I do it wrong). That's right: the quote marks are not really there in the cell, so you cannot search for them. I have used OpenOffice and derivatives for years, but this one stumps me. Any ideas? Yes. But what works will depend on exactly what is going wrong for you. o Are the relevant destination cells already formatted as Text before you paste in the material? Ensure that they are formatted as General or Number instead. o When you paste the material in, do you see the Text Import panel? Can you tinker with the options there to achieve what you need? In particular, does Merge delimiters help? What are the column types indicated in the panel at the bottom of the panel? You can click each column and then adjust the column type using the drop-down menu. You probably need Standard, not Text. o In any case, you can solve the problem with your incorrect data. Suppose your data is in column A. In row 1 of a spare column, enter =VALUE(A1) and fill this formula down the column (and possibly across columns). The VALUE() function should take your text strings and convert them to true numbers. Now copy the data from the new column(s) and paste it back over the original data, but using Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste. In the Paste Special dialogue, remove the tick from Paste all if necessary, and then ensure that Numbers is ticked but Formulas is not ticked. (Note that freezing the result of a formula into a plain value in this way is something you *can* do using Paste Special... .) I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Links to files on Migration to LO
I have just converted a Calc application from the Apache OpenOffice to LibreOffice. When I now launch the application in LO I receive a message advising: This file contains links to other files. Should they be updated? If I select Yes I then get a further message advising: The following external file could not be loaded. Data linked from this file did not get updated. file:///c:Users/Owner/Documents/h This is repeated for files i, l ,m ,s ,t and x If I select No, the application appears to launch OK. Does anyone have any idea what these files are and what is the consequence of not updating them -- In fact it appears I don't have then at all. I've searched my system for /Documents/h etc but haven't found anything. Thanks for any assistance Felix -- View this message in context: http://nabble.documentfoundation.org/Links-to-files-on-Migration-to-LO-tp4049209.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
