Re: [Bulk] Re: [libreoffice-users] libreoffice 4.4.0.2 on opensuse 13.2 tumbleweed, kde 4.14.4
ianseeks wrote: On Monday 26 Jan 2015 19:18:24 Tim Lloyd wrote: Hi Ian, I am assuming this is an existing document. Not new? Any document in particular or any? An exisitng ODT, nothing complicated in the file, just text Is the CTRL-C the first thing you do? Highlight with mouse then Ctrl-c, the How big is the text you highlight? 2 pages No problems in previous versions I assume! with one of the 4.3 releases that was just before the 4.4 release but i didn;t take note of the version. Any other info would be useful to track this down. I had a go on Fedora/Cinnamon but I can't break it. it doesn;t happen every time so unfortunately i can't reproduce at will. under the 4.3 version i was actually copying text from a browser to paste into the exisitng Writer document. But on 4.4 i was copying the text from ODT and the creating a new ODT document to paste into, it created the new empty text document but that was as far as it got before it died I don't know if it's related, but there was previously an issue where pasting content including images from a web page sometimes froze LibreOffice while it downloaded the images. If the images were large, or you're on a slow connection, it could take a while and appear completely unresponsive. That was discussed on bug 60415 https://bugs.documentfoundation.org/show_bug.cgi?id=60415, and seemed to be fixed in 4.3.0.4. Always possible that it's regressed though. If the pasted images are linked to the original content (so that they automatically update), it might also connect back to the original web site when copying that content from one document to another. Perhaps check Edit Links on the source document and try breaking any links listed there before copying (unless, of course, you want the images to remain linked so that they automatically update in your document when they change online). If this is the problem, and you want to avoid the delays when pasting content from a web page, you can use Edit Paste Special Unformatted Text to get the text, then individually copy any images you want and use Edit Paste Special Bitmap (or anything other than one of the HTML or Unformatted Text options). The text and images won't be formatted as they were on the original web page, but that's not always a bad thing as you'll be starting from a relatively clean state to format as you like. Cheers I think i'll just have to keep my eye on it and see if it happens again THanks for your reply -- 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] Product support question please!
dpregan54 wrote: PLEASE NOTE = Please forward this email to the people who handle product support questions for LibreOffice Writer. Dear Sir or Ms., I have been a very please long time user of your various products especially your writer product but now I have a question which I can not find the answer to and here is my question: +) I am attempting to build an HTML Business Plan because I want several people to read it and I do not know what kind of word processors they will be using. In the Business Plan I wish to have a Sound Track so to speak playing a certain song while they are reading the business plan. Personally, if I open a web page (or other HTML document) and it automatically starts playing music or other sounds, my immediate reaction is to close that page. It's just an annoyance, particularly in an office etc. where it also disturbs everyone else. I might mute the sound on my PC and then reopen the page, but more often I just don't bother. If you want people to actually read your business plan, it may be better NOT to play music in the background as soon as they open it! I attempted to insert Sound using the insert Movie Sound command but whatever sound I attempt to insert it always tells me that it is the wrong format. I have searched online and read the LibreOffice Writer owners manual to no avail AND I AM HOPING THAT YOU CAN HELP ME WITH THIS PROBLEM. +) WHAT AUDIO FORMATS ARE ACCEPTABLE IN LibreOffice Writer? I'm not sure about that, although from Luuk's response it looks like at least MP3 should work. It will also depend on the formats supported by web browsers, although MP3 should be fine there. And if you're emailing this document, rather than hosting it on a web server, you'll also need to email the sound file separately, and instruct your readers/listeners to extract both files to an appropriate folder for the sound to work. I thank you in advance for your assistance. Very truly yours, Dennis Regan -- 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] Search key working intermittently for values
WEDLOCO wrote: Thanks Tom for your quick response and suggestion - and also all others who have contributed. Downloaded the Still version 4.2.8 but same thing is happening. Worked 1st time I entered a value in find and then when I changed the amount Search key not found. I entered different amounts from different cells to test and it can find some values but not others??? They are all formatted as numbers e.g.: 1234.12. No formulas in cells. These are bank statements downloaded as .cvs files then changed to .ods files in Libra to check against receipts. Cheers. Evie. Briefly experimenting with this, it seems that if there is a value of 1234.1 in a cell, it is found when searching for 1234.1 but not when searching for 1234.10 - even if it is formatted to display two decimal places. Could that be what you're seeing? Additionally, a cell containing 1234.12 is found by a search for either 1234.12 or 1234.1, which makes it more difficult to find 1234.10 but not 1234.12. It is possible though, by using Edit Find and Replace, entering 1234.1 as the search term, and selecting the Entire cells option; that will then find a cell containing 1234.1 but not 1234.12. This does seem potentially confusing. If this is the problem you're seeing, it may be worth filing an enhancement request at https://www.libreoffice.org/get-help/bug/. After filling in the details but before submitting, check the list of Related bug reports. If any of those describe the same problem, it's better to add information there instead of submitting a new report. Mark. -- 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] Search key working intermittently for values
I'm not sure I understand what you mean by the full amount/value? Are you able to give an example of what you're entering in Find, and the values in some cells in your sheet which you'd expect that to find? A more concrete example showing what I was trying to describe... If you have a sheet displaying the following values: 9876.00 9876.50 9876.54 The actual values of the cells are: 9876 9876.5 9876.54 (they're just displayed with two decimal places because of the formatting applied to the cells) If you search for 9876.54, it finds the cell containing 9876.54; so far so good. If you search for 9876.5, it finds the cell containing 9876.5, and also the cell containing 9876.54; also fine, but probably not very helpful in your case. If you search for 9876.50, it DOES NOT find anything - which is probably not what you'd expect (I'd have expected it to find that cell containing 9876.5). To find cells displaying 9876.50 but not other values (such as 9876.54), it seems you need to use the Find Replace dialog, search for 9876.5, and select the Entire cells option. This may present other problems, for example it wouldn't find a value 9876.501, even though that would be displayed as 9876.50. Mark. WEDLOCO wrote: Hi Mark What I’m entering in Find is the full amount/value. The amount of 1234.12 is just to show the format I am using Kind regards, Evie. e...@wedloco.co.uk www.wedloco.co.uk DIY Invitations Stationery 0131 478 9175 On 20 Dec 2014, at 18:11, Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: WEDLOCO wrote: Thanks Tom for your quick response and suggestion - and also all others who have contributed. Downloaded the Still version 4.2.8 but same thing is happening. Worked 1st time I entered a value in find and then when I changed the amount Search key not found. I entered different amounts from different cells to test and it can find some values but not others??? They are all formatted as numbers e.g.: 1234.12. No formulas in cells. These are bank statements downloaded as .cvs files then changed to .ods files in Libra to check against receipts. Cheers. Evie. Briefly experimenting with this, it seems that if there is a value of 1234.1 in a cell, it is found when searching for 1234.1 but not when searching for 1234.10 - even if it is formatted to display two decimal places. Could that be what you're seeing? Additionally, a cell containing 1234.12 is found by a search for either 1234.12 or 1234.1, which makes it more difficult to find 1234.10 but not 1234.12. It is possible though, by using Edit Find and Replace, entering 1234.1 as the search term, and selecting the Entire cells option; that will then find a cell containing 1234.1 but not 1234.12. This does seem potentially confusing. If this is the problem you're seeing, it may be worth filing an enhancement request athttps://www.libreoffice.org/get-help/bug/. After filling in the details but before submitting, check the list of Related bug reports. If any of those describe the same problem, it's better to add information there instead of submitting a new report. Mark. -- 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] Unsubscribe
juliejohn scott wrote: Please unsubscribe me now (if you can) because I have had my question answered and my e-mails are becoming excessive.Happy Christmas,John Scott. We're just other users, helping each other, and don't have access to unsubscribe you. You'll need to do that yourself, following the instructions added to the bottom of every email sent through the list: To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org If simply sending an email to that address doesn't work, the second link contains guidance: Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Hopefully those will help. Mark. -- 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] Re: image anchoring
That's not surprising really... the link to View this message in context shows it was a reply to a 2-year-old thread! Mark. Tim---Kracked_P_P---webmaster wrote: I do not remember seeing the original post with the question included. For single page documents, I use Anchor to Page. For multi page documents, I use Anchor to Paragraph. That way, if I do some changes in the margins, etc., the picture seems not to wander around as much - left to right on the page - as the character/word would make it. On 12/15/2014 04:37 PM, Tom Davies wrote: Hi :) Err, 1. we hear that AS character produces the most hideous unsightly results 2. we hear that MS Office does it that way 3. there's a call for us to move to the hideous unsightly way!! Why not stay with the advantages of LibreOffice instead of trying to make it as hideous as MS Office!!? There probably is a place where you can configure your own set-up to default as you prefer. Then maybe copy that xcu (on Windows) or User Profile (on all OSes) to get the same defaults onto other machines. I tend to find MS Office 2010 tends to use to paragraph but that might be something weird i did during set-up. Personally i usually prefer to page for my company's newsletter but it's not always appropriate. Simply right-click on an image and choose Anchor and a sub-menu appears allowing you to choose. There are probably other ways but i tend to find that easiest for me. Regards from Tom :) On 15 December 2014 at 20:17, Florian Reisinger flo...@libreoffice.org wrote: Hi, There are (close to) no devs on this list... Liebe Grüße / Yours, Florian Reisinger Am 15.12.2014 um 20:11 schrieb rfithen rfit...@hotmail.com: I agree, anchor as character should be the default behavior as in Microsoft Office. Clearly there are no reasonable responses to your question, and the devs seem to ignore this request. -- View this message in context: http://nabble.documentfoundation.org/image-anchoring-tp4014581p4132725.html Sent from the Users mailing list archive at Nabble.com. -- 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 -- 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 -- 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] Printing options.
Steve Edmonds wrote: On 2014-11-26 13:56, Doug wrote: On 11/25/2014 07:25 PM, Steve Edmonds wrote: Hi. In File Printer Settings, under options is the device printer language setting (PDF/Postscript). Is this a Libreoffice configuration or a system configuration. I ask because some documents print fine with postscript but not with PDF. If it is a LO function I will file a bug. Thanks, steve Unless I misunderstand the question, Postscript will be a _printer_ setting. HP printers understand Postscript, maybe some others do. So if your printer understands Postscript, you can use that setting in your operating system to communicate with the printer, and everything you send, including the output of LO, your PDF reader, whatever it may be, and any other file you send to the printer will be encoded in Postscript by the operating system and delivered as such to your printer. --doug Thanks. I am printing to a printer not a file. If I select postscript in this printer dialogue setting, printing is correct. If I select PDF printing is not correct. I can't include a screen shot to show you the dialogue. Oops, just notice it is FilePrintPropertiesdevice or FilePrinter settingsPropertiesdevice. There I have Printer Language Type. If this setting changes the way LO outputs to the printer, then there is a bug in LO. Steve I think the dialog invoked by File Print Properties is the printer driver specific options for the selected printer, so more related to the printer/driver/OS. If one option works and not the other, why not just use the one that works? That may be the reason for there being an option. On Windows, default printer settings can be set from Control Panel Printers. Right-click the required printer and select Printing Preferences set options as required and click OK. This dialog will probably look similar to the one from File Print Properties in LO, but sets the defaults rather than one-off settings. Exact naming of menus may be different on different versions of Windows. Mark. -- 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] date acceptance patterns not sticking
bunk3m wrote: Thanks so much for taking time to answer my question. I never thought about the 12.6 issue messing up the decimal number format as it never happened in Excel. As I've moved over to using LO, I've learned some Excel behaviours really don't translate very well. A bit more below. On 15.10.2014 15:23 , libreoffice-ml.mbou...@spamgourmet.com wrote: bunk3m wrote: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that I can format the date to look DD.MM. but entering in the -MM-DD is totally unnatural for me. Actually, I only usually type the DD.MM and expect the to show up automatically in Excel. I'd like the same behaviour in LO if possible. The date acceptance patterns will not accept anything except what is loaded by default ... which is D.M.;DD-MM-;D-M I don't want to have to type the each time for D.M.. I've tried to add D.M to the acceptance pattern but the text turns red and won't save. The D.M is always gone after trying to save. Works for me with LibreOffice 4.3.0 on Windows Vista; perhaps it's changed since then, or maybe it's different on Mac anyway. The problem with doing it, though, is that the date acceptance patterns affect what's interpreted as a date even for cells not formatted as date. That may be the reason for a change between 4.3.0 and 4.3.1. With D.M added to the date acceptance patterns, entering 12.6 in a cell formatted as General becomes 12/06/14 - which may not be desirable if you actually wanted to enter a number between 12 and 13. Even more bizarrely, explicitly formatting a cell as number (0.00) and then entering 12.6, it becomes 41802.00 (probably the numeric value for the 12th June 2014) But 43.6 becomes 43.60 as expected, presumably because it can't be interpreted as a valid date anyway. Damn, never even considered this. This could have gotten really messy. Would using / or - as a separator be an acceptable alternative? So you could enter 12-6 or 12/6 to get the date 12th June 2014. No it wouldn't be a problem. I had a brain cramp and couldn't get past my old learned behaviour. Thanks again for your help. B. Great. Thanks for letting us know this works for you. Hopefully it won't take too long to adjust ;o) Mark. So if the date acceptance patterns are supposed to be customizable by the user ... what do I have to do to get this to work? Thanks in advance. B. PS I'm on digest mode. Please CC me directly -- 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] date acceptance patterns not sticking
bunk3m wrote: Libreoffice is driving me nuts. I am in Canada. UI is set to English US; Locale settings to English Canada and Default Currency is CAD. I have my Mac set dates to dd.mm.. (OSX 10.9.x) For some reason Libreoffice (4.3.1.2) will only accept dates in the -MM-DD format. I'm happy that I can format the date to look DD.MM. but entering in the -MM-DD is totally unnatural for me. Actually, I only usually type the DD.MM and expect the to show up automatically in Excel. I'd like the same behaviour in LO if possible. The date acceptance patterns will not accept anything except what is loaded by default ... which is D.M.;DD-MM-;D-M I don't want to have to type the each time for D.M.. I've tried to add D.M to the acceptance pattern but the text turns red and won't save. The D.M is always gone after trying to save. Works for me with LibreOffice 4.3.0 on Windows Vista; perhaps it's changed since then, or maybe it's different on Mac anyway. The problem with doing it, though, is that the date acceptance patterns affect what's interpreted as a date even for cells not formatted as date. That may be the reason for a change between 4.3.0 and 4.3.1. With D.M added to the date acceptance patterns, entering 12.6 in a cell formatted as General becomes 12/06/14 - which may not be desirable if you actually wanted to enter a number between 12 and 13. Even more bizarrely, explicitly formatting a cell as number (0.00) and then entering 12.6, it becomes 41802.00 (probably the numeric value for the 12th June 2014) But 43.6 becomes 43.60 as expected, presumably because it can't be interpreted as a valid date anyway. Would using / or - as a separator be an acceptable alternative? So you could enter 12-6 or 12/6 to get the date 12th June 2014. So if the date acceptance patterns are supposed to be customizable by the user ... what do I have to do to get this to work? Thanks in advance. B. PS I'm on digest mode. Please CC me directly -- 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] parallel text in side by side pages
Marc Grober wrote: Intriguing idea, but it would still require the use of anchored linked frames, and if I am going to use anchored linked frames, I don;t need Calc. I think the idea with Calc would be to start with the text for one language in cell A1, and the text for the other language in cell B1. Where you want to break the text and re-synchronise the translations, just move on to using cells A2 and B2, etc. Set the cells to automatically wrap (Format Cells Alignment Wrap text automatically). You should be able to set the column widths so that you either get both columns side by side on the same page (this effect would be similar to using a two-column table with appropriate text flow settings, so may not be suitable given your comments on that option below). Alternatively, you could set each column to be the whole width of a page and then set the print ordering so that they print alternately (Format Page Sheet Page order: Left to right, then down. If printing double sided you'd probably need to get a blank page inserted first, otherwise the two languages for each bit of text would end up on opposite sides of the same page rather than facing pages; not sure off the top of my head how to go about that... One option may be to use something like PDF Creator (a virtual printer which creates PDFs of the printed content) to combine a blank page followed by the document printout into a single PDF file, then print that file. I still am thinking that there should be some way to do this from a master document, so that subdocuments can interleave by way of how the subdocument is styled. I'm not sure that master documents can do that. They're more for combining several documents one after another (e.g. if you have each chapter of a book in a separate chapter). The other option seems to be to treat the two facing pages as one two column page, but that creates so much trouble when it comes to dealing with everything else it becomes a case of the tail wagging the dog. On 10/15/14 7:23 AM, Joe Conner wrote: Have you considered using Calc for this, you can adjust the formatting to have text roll into a new line automatically. Then you can copy/paste into a word document if you find it necessary. Blessings, Joe Conner: Poulsbo, WA USA -- 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] zoom in and out bound to a key
Uwe Brauer wrote: Mark == Mark Bourne writes: A couple of possibilities... Thanks for your answer. 1. Your operating system might do something with those shortcut keys, and not pass them on to LibreOffice. Other shortcut keys I have set work fine (I am on Linux Kubuntu 10.04) If the OS was using Ctrl++ and Ctrl+-, it wouldn't necessarily affect other shortcut keys. Didn't think it likely that the OS would use those anyway, though. If the same shortcut key is defined for both, the one for an individual application takes priority when in that application. In Writer, Ctrl++ is assigned to Calculate and Ctrl+- is assigned to Optional hyphen (at least for me). If you assign those keys to zoom in and out at the LibreOffice level, they will not have that effect when in Writer; you'd need to remove the assignments from the Writer level (and likewise for Calc etc. If you want them to work there too). I know, and that is why I tried out other bindings such has Alt+F2 and it does not work neither, Ah, I didn't realise you'd tried these other things. I googled around and found out that it/was a long standing bug, that is zoom in and out cannot be bound to a key! I am using LO 4.2. Did you try it out, successfully? If so which version do you use, because I then might upgrade. Afraid not; I usually do check before responding but was in a bit of a rush this time. I was thinking the problem was specifically with Ctrl++ and Ctrl+-, and assumed Zoom In and Zoom Out in the list of available functions would work if mapped! Just tried (4.0.4 and 4.3.0) and indeed they don't work :( Another option (if you have a mouse with a scroll wheel) is to hold Ctrl while scrolling the mouse wheel to zoom in and out. Not exactly what you were looking for, but it may be easier than using the menus or buttons at lower right. Or set up a shortcut for View Zoom, which brings up a dialog to adjust the zoom. Again not as convenient as zoom in/out, but another option... Mark. -- 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] zoom in and out bound to a key
Uwe Brauer wrote: Hello LO has a nice button down right which allows to zoom in and out using the mouse. However I would prefer to bind zoom in to a key and zoom out to another say Crt-+ and Crtl-- but when I go to Customize--View--Zoom in and bound it to say Crtl-+ nothing happens, Customize--View--what do I miss? thanks Uwe Brauer A couple of possibilities... 1. Your operating system might do something with those shortcut keys, and not pass them on to LibreOffice. 2. More likely - There are two levels of assigning shortcut keys in LibreOffice - those for the whole suite and those for an individual application. In the Customise Keyboard dialog, at the upper right, there is an option to flip between assignments for LibreOffice (the whole suite shortcuts) and Writer (or whichever application you're in). If the same shortcut key is defined for both, the one for an individual application takes priority when in that application. In Writer, Ctrl++ is assigned to Calculate and Ctrl+- is assigned to Optional hyphen (at least for me). If you assign those keys to zoom in and out at the LibreOffice level, they will not have that effect when in Writer; you'd need to remove the assignments from the Writer level (and likewise for Calc etc. if you want them to work there too). I hope that helps. Mark. -- 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] To open a second Sheet with one mouse click from the first Sheet in same document?
csanyipal wrote: Hello, I'm using LibreOffice 4.2.6.3 Build: 4.2.6.3 Arch Linux build-4 Is it possible to create a hyperlink in a cell ( text or button ) in one Calc Document on one Sheet so if one click on that hyperlink then get focused another Sheet in the same Document? The purpose of this would be that that one should not searching a specific Sheet in the same Calc document but only to click in the first Sheet on a hyperlink so to get quickly the desired Sheet focused for a data entry. I tried this with 'Control+K' in a cell and setup there the desired Sheet in the same document. I then get a #1 text in the cell but it doesn't work; when I click on it with 'Control + mouse click' I get not focused the desired Sheet. Why can't I achieve this goal this way? I assume you are using Insert Hyperlink Document, then leaving the document path blank and either entering the sheet name in the Target field or using the button next to that field to select a sheet? It doesn't seem to work with sheet names resembling row or cell references (e.g. 3 or AB5) - clicking the link just takes you to that row or cell on the current sheet. Possibly a bug, so may be worth reporting at http://bugs.libreoffice.org/. As you enter details there, it shows other bugs which may match. If one of them is the same issue, there's no need to continue reporting it again; add a note to the existing report only if you have new information (lots of comments saying me too only hinders the process as it's difficult to see the useful and relevant information amongst other comments!) As a workaround, try entering the hyperlink target as 1.A1. That takes you to cell A1 on the sheet named 1. Of course, you can use a cell other than A1 if it would help to go directly to some other cell. Also be aware that renaming the sheets does not update the references in hyperlinks, as it does for formulas. So if you later decide to rename that sheet to Month1, the hyperlink will stop working. Mark. -- 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] CANNOT INSTALL LIBRE OFFICE SUITES
Tom Davies wrote: Hi :) We went off on a tangent around here somewhere. There still seems to be a problem installing LibreOffice on this Windows 7 machine. The download is an msi so that IE issue doesn't seem to be the problem. The installer's file-size is 215,652kb, so that's around the 220Mb figure i try to remember. We've not tried an md5sum or Sha check to make sure but it really looks like the download itself was probably NOT the issue. That looks about right for the LibreOffice 4.2.6.3 installer. Checking the checksum would help confirm that it hasn't been corrupted. Firefox has installed successfully so it's not that the user doesn't understand the weird blockers Win 7 tries to put in the way of installing anything (which usually seem (to me) more intense when trying to install non-MS stuff) Win 7 is still claiming that the installer is not an installer, even though the installer is an msi file. The exact grumble is Windows InstallerThis installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify this is a valid Windows Installer Package. Could be a problem with the Windows Installer service. From previous discussion, it looks like this is on Windows 7 without Service Pack 1 (and possibly other updates)? So first, install Windows 7 Service Pack 1 and any other updates offered by Windows Update. The Windows Installer service is sometimes updated, and newer installers don't always work with an older version. I've also seen mention of people working around this error by creating new Windows user account and logging in to that to install. Probably means there's something not quite right in the original profile. Provided you install for all users rather than just the current user, you'll still be able to use the application from your usual login. Anyone any ideas about what might be different enough between the Firefox installer and the LO one to be causing this issue? It looks like Firefox uses an .exe installer, rather than .msi, so there may be many differences. Even if Firefox's is just an .msi packaged within an .exe, it might work with an older version of the Windows Installer service than LibreOffice's does. Mark. Regards from Tom :) On 17 September 2014 13:19, Tim---Kracked_P_P---webmaster webmas...@krackedpress.com wrote: On 09/17/2014 02:46 AM, Sophie wrote: Hi, Le 17/09/2014 06:49, tjphipps a écrit : i tried twice to download and install the newest libre suite. the download went perfectly both times but when i told my computer to install them i got the same error message both times. it said something like 'this is not a windows installer' and to 'contact the makers' or something like that. i love libre office and have used it for many years on several different computers with windows , xp and vista and have never has anything go wrong with anything, ever. this computer is running windows 7 home premium without sp1 so far. what should i do? What is the extension of the download you try to install? Often IE changes the extension of the file in .man instead of .msi. Kind regards Sophie Most everyone I deal with locally will not use IE due to its issues. I suggest using Firefox or Chrome for downloading the files. They work much better than IE and you can add more useful security options to both that make it easier and safer to use than IE. Actually, the newest version of Firefox for Windows has an ability to run the file after the download DIRECTLY from the download history options - either by clicking the blue download arrow for the last few downloads, or via the full history section via the ToolsDownloads option. This works better than the IE run file after downloading option. I currently have access to Win7 laptops, but I have had not trouble downloading the files via Firefox or Chrome and installing them. I upgraded a Vista [32-bit] laptop to Win7 Pro [64-bit] due to Vista's giving me the same type of errors for many different packages, ones that installed well on XP and Win7 Home. I did have a few times where XP did not like to install .msi install versions when there were .exe install versions available. So please install Firefox or Chrome browsers and download the .msi files again. ALSO, MS sometimes changes its internal package installer used to run/install .exe and .msi files. I had to update the installer via MS's web site free downloads section. Sometimes this needed internal package is not updated/upgraded via the automatic Windows Update system. This has happened to me once with XP and twice with Vista. This solved the type of errors you are seeing, in Vista mostly. Win7 without SP1? Have you been installing all of the Win7 updates since you installed the Win7 OS, or first ran it when you got the Win7 system If you did, then even though the OS install did not have SP1 included, then with all of the MS updates you should
Re: [libreoffice-users] Re: Printing Brochure with Writer -- margins
Marc Paré wrote: As far as I can tell, even if I change the body length ... for example set the 8.5X11 inch page to a top and bottom margin of 0.00 inches ... the brochure (booklet) will still be printed with the same top/bottom gaps of spaces at the top/bottom of the booklet. It would be very useful, if there were a way to make use of the white space through the initial Writer document before going to the Print-Brochure option. This would allow ALL Writer users to print out brochure-booklets without any prepping of styles. I think the problem is that the proportions of an 8.5x11 page are different from the proportions of half a page (which is 5.5x8.5), so a simple scaling doesn't work. When content created at 8.5x11 is scaled to fit on half a page, the 8.5 side become 5.5, while the 11 side is scaled by the same proportion to 7.1 - less than the 8.5 height which is actually available. Try creating the content with the page size set to 5.5x8.5 (or 8.5x13.1 if that makes it easier to adapt the existing content), then print that as a brochure on 8.5x11 paper. (Doesn't help you much using US paper sizes, but for those using the European A sizes - A4, A5, etc. - this isn't so much of a problem; those sizes are designed so that the proportions remain the same when a page is cut in half) Mark. -- 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] calc: Find has never worked for me
John R. Sowden wrote: On 09/17/2014 11:27 AM, Mark Bourne wrote: John R. Sowden wrote: I have been using LO from the 'beginning'. I have never be able to get the menu command 'Find' to work. Just to be sure I just tried again. The Edit-Find Selection has the three dots after it, telling me that a dialog box/menu will open. Nothing happens, anywhere on the screen. The basic Find is just a toolbar (usually at the bottom of the screen, but you can move it as with any other toolbar). It has a text box to enter the text to search for and a button to open the Find Replace dialog. If the toolbar is already there, you may not notice much change on screen, but the cursor should move into the text box where you can enter a search query. Is that happening? When I press Ctrl F, the left margin moves, but do find prompt opens. I'm not sure what margin you're referring to? This is in Calc, as per the email subject, not Writer, right? Does is say Ctrl+F next to the Find... option on the menu? It may be that Ctrl+F is currently mapped to a different function. Check Tools Customise Keyboard and make sure Ctrl+F is mapped to Find when LibreOffice is selected to the right of the list, and nothing else when the individual application is selected (Calc, Writer, etc. depending what you're using at the time). When I enter edit-'Find Replace ...' then Find and replace box opens and I use it. When I press Ctrl H (For Find Replace), nothing happens. Again, check that it does say Ctrl+H next to the menu option, and check the keyboard shortcuts as above. Oh yes: LO Version 4.1.3.2 and others back to the beginning, and ubuntu various versions-currently 13.10, but I have been using ubuntu since about 6 months after the big CD givaway. John Mark. OK, here goes: 1) I am in CALC, When I press Ctrl F, the collum with the row numbers moves to the rights about 3/4 anlong with the whole SS (margin was not a good descriptor). Ah... it seems that it's possible to move the Find toolbar to the left edge of the window, which has that effect as the spreadsheet content moves to make space for it when you press Ctrl+F. But it's not particularly useful in that position, since there's no space for the text box to actually enter what you want to search for! Try dragging the grab handle on that toolbar and moving it somewhere else - either floating or docked at the bottom or top. 2) I am familiar with the Find text box, used in other apps. That is what I have looked for-not found. I thought that was probably the case, but figured it worth checking before looking for more complicated things. 3) When I select the edit-find menu item, the cursor disappears. I tested this by placing the cursor in the edit box, where it flashes. When I select find, it disappears. When I select a cell, there is no cursor flashing, so when I select the find option, nothing changes. That also seems consistent with the Find toolbar docked at the left edge of the window. The cursor moves into the Find text box, but that's not visible (although it does actually still seem to work - you can type something and press enter, and Calc will search for it; you just can't see what you're doing). 4) Yes, the Find option in the menu shows Ctrl+F as a shortcut. 5) For 'find and replace' the shortcut shows ctrl+H. OK, so those sound OK. I have not remapped any keys, as I rarely use the shortcut keys, as I don't want to loose my memory for the WordStar keys used in Wordstar and Borland Pascal. If you still can't find the toolbar, it may be worth resetting your LibreOffice user profile. This will clear any user settings (hopefully including whatever has happened to the Find toolbar), as well as any added dictionary words, custom colours, etc. so it's a good idea to back up your existing profile first. See https://wiki.documentfoundation.org/UserProfile (Resolving corruption in the user profile section) for instructions. If that fixes the problem, the easiest is probably to keep that new profile and redo or copy any settings you need from the old profile. It may be possible to compare the two, work out what made the difference to Find, and reset just that part of the old profile, but that's more tricky (if you try it, make a copy of the old profile first, so at worst you can always get back to the current situation). If resetting the user profile doesn't help, I'm afraid I'm out of ideas, but post back here and someone else may be able to suggest something. Mark. -- 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] calc: Find has never worked for me
John R. Sowden wrote: I have been using LO from the 'beginning'. I have never be able to get the menu command 'Find' to work. Just to be sure I just tried again. The Edit-Find Selection has the three dots after it, telling me that a dialog box/menu will open. Nothing happens, anywhere on the screen. The basic Find is just a toolbar (usually at the bottom of the screen, but you can move it as with any other toolbar). It has a text box to enter the text to search for and a button to open the Find Replace dialog. If the toolbar is already there, you may not notice much change on screen, but the cursor should move into the text box where you can enter a search query. Is that happening? When I press Ctrl F, the left margin moves, but do find prompt opens. I'm not sure what margin you're referring to? This is in Calc, as per the email subject, not Writer, right? Does is say Ctrl+F next to the Find... option on the menu? It may be that Ctrl+F is currently mapped to a different function. Check Tools Customise Keyboard and make sure Ctrl+F is mapped to Find when LibreOffice is selected to the right of the list, and nothing else when the individual application is selected (Calc, Writer, etc. depending what you're using at the time). When I enter edit-'Find Replace ...' then Find and replace box opens and I use it. When I press Ctrl H (For Find Replace), nothing happens. Again, check that it does say Ctrl+H next to the menu option, and check the keyboard shortcuts as above. Oh yes: LO Version 4.1.3.2 and others back to the beginning, and ubuntu various versions-currently 13.10, but I have been using ubuntu since about 6 months after the big CD givaway. John Mark. -- 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] My organization is new to Libre. Looking for cheat sheets
Paul Auger wrote: Hi all. We are brand new to Libre. We are used to MS office. Is there a cheat sheet that says If you do this in office these here the steps you need to take to do the same thing in Libre? Not sure about that; hopefully others can help there. I've always found LibreOffice very similar to MS Office (at least up to MS Office 2003, before they introduced those ribbon toolbars). About the only thing that kept catching me out was that Format Page in LibreOffice was at File Page Setup in MS Office. Opposite way round to you though - having got used to LibreOffice, I always had to think about where to find the page formatting options in MS Office! (and it never did make sense that page formatting was on the File menu when character and paragraph formatting were on a Format menu...) Also we have noticed that when we import documents especially those with tables the formatting is altered. any advice? For various reasons, the older MS Office .doc, .xls and .ppt formats generally import into LibreOffice better than the newer .docx, .xlsx and .pptx formats. So if your files are in those newer formats, try using MS Office to save them into the older format (File Save As and choose the older format, probably called something like Microsoft Office 2003, for the Save as type option). Then import that older-format file into LibreOffice. It does mean you need MS Office to do the conversion, but a medium or large organisation would probably want to keep a couple of MS Office licenses anyway, to ensure they can access historical files, even once the majority of the organisation has transitioned to LibreOffice. One of the benefits of the Open Document Format used by LibreOffice (and other open source office applications) is that you're not reliant on one company's product to be able to access your old files in future. Mark. -- 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] Re: Styles Don't Retain Bold?
Alex Thurgood wrote: My experience on several occasions has unfortunately been that the Default style in Writer has hard formatting characteristics which cause application of Heading 3 not to work correctly, and it seems hard to be able to ascribe any particular sequence of actions to make it reproducible. I am not a styles expert by any means, but one would expect the default styles to work as designed. Not sure if it's related, but I noticed a week or so ago that there seems to be something slightly odd in the font sizes for the default heading style definitions... - Heading : size = 14 pt - Heading 1 : size = 130% (relative to parent style Heading) - Heading 2 : size = 115% (relative to parent style Heading) - Heading 3 : size = 14pt (fixed) - Heading 4 : size = 95% (relative to parent style Heading) ... So changing the size for the Heading style also flows through to the other Heading X styles proportionately - except Heading 3 which is fixed at 14pt. I think the intention is for that to be 100% relative to the parent style. I've also found that attempting to explicitly set a style to 100% font size actually has the effect of fixing it at the parent style's current value at the time this setting is applied, rather than inheriting the value from the parent. So that is possibly what someone has done in defining the default Heading 3 style. This is in 4.3.0. Will check in 4.3.1 and search for / report a bug when I get a tuit of the circular variety... Mark. -- 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] Table presented totally wrong.
Stef Bon wrote: Hi Mark an others like Tom, first of all there seams to be a misunderstanding. I meant with template a guide given by the teacher to me, as a layout the teachers expect the results will have. So not the technical term for it, it's just a document in the docx format. Yes, I realised that; apologies if I wasn't clear. I was trying to explain the background to the problem, and probably ended up rambling on a bit! In summary: .doc is a more reliable format than .docx for transferring between MS Office and LibreOffice. If you can get whoever supplies the template to save it from MS Office into that format, it will probably work better for you. Nonetheless, I will do the following: a. whenever I can I will provide the results in PDF format. But that won't solve the problem when LibreOffice does not read the tables good in the first place. That's a good idea, if they don't need to be able to modify the file. b. what should I ask the institute what format is best? I've understood that the ODF format is not supported by MS Office. What then? Support for ODF is improving in newer versions of MS Office, so it might be possible to save from MS Office directly into ODF. If that doesn't work properly, the older MS Office formats (.doc for Word, .xls for Excel) generally work better than the newer .docx or .xlsx formats. c. I will provide a bug report. With stripped data. I really think that the importing and exporting foreign formats like docx, and especially the different versions of it, is very important. You speak about different versions. I know with Samba, the project leaders are provided the latest details from microsoft about the different versions SMB2, 2.1 and 3 to get maximal compatibility. Isn't that possible with their docx format? I don't know much of the details. From my understanding, Office Open XML (OOXML - the format used in docx, xlsx, and related files) is a supposedly open standard. i.e. anyone can get the details of how to read and write files in that format. But that standard allows some data to be included in an application-specific format, which MS does to make it easier for themselves to port MS Office to using it. Unfortunately that means it's not so easy for anyone else to figure out how to read and write those parts of the file. These compatibility problems are the reason that several governments and other organisations have started moving over to using ODF instead of Microsoft's formats for their files. That way they're not dependent on a single company continuing to support the format in order to read their files in future. I don't know about other countries, but there's some info about the UK's implementation at: https://www.gov.uk/government/publications/open-standards-for-government and, specifically relating to editable documents: https://www.gov.uk/government/publications/open-standards-for-government/sharing-or-collaborating-with-government-documents From a quick search, it looks like the Dutch government are already doing something similar: https://www.forumstandaardisatie.nl/english/ Mark. -- 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] Table presented totally wrong.
Stef Bon wrote: Hi, I got a template.docx of my education institution, and tried to open it using LibreOffice. I found out too late - after I sent it, I got comments of receiver - that writer did show the table totally wrong. The .docx format changes slightly with each version of MS Office. Even newer versions of MS Office sometimes display documents created in an older version differently. For compatibility between MS Office and LibreOffice, the older .doc format is more reliable. Also when working in LibreOffice, you should save your work it in Open Document Format (ODF), even if it was originally imported from an MS Office format. That way you avoid corruption which may occur by repeatedly exporting and importing the document. Only export a copy back to MS Office format if that's needed for sending it to someone else - keep your working copy in ODF. Until now I was convinced LibreOffice is a good alternative for MS Office, but I doubt it very much now. I had to use the (Microsoft Windows) computers on the school with a recent MS Office to get it right. So LibreOffice is useless because it can't fully understand a format defined by a private company? Despite the name, Office Open XML (the .docx etc. formats) as used by MS Office does contain some proprietary elements so is not completely open for others to reliably implement. I've been talking with members of parlement about the use of open source by the government, and was convinced it's a right thing. Now I'm not so sure anymore. Several governments have recently moved over to specifying that ODF should be used for documents. That's the main format used by LibreOffice. If transitioning to LibreOffice, it would be a good idea to also transition to using ODF. I think it's not a very exotic table. It's a table in a table. One note: I've tried Google Docs also, and that did not do it right either. Attached you find the Template, and where there should be information under the column Lesplan, but it's not shown at all. Also attached you find the complete new document based on the template. I added text, but the first column I left unchanged. You see ther are different rows there, which are ignored in the original document (Template) This mailing list strips attachments from emails, so they don't get through. You can either upload them to another hosting service and include links, or I believe the Nabble interface to the mailing list at http://nabble.documentfoundation.org/ can do this for you. I hope you can solve this, If you believe there is a bug in LibreOffice here (which is certainly possible), you can report it at https://www.libreoffice.org/get-help/bug/ where it will be tracked (rather than forgotten in someone's email inbox) and you can also attach the document there. Be aware that this mailing list and the bug tracker are publicly accessible, so don't include anything confidential or otherwise sensitive. Sorry I can't be more help. Others here may be able to suggest workarounds to this specific problem. Mark. -- 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] how to turn off read only
John R. Sowden wrote: More data: At the OS level: User: R/W, Group: R/W, Others: RO Opened the file. went to file/properties/security: RO checked, grayed out. Used the Edit Icon, made a change, the change was allowed, I was able to save using the 'Save' command, exited LO, confirmed no RO changes at the OS level, opened the file, the changes had been saved to the original file. I can now change the original file using the Edit Icon, but I cannot remove the RO selection once it it made. The following sequence works for me (LO 4.0.4 and 4.3.0 in Windows) with a file saved with Open file read-only set: - Open the file. - Click the icon to switch to edit mode. - File Properties Security untick Open file read-only (which can be modified, now that you're in edit mode). - Save the file (which can be done, now that it's not set to open read-only). As others have mentioned, OS / file system permissions are separate, so you still won't be able to save over the original file if those permissions don't allow it. From your description above, it doesn't look like that should be a problem though (assuming your user account is either the owner of the file, or in the file's group). Above was a test that I either did not perform, or documented wrong. We're gettin' close. Maybe all the right steps but not quite in the right order. Double-check the OS file permissions and owner, particularly if you've been changing them in the course of finding a solution; the settings you show above look fine to me, so not expecting a problem there. Or maybe it works differently on Linux than Windows (which may be by design or may be a bug). By the way there were 'reset' and 'apply user changes' buttons/boxes selections in the properties selection, but they had no effect. Reset returns the options to how they were when you opened the dialog, the same effect as clicking Cancel and then re-opening it. So, for example, in a new document: - Open File Properties; Open file read-only is not ticked. - Tick Open file read-only, but don't close the dialog. - Click Reset; Open file read-only returns to unticked. - Tick Open file read-only and click OK. - Open File Properties; Open file read-only is ticked. - Untick Open file read-only, but don't close the dialog. - Click Reset; it will return to ticked. John -- 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] write frustrations
John R. Sowden wrote: Below is why I still use WordStar 5.5 in my office: I am creating a form (an invoice for my ebay purchases because many sellers don't send one). 1) ebay lower cases their name. I type 'ebay'. LO corrects me to make it Ebay. (Note that while eBay's logo is all lower case, in text they write it with a capital B) A couple of solutions: 1. Undo immediately after it corrects to Ebay (menu Edit Undo, or Ctrl+Z or whatever your favourite way of undoing is). It will undo the autocorrect, but not whatever you typed to trigger it. 2. If you'd rather disable automatic capitalisation entirely, go to Tools AutoCorrect Options Options tab and untick the box under [T] and next to Capitalise first letter of every sentence. While there, you can also disable any others you don't want. The ticks under [M] control what happens when you use Format AutoCorrect Apply, while those under [T] control what happens as you're typing. I've just noticed that you can also completely disable AutoCorrect at Format AutoCorrect While Typing (I think someone was asking for this a couple of weeks ago...) 2) I type seller:. on the next line I create an underline about 3 inches long for the name, etc. of the seller. LO changes my 3 underline to all the way across the page. In addition, it is not a character based underline. I cannot delete it, shorten it, etc. I cannot select it, as if it were an object. My only solution is to delete the file and start again. Similar to above, you can undo immediately after it happens, or disable the option under Tools AutoCorrect Options Options Apply border. If you already have one of these borders you want to get rid of, place the cursor in the paragraph just above and go to Format Paragraph Borders tab. You'll notice it is set to draw a border below the paragraph. Click the left-most icon just under Line arrangement to get rid of all borders. Rather than using the underscore character to produce lines to fill in, a more controllable way may be to use a tab stop with an underline fill: - Place the cursor on the line where you want to produce the underline. - Click on the ruler to place a tab stop by clicking on the ruler (or add a new one under Format Paragraph Tabs). - Double-click the tab stop on the ruler (or go to Format Paragraph Tabs) to set its properties. - Select the required tab stop in the Position list, and set the Fill character to the underline. - Click OK. - Now position the cursor at the end of the line and press tab. The space between the last character and tab stop will be underlined. That may or may not achieve the effect you want; it's just another idea. 3) I have tried in the past to create a outline structure, kinda like this doc. LO kept changing my text in the same way. I ended up using WordStar to get the job done. I'm not sure know what you're referring to. The mailing list removes attachments, so if you attached an example document it won't get through. LO kept changing my text in the same way sounds like more AutoCorrect options, which you can disable as above or undo immediately after they happen. Some people find AutoCorrect useful, some don't. Personally I disable most of the options because it gets in the way as much as it helps. About the only one I use is Replace Dashes which replaces hyphens with longer dashes when there's a space each side of the dash - because that's one I do find useful. I want to integrate LO into our office ops so the employees feel they are part of the 21st century, but its issues like this that keep that from happening. Help? John Hope that helps. Mark. -- 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] Turn Off All Automated Functions
kajdna wrote: *My* My gripe with libreoffice are its stupid algorithims that constantly find false errors in what I type. If I type *** as a break between sections I get a bold line If I type cat --help I get Cat --(dash)help Is there ONE place where I can turn off ALL automatic overrides? If I can't type what I want to type, libreoffice is a deal-breaker. I have carefully searched all menus. Not sure if you're still watching this thread, but poking around for another thread I've just found that you can completely disable AutoCorrect from modifying text as you type at Format AutoCorrect While Typing. It has a tick next to it by default, but if you click that option the tick is removed and AutoCorrect stops modifying text as you type. I didn't know about that one before... Mark. -- 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] Formatting Writer formula bar fields
Chris Cameron wrote: Hi, Often I use Writer's Formula Bar (By hitting F2) to do some math inside my Writer document and have the output displayed. The default formatting for this output is to 2 decimal places, which is often less than I want. So every time I must right click the field, click Fields, Additional Formats, change the decimal places, then ok, ok. My number format never sticks around from field to field, and I see no option for changing the default in Writer. Can anyone tell me how I might change the default rounding this formula bar does? I'm not sure about that, or whether it's even possible. Copying a cell to another cell takes the format with it, which may give a quicker way. Just make sure the whole cell is highlighted when copying (so that the highlight extends to the borders of the cell, not just the text within the cell). The formula is copied as well, so you'll need to edit that afterwards. Or, failing that, how I can have a format saved in Edit Fields - Format box? Formats you've already used in a document appear in the User-defined category of the Number Format dialog, so can be easily selected when for formatting another cell. I'm not sure if you can save them for use in other documents, but at least it may be quicker if you use the same format several times in one document. Many thanks, Chris Hope that helps a little, even though not exactly what you want. Mark. -- 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] Parts of document set to read-only by Writer: how to disable (normal methods not working)?
Vincent Rubiolo wrote: Hello Brian On 08/25/2014 10:28 PM, Brian Barker wrote: One possibility here is that structure of your document is more complex than simply cells of table. Have you perhaps got a table - even if only of a single cell - inside a cell of another table? If so, you may have the relevant cell of the outer, containing table protected with the cell of the inner table not protected. As the outer cell is protected, you cannot change the properties of the inner table cell, so the Cell submenu there will indeed show a greyed-out No selection possible. The solution is to unprotect the outer table cell. If there is no room to get your cursor into the outer table cell without it being also in the inner table cell (so you cannot get to the relevant context menu), put the cursor at the end of the text in the inner cell and press Alt+Enter. You'll then have space to get to the context menu you require. I trust this helps. Thanks for the suggestion. Even though the document structure is very simple (I don't think there are nested tables), I have tried what you advised. However, this does not work because 'Alt+Enter' modifies the cell (inserts a newline),something I cannot do for my read-only cell. The key combination thus does nothing, whereas it does insert the newline when I am in the other part of the document (the one which is writable). That suggests that you do have tables within cells of an outer table, since Alt+Enter otherwise does nothing. Another thing you can do to access the outer table cell is to position the cursor at the end of the last cell of the table which is within another table's cell, and press the right arrow key. The cursor moves out of the inner table, but still within the outer table's cell. It looks like a new line has been added, but that's just for display and still works even when the cell is protected; the extra line disappears again if you move out of that cell without adding anything. If you're not sure which cells might be the last cell of an inner table, it's probably the last one which you can't modify. Otherwise, just try pressing right arrow from the end of each cell in turn. Unless you have more suggestions, at this point, I think I will open a bug report so that I can attach the document and people can try things out. Bug reports are for reporting faults in the software. Unless the protected areas of the document have resulted from a bug, the report will quite likely be closed as invalid since the software is working as intended by not allowing changes to protected cells. You're better off uploading the document to a file sharing service, and pasting a link here. Alternatively, I hear the Nabble interface to the mailing list allows you to upload attachments and includes a link in the message email, although I've never used that so can't say how to do it: http://nabble.documentfoundation.org/Users-f1639498.html Mark. -- 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] Re: LO Writer (Linux): Way to do text search in set of documents?
Paul wrote: Well, it does seem like all your mails do this, but not all mails from this list exhibit this behaviour. Most mails from the list, even replies, are addressed to the list. Yours are different in that they're not addressed to the list, only CCd to the list. Some other people's replies are the same, but I'd say not most. When the mail is addressed to the list, or addressed to someone else and CCd to the list, I can just click reply, but when the mail is addressed to me personally and only CCd to the list clicking Reply replies to the sender only. I can only think that it's a difference in email clients and how they handle list messages. The messages contain list headers, so most clients, like mine, must pick that up and automatically reply to the list, but some, like yours, must be ignoring those and replying to the sender instead. I think. Indeed. I think Tom tends to Reply All, so you get two copies - one direct and one through the list. If you reply to the direct one, that doesn't have the List-* headers, so will go only to Tom by default. If you reply to the one received through the list, that does have the List-* headers and if your mail client uses them it will reply to the list. In my client, I have to select Reply to List to use the List-Reply header, but it sounds like yours uses it by default if available. So if I'm understanding the process right, it's not so much a problem with how the list is set up (other than that it doesn't rewrite the sender header), but rather with some clients not honouring the list headers. Yep. This list is set up differently from many others, but it is more correct. It shouldn't rewrite the From or Reply-To headers as that causes other problems, particularly as this list accepts emails from non-subscribed users who sometimes request a direct copy of replies. If the From or Reply-To address has been overwritten, it is difficult or even impossible to email or copy someone individually. The Sender header I think would be safe to overwrite, but doing so wouldn't be particularly useful as mail clients don't use it for replies. Mark. -- 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] Parts of document set to read-only by Writer: how to disable (normal methods not working)?
Vincent Rubiolo wrote: Dear LibreOffice users, I am running LO 4.2.6.2 on Fedora 20 (4.2.6.2-1.fc20) and I am updating Writer a document originally coming from OpenOffice. It is a one page list of errands, with contents in 2 tables. I can edit part of the document correctly (one table) but the other is uneditable because it is actually read-only. I can see that from the disalog that pops-up when attempting to edit (Readonly content cannot be changed.). The problem is that I: 1. AFAIK never asked for this part of the document to be read-only. 2. am unable to change that back to editable. Indeed, most solutions I have found ask to select the text/table and Choose Edit-Sections to enable back editing. In my case (attached captures), I can see the 'Sections' menu being grayed out in both cases. Also note how many more items are greyed out when in the read-only part of the document. Could sb tell me what I need to do here? I have been searching for hours on a way to do that without success... Thanks for your help on this matter! Vincent To protect cells in a table, you can select them and either use the menu Table Protect Cells, or right-click Cell Protect. You may have accidentally clicked one of those option at some point and not noticed since there's no immediately obvious effect; it's easily done. Having done that, Table Protect Cells is disabled so can't select that again to remove protection. However, you can right-click Cell Unprotect. A bit inconsistent, but hopefully that helps! I've submitted bug 83011 to report the inconsistency in options to remove cell protection: https://bugs.freedesktop.org/show_bug.cgi?id=83011 Mark. -- 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] Link to external data question
Jim Byrnes wrote: On 08/21/2014 03:16 PM, Mark Bourne wrote: Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert--Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPLf=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? I haven't used that feature before, but https://help.libreoffice.org/Calc/Link_to_External_Data says: Link to External Data Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range. The URL you're using points to a CSV file, which doesn't contain a named range (CSV is a very basic format, and doesn't support naming ranges). Using an ODS file with a named range works; after selecting the file, the ranges defined within the file are listed in the lower part of the External Data dialog, and the OK button is enabled once once is selected (with a CSV file, there are no ranges to select so OK is never enabled). But that's clearly no use to you unless Yahoo provides the data you want in that format... OK I understand now. Just seems strange that I can get the data I want in the Import Text dialog (just as I have done many times when importing csv files) but I can't get it into the spreadsheet. When I click ok in the Import Text dialog, focus goes to the Insert Dialog and the data is lost. It is a bit confusing. I think the Import Text dialog is needed to open the file - being plain text, it can't automatically determine things like the character encoding and whether cells are separated by commas, tabs or something else. Then, after opening the file, it finds that there are no ranges defined within the file. It would be more sensible if it gave some message that there are no named ranges in the file. Or, rather than requiring a named range, allow the whole sheet to be imported - but perhaps that's the purpose of the Insert Sheet from File option. It may be possible to pick up data from a table on an HTML page. That's liable to stop working when Yahoo change the layout of the page though, requiring you to go through the Insert Link to External Data again to find the table in the new layout, but might work well enough. Another possibility may be Insert Sheet from File, specify that URL rather than browsing to a local file, and select the Link option. It seems to be rather slow to import (maybe that's just my Internet connection), and I'm not certain if it will actually update as intended, but probably worth trying. I'd suggest not modifying the imported sheet, in case either you loose your changes when the sheet is updated or modifying it prevents future updates. You can then reference cell A1 from another sheet, which should then pick up changes assuming the imported sheet does update as intended. When I try this option I don't see any place to specify the URL, all I see is a file selection dialog. You can type (or paste) a URL into the File name field and it will open it. What I'm not sure of is whether it will automatically update as intended; may need some experimentation. Yet another option may be to set up a LibreOffice Base database connection pointing at the CSV file as its data source. (File New Database Connect to existing Spreadsheet Next Enter URL Next Finish). Not sure offhand if or how you can reference that from your spreadsheet though, and it is getting rather extreme just to get a single number! The whole thing is getting complex. I just wanted to link about 10 cells so I wouldn't have to type in the data manually. Not a big problem it's just that I am always looking for ways to automate stuff. Always handy when possible ;o) -- 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] linking in data from a file
Gregory Smith - Oracle Sparc Verification wrote: All I have an analysis spreadsheet that pulls data from sheets of several other spreadsheets.Under StarOffice, the technique I used was to open both spreadsheets, do a copy of the data in the source spreadsheet, go to a blank sheet in the receiving spreadsheet and do a paste-special with link specified.Under staroffice, when ever opened the receiving spreadsheet, it would automatically pull in the new data from the source spreadsheet even when the source spreadsheet was not open.Switch to LO and it will not link to the external data unless the source spreadsheet is open.I need to be able to link with out the source spreadsheet being open.Is there something I am doing wrong?A better way? Check the setting Tools Options LibreOffice Calc General Update links when opening. It should be possible to update the data on demand through Edit Links... Update. I have many spreadsheets set up this way, so forcing a change will be painful.I have tried link to external data, but my experience(a bit stale, admittedly) was that if the region in the source spreadsheet grew since the original link was established, it did not pick up the newer data. You copied a range of cells and pasted them as linked, so only those cells are linked. Data added to the source sheet outside of that range won't be copied across. You probably need to use Insert Sheet From File and select the Link option, to get the whole sheet and its contents. Don't add other info, formulas etc. to the imported sheet - it's content is completely replaced when updated so you'd lose your additions. Instead, the data can be referenced by formulas on other (non-linked) sheets. Mark. -- 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] Re: Turn Off All Automated Functions
Owen Genat wrote: TomD wrote Apparently at least many of the Autocorrect stuff is kept in a .dat file somewhere. Does anyone know where? Can it be edited? These locale-specific files are stored under share/autocorr/ in the install location. The XML files in each DAT can be extracted using an archive manager and edited. As is always the case, take care when doing so. That looks like the replacement table and exceptions, for all users of that installation. There are also user-specific versions under the user's profile (User Profile/autocorr/). Looks like some of the other settings (enabling / disabling various options) are specified in Install Path/share/registry/main.xcd and User Profile/registrymodifications.xcu I'm not sure where else relevant settings might be stored... Mark. -- 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] Issue with INDEX function
Gregory Smith - Oracle Sparc Verification wrote: AllI have created a one dimensional array called CATEGORY.When I do this function: =Index(Category,25,0)I get the contents of that index - lets say it is the word catsWhen I do this function =if((index(category,25,0)=cats),1,0)I get FALSE?!!Anyone have any ideas what I am doing wrong?gs With that formula, you should get 0 if the strings don't match (or 1 if they do); do you really get FALSE displayed in the cell? Assuming you actually get 0 (because the condition (index(category,25,0)=cats) is evaluating to FALSE), make sure there are no spaces in the values. cats is not equal to cats, even though they look the same. If spurious spaces are likely to be a problem, you may want to use: =if((trim(index(category,25,0))=cats),1,0) to remove spaces either side of the value (and collapse multiple spaces within the value into single spaces) before comparison. Mark. -- 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] Turn Off All Automated Functions
Paul wrote: I think the language settings need an overhaul and consolidation, and at least a way to toggle it all off and on in one shot, for people that occasionally need to enter some text that should stay verbatim and uncorrected. You can disable spell checking for selected text, whole paragraphs, or the whole document: Tools Language For [Selection | Paragraph | all Text] None. Paragraph styles can also be set to use a particular language (or no language) on the font tab of the style settings. So, for example, a paragraph style for formatting source code or giving command line examples can be set up to use a monospaced font, indent the paragraphs, etc... and to have no language so it is not spell checked. To disable spell checking by default for all future new documents: Tools Options Language Settings Languages Default languages for documents Select [None]. Mark. -- 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] Turn Off All Automated Functions
Paul wrote: Thirdly, it can get stuck in a repetitive cycle: Open a blank Writer document and type cat followed by enter. See the initial c get capitalized. Press ctrl-z to undo the enter, and again to undo the capitalization. That doesn't look right to me... If you type a space and it automatically capitalises, the first undo undoes the capitalisation and a second undo undoes the space. I would have thought it should be the same for a new paragraph - first undo should undo the capitalisation, and a second undo should undo the new paragraph, not the other way around...? Hit end, and retype the enter. See the initial c get capitalized. Wash, rinse, repeat. Yes, you can break the cycle by typing a space after the cat, then pressing ctrl-z to undo the capitalization, then pressing enter, then going back to the first line and deleting the space at the end of the line and then going down to the new line. One could also open Notepad, type the text in there, then copy and paste it into Writer. But that is a bit tedious, and kind of misses the point of Writer, don't you think? Those are indeed workarounds. Personally, I disable a lot of the autocorrect features. Apart from avoiding the hassle when I don't want something corrected, it also helps me learn to type right in the first place! Mark. -- 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] Turn Off All Automated Functions
Mark Bourne wrote: Paul wrote: Thirdly, it can get stuck in a repetitive cycle: Open a blank Writer document and type cat followed by enter. See the initial c get capitalized. Press ctrl-z to undo the enter, and again to undo the capitalization. That doesn't look right to me... If you type a space and it automatically capitalises, the first undo undoes the capitalisation and a second undo undoes the space. I would have thought it should be the same for a new paragraph - first undo should undo the capitalisation, and a second undo should undo the new paragraph, not the other way around...? And has already been reported as a bug: https://bugs.freedesktop.org/show_bug.cgi?id=70520 Mark. -- 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] Turn Off All Automated Functions
Paul wrote: On Thu, 21 Aug 2014 15:43:50 +0100 Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: Paul wrote: I think the language settings need an overhaul and consolidation, and at least a way to toggle it all off and on in one shot, for people that occasionally need to enter some text that should stay verbatim and uncorrected. You can disable spell checking for selected text, whole paragraphs, or the whole document: Tools Language For [Selection | Paragraph | all Text] None. As I mentioned in my mail, that doesn't stop things like initial capitalization. Paragraph styles can also be set to use a particular language (or no language) on the font tab of the style settings. So, for example, a paragraph style for formatting source code or giving command line examples can be set up to use a monospaced font, indent the paragraphs, etc... and to have no language so it is not spell checked. Again, language settings don't seem to affect things like initial capitalization. Ah, sorry, my misunderstanding; I thought you were referring to the spell-check language settings in that last comment. Can one set those options on a per paragraph style basis? Not that I know of, but it may be nice even if just an option to disable all autocorrect features for the paragraph style. Perhaps one for a feature request, although it may need to be supported in the ODF spec. Enabling or disabling each feature individually for each style would probably be too confusing, and difficult to support across applications with different sets of features. I see the use of disabling all autocorrect for a paragraph; as you say, you may want text typed into that type of paragraph to be left unaltered for whatever reason. I don't think paragraph styling should be able to specifically ENable features though; that would just lead to behaviour unexpected by a user who finds that capital letters are being added and words replaced etc., regardless of their own autocorrect settings, but only in a particular paragraph of a particular document (which perhaps someone else sent to them, or they copied from someone else's document). Mark. -- 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] Proofreading problems...
Perhaps check that: Tools Options LibreOffice Writer View Display Comments is enabled? Also Edit Changes Show might have some effect on comments from a Word document? I think in Word visibility of comments and tracked changes are toggled together by the same option. Not sure if that would carry over to a Word document opened in LibreOffice though... Mark. Tom Davies wrote: Hi :) ] Weird! Have you been able to try another document to see if that now works, ie if LO just needed a nudge before it works for all? If that is all solved now that would be great but if each document needs to be nudged in the same way that could be really painful! (and probably easier to report as bug because it's less like an intermittent bug) I imagine the track changes tools is good when everyone is using the same version of MS Word or when everyone is using non-MS. The rest of the time it might be easier just to use the compare documents approach instead. I vaguely remember someone saying that track changes was more elegant and sophisticated but obviously only when it works! Regards from Tom :) On 21 August 2014 15:05, Rogier F. van Vlissingen vlisc...@gmail.com wrote: It just got funnier. Last night I opened the SAME document for about the 4th or 5th time, and suddenly the comments started showing up in LO as they should... So, there still is something going on, but it's not like LO is losing them. I'll experiment with this and see if I can nail it sufficiently to report it. *Rogier Fentener van Vlissingen http://viz.me/vliscony/t/7* *About Me http://about.me/vliscony* On Wed, Aug 20, 2014 at 4:09 PM, Tom Davies tomc...@gmail.com wrote: Hi :) Good point. There is a feature for comparing 2 different documents, or the same document stored in 2 different folders. That gives all the red writing like track changes does in Word, or does something to show the differences and those can be accepted, rejecte or left til later. However i thought the comments were a bit different from that? I thought it was the sort of thing teachers used to do to my essay to show where i had missed the point or been astute Regards from Tom :) On 20 August 2014 18:35, Felmon Davis dav...@union.edu wrote: fellows, sorry for the bad form of not quoting the thread! won't happen again! very, very obvious thing to check but maybe worth mentioning: doesn't one have to check something called 'changes' or whatever (don't have the program here) to see comments? I hate the whole commenting facility as such, and it is tricky between different word processors. F. -- Felmon Davis If you want to make God laugh, tell him about your plans. -- Woody Allen -- 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] Link to external data question
Jim Byrnes wrote: I would like to import some stock quotes from finance.yahoo.com into a calc sheet. As a test I select cell A1 Insert--Link to External Data and I get the External Data dialog Put http://finance.yahoo.com/d/quotes.csv?s=AAPLf=a in the URL box The OK button stays greyed out I hit ENTER and I get a Text Import dialog with a number in the Fields section When I hit OK I am sent back to the External Data dialog, OK button still greyed out and when I close the dialog, nothing is entered in A1. What do I need to do to get the stock quote entered in the cell? I haven't used that feature before, but https://help.libreoffice.org/Calc/Link_to_External_Data says: Link to External Data Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range. The URL you're using points to a CSV file, which doesn't contain a named range (CSV is a very basic format, and doesn't support naming ranges). Using an ODS file with a named range works; after selecting the file, the ranges defined within the file are listed in the lower part of the External Data dialog, and the OK button is enabled once once is selected (with a CSV file, there are no ranges to select so OK is never enabled). But that's clearly no use to you unless Yahoo provides the data you want in that format... It may be possible to pick up data from a table on an HTML page. That's liable to stop working when Yahoo change the layout of the page though, requiring you to go through the Insert Link to External Data again to find the table in the new layout, but might work well enough. Another possibility may be Insert Sheet from File, specify that URL rather than browsing to a local file, and select the Link option. It seems to be rather slow to import (maybe that's just my Internet connection), and I'm not certain if it will actually update as intended, but probably worth trying. I'd suggest not modifying the imported sheet, in case either you loose your changes when the sheet is updated or modifying it prevents future updates. You can then reference cell A1 from another sheet, which should then pick up changes assuming the imported sheet does update as intended. Yet another option may be to set up a LibreOffice Base database connection pointing at the CSV file as its data source. (File New Database Connect to existing Spreadsheet Next Enter URL Next Finish). Not sure offhand if or how you can reference that from your spreadsheet though, and it is getting rather extreme just to get a single number! Mark. -- 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] Error at the time of auto saving process.
Farhad Ahmad wrote: I was doing work on Libre office for page crop and contras like edit of a PDF book made from scanned image, at the time of auto saving process the software uses to stop working, it saved the file and after some page there was just a small icon instead of the original page. Pls help me to get rid of the problem. Files containing large (in terms of pixels, not printed size) images can take a noticeable time to save, and that includes auto-savings. Keystrokes and mouse clicks may be stored up while LO appears to be unresponsive, and then processed once it's finished saving and starts responding again. It's possible that, while LO appeared to be unresponsive, you've ended up adjusting the zoom to a small size so that the page appears about the size of an icon. Try adjusting the zoom scale - from the View menu, select Zoom... and then either 100% or Entire Page (or another option) depending how large you want the page displayed. If that doesn't help, could you clarify: - Are you using LO Writer or LO Draw? - Where are you seeing just a small icon? e.g. is that in Draw's left-hand pane (which shows a small preview of each page), or in the main area where the page is usually edited? Mark. -- 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] Currently Using Spreadsheet for Personal Project - Thinking About Database
Paul wrote: So I was interested, and did a little more digging. I figured I would share the info. On Sun, 10 Aug 2014 22:48:43 +0100 Mark Bourne libreoffice-ml.mbou...@spamgourmet.com wrote: I don't know to be honest, not having a lot of experience in database design. I've only ever really used MySQL, which does support enums, but maybe that's just a MySQL feature. Seems like it is a MySQL specific feature, although PostgreSQL seems to support it. Ah, so definitely best avoided if portability is a concern! And probably advisable to avoid even if portability isn't an immediate concern. To me, the set of possible status values just seems more like part of the database schema design than data entry - you wouldn't generally add or remove status options (and the application may assign special meaning to certain statuses, so it may be critical that a specific set of values is defined). Then again, in some applications being able to introduce new statuses at any time could be an advantage. Yeah, being able to change these values later is one of the main reasons to use a separate table. Clients almost *always* end up adding or removing some of these. The database work I've done has been for either myself or small voluntary organisations I'm involved in, so I've never really had to deal with that. Where the set of values could obviously be expanded (e.g. to indicate colour of something) I'd certainly do that with a table containing the options. My main use for enums has been to indicate things like male/female gender, allowing null if I need to allow for an unknown value (point taken - someone might would want to expand that list of options...) Also, when you have specific functionality tied to some of these statuses, it's always a good idea to add a flag field for it, and make your code check if the flag is on, rather than if the status name matches a specific value, so that if the client ends up deciding (as they invariably will) that actually a second status must also do that thing that they assured you only the one status would ever do, then you simply turn that flag on for the second status, rather than having to change your code base and hunt for all instances of checking for the status by name. One of the places I have used enums was for that kind of a flag, where there were three options for how the application could handle a record. Essentially an event booking database where each participant was assigned to one of about 10 groups, and each group needed to be handled by the application in one of three different ways (displaying different sets of options), so I had a group type enum (with three possible values) on the groups table indicating to the application how participants in that group should be handled. Looking back, I actually did end up writing code into the application to decode that group type into a set of flags indicating which parts of the GUI should be displayed and which options should be offered - with the intention of porting that into a database table. I just never got round to doing that before the event was over. So it seems I'm violently agreeing with you! Also, then you can localize your status names if you ever want to make your program support other languages. Something else I haven't had to worry about, but if I did I'd have done the localisation in the application - the enum values (as I use them anyway) are not generally displayed as-is to the user anyway, they're just convenient names to use in the database. Using localised status names in the database table surely hinders localising the application - if you wanted to connect both English and French front-end applications to the same back-end database, wouldn't they both get the same status names to display, rather than the names appropriate for the application language? Or would the status table in that case contain strings in one language (or perhaps even generic keywords) for which the application would look up translations in it's own localisation table? The page here gives some benefits and pitfalls, but I don't see any of the benefits as not being provided by the separate status table solution: https://www.udemy.com/blog/mysql-enum/ This page also gives a few more reasons why you shouldn't use them, and prefers reference tables, which I called status tables: http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/ Some interesting points there, thanks. While most of those reasons may not apply to this project, the two that do for me are: 1) The statuses are data, and shouldn't be stored as structure. This is a conceptual thing, but it's best to start out thinking the right way. In this particular case with statuses, I could go either way and do see your point. I might even go with having date started and date finished fields and determining whether a book is unread, in progress or completed from those. More generally, I'd certainly use
Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database
It looks like each book should only have one of the ReadStatus flags set, so I'd make that an enum field on the BookInformation table, with possible values of Not Read, Reading and Read. You can set the default value for the field to Not Read so a new record will be set to that status if no value is specified for that field. NumberOfBooksByAuthor and ReadBooksByAuthor are not needed on the AuthorInfo table - you can get those by querying the database. I may have the syntax slightly wrong here, but along the lines of: SELECT `ai`.`AuthorID`, `ai`.`AuthorName`, COUNT(`bi`.`BookID`) from `AuthorInfo` `ai` LEFT JOIN `BookInformation` `bi` ON `bi`.`AuthorID` = `ai`.`AuthorID` GROUP BY `ai`.`AuthorID` should give the number of books by each author. Add: AND `bi`.`ReadStatus` = Read to the ON condition and you can get the number of read books by each author. That's the kind of thing a database enables you to do much more easily than with a spreadsheet ;o) Mark. Joel Madero wrote: Hi All, So I went back to planning stage. Link to what I think might work - hoping to get the planning stage done today so I can start actually putting together the db - I have 3 days off so now's a good time for me to get the basic structure together :) Thanks in advance! https://drive.google.com/file/d/0B2kdRhc960qdbGJIQ1M3NWtrdmc/edit?usp=sharing Best, Joel -- 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] Intermittent Calc Issues
Not sure; it's just a possibility to rule out. One possible explanation is that the seemingly stuck key doesn't have any effect in other applications you use. In Gnucash, Shift+Arrow keys or Shift+Click just moves the selection - the same as just pressing the arrow keys or clicking without holding Shift - so you may not notice if Shift was stuck. In LO Calc, Shift+Arrow or Shift+Click selects a range of cells rather than moving the selection, so you do notice different behaviour. In the case of the Shift key appearing stuck you'd notice it as soon as you type a letter and get upper case instead of lower case though... but perhaps you usually want to start with an upper case letter anyway so press and release shift while typing that letter - and releasing the key would likely clear the fault for the following lower case letter. Since this only seems to happen occasionally, if you're not able to change the keyboard long term perhaps just carry on as normal and next time it does start happening try pressing (and releasing) each of the Ctrl, Alt and Shift keys in turn (remember there are often two of each, so press and release both in turn). If that then clears the faulty behaviour, it sounds even more like a faulty keyboard / cable / hub - doing this sends a key down and key up message for each key, and chances are that this time the key up messages get through OK indicating to the PC that the key is no longer held down. Or it may not the problem in your case - as I said, just a possibility to rule out. I have experienced strange symptoms like you describe before which did turn out to be a faulty keyboard, USB hub or cable (can't remember exactly which bit of hardware was at fault, but the symptom was that the PC would occasionally act as if a key was held down even though it wasn't, and pressing and releasing that key would clear the fault). Mark. Gregory Forster wrote: Hi Mark, That gives me something else to try - plugging in another keyboard. This notebook computer is still under warranty and now would be the time to find out. But what still puzzles me, is why only Calc? Why doesn't it affect any other program? I extensively use Gnucash also. One thing I failed to mention, all my Gnucash files, as well as many personal LO medical and financial files are encrypted using Truecrypt. I have Truecrypt running to access Gnucash as well as many personal medical and financial files (IRA spreadsheet). But, as I told Tom, I've completed my IRA spreadshheet, so now I have to think up of some other elaborate spreadsheet. Greg On 8/6/2014 11:42 AM, Mark Bourne wrote: To rule out the keyboard possibility, perhaps try a different keyboard, plugged directly into the PC (no USB hubs or other cables in between). I've previously found that a faulty keyboard (or USB cable or hub between keyboard and PC) can act as if keys get stuck down (seems like the PC sometimes gets the key down message but not the key up message, so thinks it's still held down). A stuck character key is usually obvious as it keeps repeating, but not so obvious with Ctrl, Alt, Shift, etc. which only have an effect when you press something else - which then doesn't do what you expect. If pressing and releasing keys a few times unsticks them (PC gets the key up message this time), which it sounds like you've found with the shift key, that may well be the cause. I'm not sure if combinations of Ctrl, Alt, Shift or other keys along with those you're pressing can cause the effects you describe. Perhaps more likely if you're using the numpad arrows (rather than the separate arrow keys) as those keys can enter other characters when Alt is held down - e.g. for me Alt+822 (up, down, down) gives 6 and Alt+826 (up, down, right) gives :. Certainly Shift + Click or arrow keys selects an area rather than moving the active cell. Mark. Gregory Forster wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things
Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database
Paul wrote: On Sun, 10 Aug 2014 21:30:18 +0100 Mark Bourne wrote: It looks like each book should only have one of the ReadStatus flags set, so I'd make that an enum field on the BookInformation table, with possible values of Not Read, Reading and Read. You can set the default value for the field to Not Read so a new record will be set to that status if no value is specified for that field. That's essentially the same idea as the status tables I was suggesting. Indeed; I think our replies crossed in the post ;o) In my experience we've always used status tables, so I would suggest those. I wouldn't dispute that. Partly because I'm not familiar with database support for enums. How well supported and widely supported is that by the most common databases? I don't know to be honest, not having a lot of experience in database design. I've only ever really used MySQL, which does support enums, but maybe that's just a MySQL feature. To me, the set of possible status values just seems more like part of the database schema design than data entry - you wouldn't generally add or remove status options (and the application may assign special meaning to certain statuses, so it may be critical that a specific set of values is defined). Then again, in some applications being able to introduce new statuses at any time could be an advantage. Mark. -- 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] Intermittent Calc Issues
To rule out the keyboard possibility, perhaps try a different keyboard, plugged directly into the PC (no USB hubs or other cables in between). I've previously found that a faulty keyboard (or USB cable or hub between keyboard and PC) can act as if keys get stuck down (seems like the PC sometimes gets the key down message but not the key up message, so thinks it's still held down). A stuck character key is usually obvious as it keeps repeating, but not so obvious with Ctrl, Alt, Shift, etc. which only have an effect when you press something else - which then doesn't do what you expect. If pressing and releasing keys a few times unsticks them (PC gets the key up message this time), which it sounds like you've found with the shift key, that may well be the cause. I'm not sure if combinations of Ctrl, Alt, Shift or other keys along with those you're pressing can cause the effects you describe. Perhaps more likely if you're using the numpad arrows (rather than the separate arrow keys) as those keys can enter other characters when Alt is held down - e.g. for me Alt+822 (up, down, down) gives 6 and Alt+826 (up, down, right) gives :. Certainly Shift + Click or arrow keys selects an area rather than moving the active cell. Mark. Gregory Forster wrote: Woops, I meant to click the spell-check and not the send. That all explains well for the unexplained highlighting, but what about the random ;6 (semi-colon and the number six) at times, or the random : (colon) at times, replacing cell contents by just pressing a directional arrow key. That, I can't figure out. No, I won't sack my tech (he's my son - we work together). It ONLY happens with LO Calc, not Impress, or Writer, or Base, or any other program. In fact, I extensively use Gnucash. I am the Treasurer, Financial Accountant and do the payroll for church and also use Gnucash for personal finance records - No problems. However, you did give me ideas and reminders. I've always been very passionate about backups and keeping your hard drive clean from malware, viruses, rootkits, etc. of which we also nag our clients about.. I forgot about keeping the keyboard clean. Thank you. Greg On 8/5/2014 1:58 AM, Brian Barker wrote: At 22:25 04/08/2014 -0500, Gregory Forster wrote: I have an inconsistent and not often issue with Calc. [...] Calc does weird things now and then. [...] Sometimes, I complete a calculation in a cell, and press the Enter or Down Arrow key. My calculation will disappear and a ;6 will appear in the cell. Or I may randomly highlight a cell to check a formula, then when I press a directional arrow, my calculation will disappear and a : will reside in that cell. Sometimes, I'll just move an arrow key, or the mouse to move from one cell to another and wherever I move will highlight as if I was holding down the Shift key. [...] This all started in early July. [...] I changed different versions of LibreOffice (vs 4). I have LO 4.3.0, 4.2.5, 4.2.2, 4.1.4, 4.1.3, 4.1.2, and 4.0.3 (which I am currently using). I still had the same issues with whichever version used. I discussed the issues and history with another tech and he reasoned (the same as I) that LO was having memory conflict issues with one or more simultaneous running programs. What, you mean that LibreOffice - in many different versions - is improperly sharing memory with other programs for you but not for anyone else? And why would that behaviour change in early July? Perhaps you should sack your tech. My questions are: Has anyone else experienced the same? I doubt it - at least, not as a problem with the software. Does my reasoning sound feasible? Nope. Any ideas? If you spend a lot of time on one project or using one application, it is very easy to blame a more general problem with your computer on the particular application. o Try draining the spilt coffee from your keyboard. o Try shaking the biscuit crumbs from your keyboard. o Try poking out the cat hairs from your keyboard. o Try running your computer manufacturer's diagnostics (especially those for the keyboard). o Try attaching an external keyboard and using for a sufficient period to test. o Does your notebook have a trackpad? Is your thumb or palm grazing the trackpad as you move your fingers about? You won't believe this is possible, so get someone else to watch as you use the system for a period. Try temporarily disabling the trackpad or reducing its sensitivity to test. I trust this helps. Brian Barker -- 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] LibreOffice Still?
Tom Davies wrote: I am beginning to like the sound of mature branch and young branch. http://en.wikipedia.org/wiki/Mature_technology : A mature technology is a technology that has been in use for long enough that most of its initial faults and inherent problems have been removed or reduced by further development. Seems to fit the bill nicely. Of course a google search for mature, or young, might bring up some bad sites that we wouldn't want to be associated with. It's annoying because otherwise that might be a really good way of describing the difference between the 2 branches. Someone looking for info on the mature version of LibreOffice isn't going to search simply for mature; they're going to include LibreOffice in the search terms. Currently, a quick search on Google for LibreOffice mature download gives at least the first 3 pages of results all relating to LibreOffice. I don't see mature as being any worse than fresh in terms of other connotations it might have (I'm in the UK; maybe it's different in other parts of the world...) So i think we still need to try to think of a really short name for each branch that describes what it's advantage is over the other branch. Fresh and Mature seem fine to me. Alternatively, perhaps long term support for the older branch, although I'm not sure that's really accurate since the life cycle of the stable/still/mature/LTS/whatever branch is no longer than any other. As someone else mentioned, whatever terms are used need to be explained in a few words on the downloads page. To me, Still sounds like that branch is stagnant, no longer developed, abandoned... (more apt for the 4.0 branch I'm still using ;o) Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Page break is not correct with printing
Albert Oszkó wrote: Hi all, I am new to this list, and I subscribed to try to get some help previously asked on the opensuse forum, but could not get a good answer yet. I copy some of my letters sent to that list In every month I get a kind of form, an Excel sheet which should be filled, then printed and undersigned in the last row . The original document is created in MS Office 2010 AFAIK, but is saved in *.xls, not xlsx format. When I open it in LibreOffice, it looks just fine, but when it comes to printing, the last row, the undersign, slips to a new page. I was advised to use Kingsoft Office. This originally Chinese package was praised to the heavens in terms of MS compatibility and usability, so I gave it a try. Hmmm. My sheet fell apart, and while it recognized that it was edited with Arial Narrow font, the typography was simply ugly. The letters was in different distances from each other. I read a lot, including forums, so I met Softmakers Freeoffice. I installed it. The outlook is a bit vintage, but that should not be a problem. Opened my document, looked fine, but just as for LO, the last row slipped to a new page ( the original document fits on a single A4 page). Pdf export seems to work. But there is an interesting thing I noticed: Earlier we got that document for a whole year, and a month was represented by a tab. When I exported that Excel sheet opend by LO to Pdf, then the 1st, 3d, etc sheets were OK, that is, fit to a page, but the even ones had the last line on a new page. Interesting, isn't it? So is there a workaround? I would cling to LO, if possible. What is the reason that it still cannot render a not too complicated MS document correctly. I use LO with openSUSE 13.1 and KDE 4.13.3 Any hints and opinions are welcome. It sounds like the form just about fits on a page for the original author. Any slight difference in fonts, spacing etc. could push the last row onto a second page. Similarly, if the sheet only just fits the width of a page, the last column can get pushed off by slight variations. Even different versions of MS Excel can end up rendering the same document slightly differently. Particularly if you don't have the same fonts installed as are used in the document, in which case substitutes are used. A few potential workarounds: 1. Format Page Sheet Scale Fit ... on number of pages 1 2. Format Page Page, Slightly reduce top and bottom margins 3. Slightly reduce the height of one or more blank rows (if any) being used for spacing. Ideally get the original author to make sure the form fits on a single page with plenty of space to spare (horizontally as well as vertically), so you (and others) don't have to keep adjusting it every time. That will help ensure the form is usable across different systems and software versions. Mark. -- 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] Nitpicking on a name
I'd always seen LO as being simply an abbreviation for LibreOffice in the same way that OOo was an abbreviation of OpenOffice.org. I'd never associated it with any suggestion that LibreOffice is lo(w) quality. As for MS, a single acronym can have many different meanings. It's one of the problems with using them out of context (TLAs - that's Two/Three Letter Acronyms, not Texas Library Association - are particularly overused). The financial papers may well abbreviate Microsoft in one way, but that's not to say it's the only way. From a quick look, MSFT is used as an abbreviation for Microsoft, at least on NASDAQ - where MS is also used, but for Morgan Stanley. MS is a common abbreviation for Microsoft (yes, and Multiple Sclerosis, and many other things). http://www.acronymfinder.com/MS.html lists 230 meanings for MS, the first of which is Microsoft. http://en.wikipedia.org/wiki/MS also lists several possible meanings for MS, again including Microsoft. So MS has a different assumed meaning depending on the context. If you're talking about computer software, MS may mean Microsoft, if you're talking about finance it may mean Morgan Stanley, or if you're talking about medical conditions it may be Multiple Sclerosis. Nothing to say any of those uses are an offence to any other. Mark. anne-ology wrote: silly is as silly does this is not; rather inane, bordering on insane ;-) OpenOffice was referred to as OO ... LibreOffice was an offshoot of this thus LO. [and yes, I have used this program since the days of OO.] BTW - Microsoft is properly abbreviated as MsFt - check any financial paper if you disbelieve. MS stands for Multiple Sclerosis; which is a crippling disease which some folks have - [and yes, I know some who do have this disease] therefore to use this acronym for other things seems to be a slap in the face to these disabled folks. From: Charles-H. Schulz charles.sch...@documentfoundation.org Date: Fri, Jul 25, 2014 at 2:19 AM Subject: [libreoffice-users] Nitpicking on a name To: users@global.libreoffice.org Hello everyone, I apologize as what I am writing about might seem like a detail to many, but I think it hurts a bit the project in the end to leave these things as they are. On this list (a few others as well but esp. On this one) people call LibreOffice LO. We -sorry to take on my founder's hat here- never called LibreOffice LO. Historically the people who did were long time OpenOffice.org users who were a bit skeptical of us at first and who felt necessary to formatLibreOffice in a way they thought was easier. Now you will tell me that it is easier to type LO than it is with LibreOffice. Perhaps. But everyone here writes MS Office... Anyway the point I am trying to make is that LO does not mean anything and sends the wrong message. We are not low , we are not hello, we are libre people. Ans when I say we I lean everyone here. Thanks! Charles. -- 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] scale a Writer document to print on one page
Kracked_P_P---webmaster wrote: As for your description of A-size - - - 8.5 x 11 inches is not an A size that I have heard of. It is US Letter. I have never seen any reference that US Letter described as A size. The closest is A4, but A4 is a little narrower and a little taller. B is 11x17 inches - also called Tabloid. Super B is 13x19 inches JB4 - 257x364 mm B5 - 176x250 mm JB5 - 182x257 mm A6 - 105x148 mm A5 - 148x210 A4 - 210x297 A3 - 297x420 A3+ - 330x483 mm These sizes are according to my HP Officejet 7000 wide format printer. Since it does not print larger than Super B, I do not know the actual inches for C or E sizes. [except C6 Envelope - 114x162 mm] http://www.papersizes.org/ is quite handy for looking up paper sizes. It also explains how the ISO (A4 etc.) sizes are actually defined - e.g. A0 has an area of 1 square metre, and aspect ratio of 1:sqrt(2) (which gives it the property that cutting a page in half along it's long edge results in a smaller page of the same aspect ratio), then each subsequent A-series size is derived by cutting the previous size in half. The US ANSI A, B, C, D and E sizes are not related to the ISO A-, B- and C-series sizes. So ANSI A is nothing to do with ISO A4 (although it happens to be very roughly the same size), and ANSI C nothing to do with ISO C6. Mark. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MAIL MERGE: Default fields Topic and Subject are only printed in first document
Number of the bug Sven raised is 81782: https://bugs.freedesktop.org/show_bug.cgi?id=81782 Mark. Sven Schüring wrote: Hi Alex, thanks for your confirmation. I've raised a bug to writer component as followed: https://www.libreoffice.org/get-help/bug/ regards, Sven On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk wrote: Sven I can confirm your problem. I see Title/Subject only on the first page irrespective of whether I save the final merged document as a whole or as individual documents. I tested using the Mail Wizard tool. Raise it as a bug and post back here the reference. Alex On Thursday 24 Jul 2014 21:44:16 Sven Schüring wrote: Hi, I've some trouble with the default fields Topic and Subject of the document properties. They are only printed in the first mail merge document if I set the field to the document. At the following documents there are only whitespace. Can anyone confirm my problem? Is it a bug or a misused by myself? regards Sven -- 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] Calc - Auto fill stepped cell reference
IGraham wrote: Hello and good morning Calc Is it possible to auto fill a stepped cell reference ? I've been trying without result What i want is in a cell (or two ) a cell reference, to highlight that cell and drag down So the first few cells might be A1 A8 A16 highlighting and dropping would produce A1 A8 A16 A24 A32 A40 etc I've got a few columns needing the same stepped cell reference and this could save me some time Fill in the first three cells as you explained: A1 A8 A16 Then select the second and third (i.e. A8 and A16), and drag the handle at the lower right corner of the selection down. Calc fills the range using the same interval as between the selected cells (i.e. 8) - so subsequent cells are filled with A24, A32, etc. It doesn't work if you select all three, as the intervals between the first and second and second and third are different. Mark. -- 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] Problem with standard filter
Ah yes, I didn't mention that bit on my addition to #46062. A workaround for that case is: - Select Standard Filter... rather than any tick boxes - Set the Field name to - none - - Click OK I notice you've mentioned on #46062 that Excel includes a (blanks) option. That's the kind of thing I was thinking, but not sure how to avoid confusion with a filter for cells literally containing (blanks). How does Excel handle that? Do you get two seemingly identical entries - one to filter for blank cells and one for cells containing the string (blanks) - or is the one for blank cells unambiguously different in some way? Mark. Rob Jasper wrote: The same inconsistency also makes that if one filter on the only one value available by filtering on 'Not empty', and subsequently deletes the value fro the visible rows, it is impossible to switch off the selection (since 'All' doesn't work as being really all). I opened [Bug 81577] for this. -- 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] Problem with standard filter
Ah yes, I didn't mention that bit on my addition to #46062. A workaround for that case is: - Select Standard Filter... rather than any tick boxes - Set the Field name to - none - - Click OK I notice you've mentioned on #46062 that Excel includes a (blanks) option. That's the kind of thing I was thinking, but not sure how to avoid confusion with a filter for cells literally containing (blanks). How does Excel handle that? Do you get two seemingly identical entries - one to filter for blank cells and one for cells containing the string (blanks) - or is the one for blank cells unambiguously different in some way? Mark. Rob Jasper wrote: The same inconsistency also makes that if one filter on the only one value available by filtering on 'Not empty', and subsequently deletes the value fro the visible rows, it is impossible to switch off the selection (since 'All' doesn't work as being really all). I opened [Bug 81577] for this. -- 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] Problem with standard filter
Sorry - replied from the wrong account; I've resent from an address subscribed to the list. Please don't forward the moderated copy to the list. Thanks, Mark. Mark Bourne wrote: Ah yes, I didn't mention that bit on my addition to #46062. A workaround for that case is: - Select Standard Filter... rather than any tick boxes - Set the Field name to - none - - Click OK I notice you've mentioned on #46062 that Excel includes a (blanks) option. That's the kind of thing I was thinking, but not sure how to avoid confusion with a filter for cells literally containing (blanks). How does Excel handle that? Do you get two seemingly identical entries - one to filter for blank cells and one for cells containing the string (blanks) - or is the one for blank cells unambiguously different in some way? Mark. -- 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] Re: Problem with standard filter
Urmas wrote: Rob Jasper: If I unselect ALL, aaa gets unselected too (reasonable, since that the gebaviour for more the one slection values too) If I now select aaa, the ALL mark is also automatically selected!! This looks plain wrong to me since no filtering is different then filtering on 1 value, since there are also empty fields. https://bugs.freedesktop.org/show_bug.cgi?id=46062 Good catch; I had to read it a couple of times to see that the original comments before yours are describing a similar problem. I've added a demo file and more detailed description which is hopefully sufficient for others to reproduce. It is possible to do what is asked, using the more advanced Standard Filter... dialog rather than the immediately visible tick boxes. The way the tick boxes work in this case isn't particularly intuitive though, particularly when they give the impression that the current filter is set to something other than what it is. Mark. -- 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] Re: File corruption on OSX and LO 4252
Owen Genat wrote: Alex Thurgood wrote ... file corruption when writing to an external disk drive. ... I have an external FAT formatted LaCie hard drive to store my files on. ... I was working from a USB external hard disk. First question which occurs to me - Have you had problems with other drives, or only this one? It could be that the disk is failing, so it would be a good idea to back it up ASAP (if you don't already) just in case. Maybe even stop using that disk until you've tracked down the problem - it might stop happening with a different disk (pointing to a faulty disk) or it might turn out to be something else, but either way it'd be better to be safe! As they say, there are two types of disk - those which have failed, and those which will fail ;o) I would first try to reproduce the error without a USB external storage device being a factor. I cannot recommend working directly from a USB device. Ever. The risk of failure (in all contexts) seems to go up considerably when doing so and I myself have suffered from this (although not with LO). Not an answer I know, and you have my full sympathy and respect Alex, just a possible avenue for further testing. To add to that, I've found using USB disks through a hub to be rather unreliable at least on the one Windows laptop I regularly use with a hub. It may just be my hardware or some combination of things in my setup, but they'll unexpectedly disconnect (and sometimes reconnect almost immediately), particularly while transferring large amounts of data (e.g. while backing up onto a USB disk). Connecting the disk directly to a USB port on the laptop, without the hub, is usually fine. I've never tracked down whether it's the laptop hardware, hub, drivers (either for host controller or hub) or something else, but have experienced this with a couple of different hubs, several different disks and even my scanner sometimes plays up through the hub while being rock solid on a direct port. Not saying it's necessarily the problem here, but something like that happening at the wrong moment during a write could corrupt a file. I am not discounting an LO problem as your description sounds similar to this bug: https://bugs.freedesktop.org/show_bug.cgi?id=78260 The example file does open in Writer (displays garbage), If the file is corrupted and Writer can't work out the format, it interprets as plain text. The garbage seen is the raw data from the file, seemingly with hashes for non-printable characters. In the case of the file on that bug report, it looks like there is some other garbage (possibly fragment of a different file) at the beginning (the first PK is where the file should start), and data is missing from the end of the file. Looks a crash (or disk disconnect or failure) in the middle of writing the file has messed up the file system entries. but cannot be opened by an archive manager. Because it's not a valid ZIP file. Best wishes, Owen. Mark. -- 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] Small bug(?) when loading file into Writer
Jon Harringdon wrote: (Aside: in fact, I looked into putting this through the LO bug reporting system. However, after a few quick glances I was left with the impression that the system seemed designed to actually keep non-IT people from posting bugs than to support them in doing so.) The full-featured tracker is at https://bugs.freedesktop.org/ and I can understand that being intimidating for anyone not familiar with it. There is a bug submission assistant at https://www.libreoffice.org/get-help/bug/ which I assume is intended to simplify the process for non-experts to submit new bug reports. If you have problems with that one, it may be worth starting another discussion (i.e. new email to users at global.libreoffice.org with a relevant subject, rather than replying to this email) describing specific areas which are unclear. Someone may be able to help explain, or even update the assistant based on that feedback. Mark. -- 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] Problem with standard filter
Rob Jasper wrote: Hi, I hope someone can help me with this... I have a spreadsheet with around 4000 rows in it. It has an autofilter in de co;umn headings. In column B I have some 10 fields containing aaa, and 3 fields bbb. Now I filter on bbb I clear the 3 fields If I mark all (it is not marked upon opening) in the filter I get indeed the whole list If I now repeat this for the aaa fields: upon opening the all and aaa is ticked If I unselect ALL, aaa gets unselected too (reasonable, since that the gebaviour for more the one slection values too) If I now select aaa, the ALL mark is also automatically selected!! This looks plain wrong to me since no filtering is different then filtering on 1 value, since there are also empty fields. It does seem to make setting up the filters somewhat confusing. Basically, deselecting All and then selecting all specific values (but not empty) acts the same as selecting All (which includes empty). With more than one value, plus some empty cells, in the column: - e.g. some cells with aaa, some with bbb, some empty. - Filter on aaa shows only rows containing aaa (not bbb or empty) - Filter on bbb shows only rows containing bbb (not aaa or empty) - Filter on Empty shows only rows with empty cell (not aaa or bbb) - Filter on All shows all rows (aaa, bbb and empty) - Attempting to filter for aaa or bbb automatically selects All, and includes the empty cells. With only one value, plus some empty cells, in the column: - e.g. some cells with aaa, some empty. - Filter on Empty shows only rows with empty cell (not aaa) - Filter on All shows all rows (aaa and empty) - Attempting to filter for aaa automatically selects All, and includes the empty cells. I've checked this using LO 4.0.4, which is admittedly quite an old version, on Windows. OK, the workaround is selecting on 'not empty' Now the tick on 'aaa' is cleared, which seems wrong too! This does seem to work as a workaround. I think the tick boxes are intended as a quick was to set up basic filters, and don't accurately reflect more complex filters. Although they don't look right after selecting Not Empty, clicking Standard Filter... does show that the filter is currently set to show Not Empty values. Now I clear the values Now the tick is set at ALL, and I can't clear the filter anymore... (the button is blue) Select Standard Filter..., set the Field name to - none - and click OK. Workaround: enter a bogus value in the column Select all (the select mark goes off) Now delete the value Working on Mac OSX 10.7.5, LO 4.2.4.2 (build 63150712c6d317d27ce2db16eb94c2f3d7b699f8) Am I missing something here? I couldn't see any open bugs with a quick search. I'd suggest upgrading to the latest version in the 4.2 branch (i.e. 4.2.5) and see if the problem still occurs. If it does, search again for any existing bugs and, assuming none are found, report either using the bug submission assistant at https://www.libreoffice.org/get-help/bug/ or the full bug tracker at https://bugs.libreoffice.org/. Mark. -- 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] [Linux Bug 80661 Filed] Re: LO Draw crashes importing Microsoft Publisher file (ping Brennan/Fridrich/Valek?)
Tom Davies wrote: Hi :) Draw didn't import my .pub files perfectly but it was close enough and the misses are areas that also cause problem in MS Office. It looked like i only got 1 page out of the 2 but i didn't poke around much so that is probably user-error and i'll probabl stumble on the answer when i poke around some more. Do you have the Pages pane at the left side? If not, try View Page Pane. I'd guess that's where additional pages from the Publisher file would appear, just as for multi-page .odg files. If there's only one page there, perhaps the import filter is limited to only importing the first page. Plus my .pubs didn't crash my 4.2.4 on Ubuntu 14.04 but i'm not sure if it's the Ubuntu-ised version, from a repo or directly downloaded pure LO :( Sorry! Completely lost track here! Does Help About LibreOffice give any clue? On my Windows version, it says near the bottom This release was supplied by The Document Foundation. I don't know if the Ubuntu repository version would say something different there. Mark. -- 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: ni podprto na drugih računalnikih/Not supported on other computers
For replies in Slovenian, try the mailing lists at: https://sl.libreoffice.org/po-pomoc/ To translate from English to Slovenian: https://translate.google.com/#en/sl/ Google Translate makes a bit more sense when spaces are put in after the full-stops in the original (Slovenian, according to Google): I have loaded your program libre office and I have to say that I am with him in general very pleased. But in oporabi [uporabi? use] this program but a problem arises when I want to send over the program libre office writer a dadoteko [datoteko? file] via Gmail respectively. should any other options that the addressee is not write-enabled and not can not open. Is this a problem that how to solve the answer you in advance thank. From that translation, it is not clear whether the problem is with sending or receiving. To send emails, LibreOffice needs an email program installed on your computer. File Send Document as Email... might not work with GMail if you only use GMail from their web page. Save the file to your computer, then start a new email in GMail and attach the file to the email. If the recipient uses a program which cannot open OpenDocument format (.od*) files (such as older versions of Microsoft Office), the best solution is for them to install LibreOffice (it is free). If they are not able to do that, you can save the file from LibreOffice in a Microsoft format and send that to them: - From the File menu, select Save As - Next to Save as type, choose Microsoft 97/2000/XP/2003 Do not use the Microsoft 2007/2010 XML formats; they are less reliable, and if the recipient cannot open ODF files they might not be able to open Microsoft 2007/2010 files either. Some details can be lost when converting to Microsoft formats, so it is best to keep your main copy of the file in LibreOffice's default format (ODF). Save a copy in Microsoft format only when you need to send it to someone who cannot use ODF. If the recipient can open the file but not modify it, that is probably because of how they open it. When choosing the option to open an attachment, most programs download it to a temporary folder and mark it as read-only, since changes to that copy would not be saved (you cannot modify the copy attached to the email). To modify it, the recipient needs to save the attachment to their computer and open it from there. Mark. anne-ology wrote: When I translate your message from whatever to English (using a computer program only), I don't understand your question; maybe someone who knows whatever language your using will respond. Have you checked to see if there is a list in a language you speak? From: andraž oblak oblakandra...@gmail.com To: users@global.libreoffice.org Cc: Date: Sat, 28 Jun 2014 11:46:32 +0200 Subject: [libreoffice-users] ni podprto na drugih računalnikih Podravljeni! Imam naložen vaš program libre office in moram reči da sem z njim nasplošno zelo zadovoljen.Ampak pri oporabi tega programa se pa pojavi neka težava ko želim poslati preko programa libre office writer neko dadoteko preko gmaila oz. bilo katere koli druge možnosti naslovniku napiše da ni podprto in ne more odpreti.Ali se to težavo da kako rešiti za odgovor se vam v naprej najlepše zahvaljujem. L.P. -- translation: (via computer) I have loaded your program libre office and I have to say that I am with him in general very zadovoljen.Ampak oporabi in this program, but a problem arises when I want to send through the program libre office writer a dadoteko via Gmail or . were any other options to write the addressee is not supported and can not odpreti.Ali this problem that how to solve the answer you in advance thank. -- 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] Can't see files on newwork share [Was: Loading each document about 3 minutes]
Steve Edmonds wrote: On 2014-06-21 10:19, Cigydd wrote: Alternatively, I just remembered Steve Edmonds pointed out in another recent thread that there's an option under Tools Options Load/Save General Load printer settings with the document. Turning that off (together with setting the default printer to one which is always available, such as PDFCreator) might help you, in a much more convenient way! Mark. Thumbs up for this one! Turning that setting off cut the delay back to 1min for some files and for others it removed the delay completely. ... And setting also PDF Creator as the default printer removed the delays completely for all my files! Worked like a charm. Thank you guys again for all your help. LibreOffice is working for me again. It has a living, helping and clever community. You did it. We did it. Yippee ;-) Pavel a. k. a. Cigydd Hi. Was a bug ever filed for this. I'm not sure that it is a bug. LO is trying to contact the printer specified by the user. The printer is not responding, so it takes some time before giving up. Changing the settings so that LO doesn't try contacting that printer fixes the problem. I have had similar problems so filed a bug https://www.libreoffice.org/bugzilla/show_bug.cgi?id=80697 but it may be related. That looks like it's to do with files not showing up on shared folders - nothing to do with printers? I just updated from LO 3.6 to 4.1.6 on OSX 10.68. 3.6 was working fine. If I go to open a file from LO and navigate to a network share no files show in the share. If I cancel LO hangs and has to be killed. I can see the files in OSX finder (file explorer). I can open a file from finder (open with LO). Once I have at least one file opened from the network share (via finder) I can then see files on the share from within LO file open dialogue. I don't know much about OSX, but it seems like the network drive isn't being mounted when opening from LO, but it works if already mounted (e.g. by browsing to the folder from the OS's file browser). Does Tools Options LibreOffice General Open/Save dialogue boxes de-select Use LibreOffice dialogue boxes help at all? (If that option is available on OSX). If it does, that would be worth mentioning on the bug report. Save as works ok Just found if I disable load printer settings with file all is ok. Steve -- 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] Calc: optimal column width
Thomas wrote: Good morning I have tried this a million times, but it works (worked) only rarely: there are columns that need to be adjusted in width, preferrably to make the longest entry fit. However: * select colum * right-click - select optimal column width * try with Default on or off - NO response. I can TRY to manually add any value I choose, but THAT is always a trial and error approach and as such not very elegant. Is there a way to convince Calc to set one or more colums to such optimal width? That should work. Are you definitely selecting the column which contains the long entries? If the text in a column doesn't fit, it spills over columns to the right (assuming default or left alignment is used) until it hits another cell with a value entered. You need to adjust the column which actually contains the text, not furthest right one which the text may have spilled over into. For example: | A | B | C | 1|abcdefghij| 123| Here the text in A1 has spilled over into B1, and would continue further into C1 if there wasn't another value in that cell. Adjusting column B for optimal width has no effect, as there is nothing actually entered in column B; it is column A which needs to be adjusted: | A | B | C | 1|abcdefghijklm | | 123| The Add value in the Optimal Column Width dialog is how much extra padding is added, beyond what's needed for the longest value. The Default option selects the default value for Add. Mark. -- 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] Libre Office 3.6.2.2 - downloads
charles meyer wrote: Hi Folks, I receive the digest of messages in the middle of the night so could you could please e-mail me privately as well as the list? I need to download the older version 3.6.2.2. Google revealed it was located here... http://downloadarchive.documentfoundation.org/libreoffice/old/3.6.6.2/ Is that the safest place to download it from? Yes; The Document Foundation is the organisation behind LibreOffice, and that's the archive of old versions. Best to check if unsure though ;o) Once there do I download every file under every folder except for mac and portable to run it on an XP Pro PC: You only need to download the version for your system, which is probably: win/x86/LibO_3.6.6.2_Win_x86_install_multi.msi and optionally the helppack in whatever language you prefer: win/x86/LibO_3.6.6.2_Win_x86_helppack_.msi Index of /libreoffice/old/3.6.6.2 NameLast modified SizeMetadata Parent Directory- box/20-Apr-2013 11:14 - deb/07-Apr-2013 14:12 - mac/05-Apr-2013 09:48 - portable/ 05-Apr-2013 12:43 - rpm/07-Apr-2013 14:16 - src/05-Apr-2013 09:56 - win/05-Apr-2013 09:49 - Apache Server at downloadarchive.documentfoundation.org Port 80 MirrorBrain powered by Apache For Windows, you only need to look under the win/ folder; the others are for other types of systems: box/ - (I'm not sure what this one is - looks like DVD images) deb/ - Debian Linux mac/ - Apple Mac portable/ - Portable version which can run from a USB stick etc. without being installed (empty in this case...) rpm/ - RMP-based Linux (RedHat etc.) src/ - Source code win/ - Windows And under each of those are downloads for various CPU architectures (32-bit, 64-bit, PPC, etc.), and languages. Thanks so much. Charles. Mark. -- 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] Re: Loading each document about 3 minutes
Cigydd wrote: Other news. Displaying the print dialog delays 1min 20s or 1min 40s when the disconnected printer is set as default in the system and regardless of what document is loaded. When PDF Creator is set as the default, the print dialog displays without delay. But opening the bad ODS files still lasts about 1min 5s. Even with Avast installed. It's however better than the initial state of loading each document about 3 minutes. Maybe Avast needed to be reinstalled... So does somebody have an idea what's causing the remaining delay by loading the ODS spreadsheets? One of the files contains about 30 sheets, each of them 1-3 pages long. But it can't be the cause because the other file contains only 1 sheet with 4 rows. I think the last-used printer settings are saved within the file. For new files, or where the printer saved in the file isn't installed, I expect LO would use the default (PDF Creator in your case). If the last-used printer saved in the file is installed, but not currently reachable (from other posts, it looks like you're using networked printers?), there may be a delay while attempting to connect to that printer. I've seen this kind of delay with other software, not just LO, when an installed printer isn't available. Depending how much you're going to be re-opening the file in between printing, it might be worth making sure it's saved with an always-available printer (e.g. PDF Creator) as the last-used printer: - Open the file (may have to put up with the delay this once...) - File Print - Select PDFCreator - Click OK - Cancel in PDFCreator (unless you want a PDF copy right now) - Type a character and delete it again (so that the file is modified) - Save the file Next time you open the file or go to print it, the printer will be set to PDFCreator so avoids the delay. Of course, if you switch the printer on and print to it, the last-used printer will be set to that, so you might get the delay again next time if the printer is switched off - unless you either close the file without saving or do another dummy print to PDFCreator after printing it. Mark. -- 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] Re: Loading each document about 3 minutes
Mark Bourne wrote: I think the last-used printer settings are saved within the file. For new files, or where the printer saved in the file isn't installed, I expect LO would use the default (PDF Creator in your case). If the last-used printer saved in the file is installed, but not currently reachable (from other posts, it looks like you're using networked printers?), there may be a delay while attempting to connect to that printer. I've seen this kind of delay with other software, not just LO, when an installed printer isn't available. Depending how much you're going to be re-opening the file in between printing, it might be worth making sure it's saved with an always-available printer (e.g. PDF Creator) as the last-used printer: ... Alternatively, I just remembered Steve Edmonds pointed out in another recent thread that there's an option under Tools Options Load/Save General Load printer settings with the document. Turning that off (together with setting the default printer to one which is always available, such as PDFCreator) might help you, in a much more convenient way! Mark. -- 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] Default printer issues in Writer
musik7 wrote: I have an issue with one of my end users where Writer is not defaulting to the printer which is set as default in Windows. I have tried a number of things including reinstalling LibreOffice and reinstalling the printer. Initially, reinstalling the printer resolved the issue for about a day, but then the issue showed up again, and reinstalling the printer didn’t fix it a second time. If anyone has any other suggestions for possible solutions, I would be grateful. A couple of thoughts... Some printer information seems to be saved in the document. I find that if the document is saved after printing, and the same printer is still available next time you print it, that one is selected by default. If the printer has been removed, or the document is opened on a different system where that printer doesn't exist, it probably selects the system default. Some applications remember the last printer you used, and select it by default regardless of the system default. I think Firefox does that. Don't know if LibreOffice does. Mark. -- 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] table not appearing in .doc format in MAC
Bala subramanian wrote: Friends, I am using the Libre office 4.2.4 version on a linux machine with Unbuntu 12.10. I have .odt file where i copied a table from libreoffice Calc. Then i saved the file in .doc file. Opening the .doc file in macbook does not show the tables. Is there any way to resolve this issue. If you've simply copied from Calc and pasted in Writer, you've probably ended up with a Calc object embedded in a Writer document. If (in Writer) you double-click on the pasted table, do you get the row and column headings around it, and sheet tabs below? If so, that's a Calc object opening within the Writer document. When you save that in .doc format, you probably end up with a Calc object embedded in a Word document - which would need something on the macbook capable of opening, displaying and editing that Calc object. A couple of potential solutions: 1. Copy from Calc as usual, but in Writer try the options given by Edit Paste Special. Formatted text or HTML paste as a Writer table rather than an embedded spreadsheet, and may be sufficient. 2. If you actually need a spreadsheet object embedded in the text document (rather than just inserting a table), look under Tools Options Load/Save Microsoft Office. Tick the [S]ave box next to Excel to LibreOffice Calc or reverse before saving as .doc. I think that makes it convert the embedded Calc object to an Excel object when saving the text document in Microsoft (.doc) format. I don't tend to embed spreadsheets in text documents and transfer to Microsoft formats, so not entirely certain that'll work, but it's worth a try. If it doesn't you can always change the settings back to what they were. If it does work, and you do this kind of thing a lot, you might want to tick all those boxes ([L]oad and [S]ave for all object types). I'd suggest keeping the original in ODF format though, and just saving a copy as .doc when you need to share it, just in case something goes wrong with the conversion. Hope that helps. Mark. -- 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] soffice --help dialog display issues [Was: Using LibreOffice on the command line to batch convert .htm files to .html files]
Paul wrote: On Thu, 10 Apr 2014 19:06:51 -0500 Joe B paperba...@gmail.com wrote: This bug desperately needs to be fixed. Yes, I agree. Should someone open a bug report, or is there one already? Anybody know more about this? I haven't actually gotten as far as registering an account for the bugtrack system before... Looks like it was filed just over a week ago against LO 4.2.1.1 on Windows, and someone else sees it with LO 4.2.2.1: https://bugs.freedesktop.org/show_bug.cgi?id=76932 For what it's worth, with LO 4.0.4 on Windows, I find: - The line about --minimized is not rendered correctly (only the lower half of the text is visible; other lines above and below are fine) - The last visible line is the description of --infilter - Long lines are cut off at the right side (descriptions of --web and --infilter) - There is no Close button within the dialog, but there is an OK button which is clear of other text and works - Still no way to see the complete text though! Mark. -- 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] Non-PDF Portable Document Formats (Exporting from LO)
Hal Vaughan wrote: I’m working on an e-reader for special purposes. While I don’t want to go into a discussion of the point of this program and why I’m doing another, a brief summary may help. As a writer, I don’t like sending my work over email or other insecure methods of internet transfer. This e-reader would let me (and my writer friends) share our work easily with our friends while keeping it encrypted during transfer and even on the reader’s computer. The file is read in and decrypted when displayed for reading. This would also let me make early drafts expire so they can be ditched when they’re obsolete. I still haven’t decided what language to use for this. Initially it’ll work on OSX, Windows, and Linux. I’d like to expand it to Android and iOS. There’s a good chance it’d be in C++ or Java, but it would be great if I could do it in Python. (I know of Kivy and other efforts that would make it easy for me to transport Python to at least Android.) The problem is I need some kind of portable document format. I know that implies, immediately, PDF. However, there seems to be only one library that handles PDF display, and that’s Poppler. I’m not an expert programmer (at least not in C++), and when I’ve asked for help from the Poppler people, they’ve been abrupt and less than helpful. I’d like to be able to write in LO, then save or export my file, and have it in a format I can easily display on the different operating systems. I tried saving some files in HTML. The plain text ones were no problem at all. Margins and formatting was preserved just as I needed it. But then I tried one that was part of a pitch, so it had a page of text, then a page of pictures, basically two columns of pictures with captions below each picture. I loaded that in a browser and the formatting was okay on the first page, but was totally messed up on the 2nd page with the pictures. I don't know much about e-reader formats, but Calibre (http://calibre-ebook.com/) can convert various file types (including ODT) into various formats used on e-readers (EPUB, MOBI, AZW3, ...) So far I've only used it to convert a few files to view on my Kindle, so not sure about support for adding encryption / DRM, but it might be worth a look as a starting point to modify or just for ideas. Mark. As best I can tell, at this point, there is not a portable library out there that I can use from within a program to easily display ODT files, but that would be a great solution. So what format can I use when exporting from LibreOffice, other than PDF, that can be easily displayed by any libraries in either Java, C++, or Python? Thanks! Hal -- 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] Font in Default Character Style
Virgil Arrington wrote: Another off the wall question. How does one change the font in the Default Style in character styles? Right now, the font in my default character styles is Century 731BT. This is a font I used years ago, but haven't for quite some time. It does not correspond to the Basic Fonts set in Options, nor does it correspond to the font set in my default paragraph style. That's odd... for me, using the default character style picks up the font from the current paragraph style - so changing the paragraph style should work. Perhaps you have a default template where the paragraph style is initially set to something else, or the font is set by direct formatting? So try ensuring the current paragraph style is set to Default Style, and do Format Clear Direct Formatting. Once you've fixed it, you can save the template (File Save as Template) and set it as default (File New Templates, select the template, and click Set as default). If you can't fix the default template, or if it's easier to start again from scratch, you should be able to reset it by going to File New Templates (cog icon) Reset Default Template Text Document. If I right click on Default Style in character styles, my only option is New. Is the default character style font hard-coded somewhere? I've not been able to find any way to change it. I'm using LO 4.1.5 on Windows 7. Virgil -- 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] Master Documents, Office Suites, and the Underwood
Virgil Arrington wrote: On 3/25/2014 5:34 PM, Dale Erwin wrote: How would you define a paragraph style to handle a dictionary entry such as this: *canuscere*/v.t./ to know, to be familiar with. I see my formatting was lost on that example. The headword canuscere would be in 11 pt. boldface, while the rest of the line would be in 9 pt. normal, except that the v.t. would be italicized. You've got two things going on here, as I see it. The *paragraph* style would determine the primary font and style of the paragraph (9 pt. normal) along with paragraph indents and any extra space above or below the paragraph. The boldface canuscere and italicized /v.t./ would not be controlled by the paragraph style. They could either be controlled through direct character formatting, or with a character style, (defined as either 11-point boldface or 9-point italics). Then, you would apply the paragraph style to the whole paragraph and then the character style to the individual words to which they would apply. Quite honestly, I rarely use character styles, but in this case where you're changing two characteristics (9 points to 11 and normal weight to boldface), the character style would help ensure consistency throughout the document. With the italicized /v.t./ I don't see any advantage to using a characters style as you're only changing one feature (normal to italics). Just highlight the text and hit ctrl-i and you're done. Until, for example, you later decide word types should be blue as well as italic... If you've just hit ctrl+i all the way through to make them italic, you'd have to find all occurrences and change them all again. If you've defined and used a character style, you'd just change the style once and all the word types would turn blue. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2
Alternatively, to save copying data into a common .ods file, you can keep one .odb file (e.g. mergesource.odb) but change which .ods file it points to. Open mergesource.odb, then Edit Database Properties, and change the path to spreadsheet document. Saves a bit of copying data around, but I can see that might not be so easy as an instruction if there are non-technical users of your merge document. Whatever works for you and your users is best ;o) Mark. Steve Edmonds wrote: And thanks to the discussion I think I have a much better understanding and can iron out the problems our users are having with the merge. We keep getting new lists to merge, all the same format. The secret to simplification is, once set up, to have an ods named mergesource.ods or something and then copy the new data in each time or save the new data as mergesource.ods. Then a new .odb file is not created each merge, and it is not necessary to exchange the database or re-link the fields. Steve -- 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] Clarification about ODF Extended
e-letter wrote: On 17/03/2014, Italo Vignoli italo.vign...@gmail.com wrote: Nothing happens when XML tags are ignored, to systems which are not supporting the ODF 1.2 Extended document format. This is the reason why we can suggest to use ODF 1.2 Extended as the preferred format, because backward compatibility is maintained. Thanks to the odf implementor notes web page, how can this claim be true when these LO features break odf validation? I haven't seen anything to say that the extensions prevent validation of ODF documents. The implementer notes you refer to say, under Extension namespaces, Elements and attributes that are not defined in an ODF specification yet... have to be written with an extension namespace, otherwise validators will complain about invalid elements or attributes. This suggests that the standard and validators allow for extensions to the format. Presumably extensions to the format would be ignored by applications not supporting that extension, but the rest of the document show as intended. e.g. with the extension for font embedding, applications supporting the extension would use the embedded fonts, while others would ignore the embedded fonts and use those on the system (as if the fonts were not embedded at all). Somewhere in the wiki there is a list of the extended features, but please remember that we are speaking of a document format and not of software features. So, most of the new LibreOffice features do not impact the document format. If LO feature (most likely designed to provide some sort of compatibility with m$) prevent odf validation, the document format must be impacted. Or is this a false conclusion? -- 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] Re: Turning spreadsheet data into legible report?
How about using a single sheet for the data, and add an extra column for year? Something like: Year Last NameFirst Name... 2012-2013Doe John ... 2013-2014Doe Jane ... Then mail merge on that. I don't know about Word, but in LO Writer you can set filters during the mail merge, e.g. if you only want reports for records where Year is 2013-2014. Where you select the data source in the mail merge wizard, click Select Different Address List, select the database, and click Filter... to set conditions. Sorting on the Year column would group all the entries for each year together in the spreadsheet. Mark. Giles wrote: Sorry about that. The spreadsheet 1) has too many columns to fit on a document, even in Landscape mode (she wants Portrait), and 2) data are spread on multiple sheets, one by year. She needs to print the data thusly: = Last Name: Doe First Name : Jane Date of Birth: 12/12/2000 Year 2012-2013 Trimester 1 Col1 | Col2 | Col3 Trimester 2 Col1 | Col2 | Col3 ... Year 2013-2014 Trimester 1 Col1 | Col2 | Col3 Trimester 2 Col1 | Col2 | Col3 = So she needs some way to turn the spreadsheet into the above *while keeping data in different tabs* (one per year) since the list of students is different every year. Ideally, it should be doable with a spreadhseet (Excel or Calc) and some programming-free tool, but Word can't handle more than one tab in a spreadsheet. Like I said, she can't work with a database. Incidently, this problem is very common since a lot of users rely on Excel as poorman's database. I wonder how they all manage once they hit this type of issue. Thank you. -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102153.html Sent from the Users mailing list archive at Nabble.com. -- 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: Field names not being retained
A wrote: Interestingly, the field names seem to have changed seemingly for the better. Whereas before it was inserting things something like filename.databasename.sheetname.fieldname, now I get fieldname. Unfortunately, after running the mailmerge, it seems to have made the values in the first record (I only have one record currently) a permanent part of the fields. For example in the fieldname street name, it has Elm St, where it should instead simply have street name making my .odt file useless as a mail merge document, so I'll have to go through it for the fifth time and change all the fields yet again. Are you sure they're not still fields? I think after the mailmerge runs, the fields end up showing data from one of the entries rather than the field name, but if you re-run mailmerge they do still work as fields. You can see the field codes rather than the final data by setting Tools Options LibreOffice Writer View Field Codes. This then shows the full databasename.tablename.fieldname code, which from your previous comment may not be completely ideal, but at least you can check that they are still fields and not static text. Also, fields are shown with a grey background, although I'm not sure if that's another option I've set some time in the past. Mark. -- 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 CONFIRMATION about images linked to a http location
Fernand Vanrie wrote: With 4.2.2.1 windows Pictures in Writer and Html documents linked to a http location no longer opens and can no longer been inserted what makes the use of images in a HTML doc imposible A picture linked to http://pmg.pmgroup.be/enews/idb/grafiek9.jpg; can been opened and viewed in a writer and Html doc until 4.0 but no longer since 4.2 you can use the link to test is it a bug or wanted behaviour ? Could this be related to this discussion: http://listarchives.libreoffice.org/global/users/msg36731.html and bug 60415: https://bugs.freedesktop.org/show_bug.cgi?id=60415 ? If so, a workaround may be to use Paste Special and select Bitmap format. This would break the link to the original URL, and embed a copy of the image in the document. Whether or not that's acceptable to you obviously depends on what you're aiming to do. Doesn't seem to affect all images, but the exact set of conditions for an image to cause a problem isn't clear... Mark. -- 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] Re: Impress won't save changes in master slide
HdV wrote: On 2014-03-06 09:41:11 you wrote: Hi all, When trying to fix the problem with the disappearing footers (see previous message) I noticed something strange. I edited the slide master (resized the auto-layout areas for the title and outline) and saved the file. When re-opening that file both areas are back to their old sizes and auto-fit modes again. It seems the changes were not saved. Has anyone noticed this behavior before? Did you find a workaround? I tried to find out if this was a known bug, but did not find it in the buglist. If it is new, then I'll report it. Grx HdV Ah, I found a bug report matching this problem. Seems this is known for years, but it hasn't been fixed (yet). Too bad. (#641175) That number doesn't seem to exist in LibreOffice's bug tracker: https://bugs.freedesktop.org/show_bug.cgi?id=641175 But it does appear in the Ubuntu Linux bug tracker and looks related: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/641175 The equivalent in LibreOffice bug tracker appears to be #34987: https://bugs.freedesktop.org/show_bug.cgi?id=34987 Although marked as having been fixed in version 3.3.1, it does look like it recurred, but is fixed again in newer versions - maybe 4.0.6 in the 4.0 series and 4.1.3 in the 4.1 series (not certain I've interpreted the comments correctly). So may be worth updating to 4.0.6 or 4.1.3 if you're not already using one of those versions. What If I would be willing to sponsor resolving this bug? What would be the best way to find a developer that could fix this? We use LO a lot in my company, so I wouldn't mind to invest in something that would help ourselves and all other users of LO. If anyone knows someone who would be able and willing to fix this bug, then please let him/her contact me. Grx HdV -- 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] Weird situation with LO Writer
Coincidentally, I was looking for something else at the weekend, and came across some notes from about 5 years ago when I got a 30MB presentation down to 6MB by doing that. Had completely forgotten about it. That was with quite an old version of OpenOffice, and I may not have inserted the files properly in the first place (not sure if I was aware of the difference between copy/pasting and insert from file myself back then!) Was going to suggest it as a workaround in case it was worth the effort to you, but looks like you've already found the same trick ;o) It would be interesting to know what triggers the different behaviour. That some are kept as JPEG while others are converted to PNG is even more strange than if they were all converted to PNG when set as a frame's background... Ra wrote: Hello, True, I don't insert the images as pictures like you would expect, but I didn't think that would make a difference since all the images are still coming from a local disk, so therefore LO knows the format very well and should be able to preserve it. Why am I using frames with images as backgrounds instead of pictures? I don't know really. I needed an image to accompany a chunk of text, this seemed like a good idea at the time. It's kinda too late to change it now, there are already over a hundred such frames... I might try to change it at some later point but for now I'd like to stick with what I have. I did not try inserting images any other way so I don't know how it would behave. (I also don't understand what do you mean by extending the palette.) I did however do a little experiment. Since ODTs are just ZIP archives, I opened my document with an archiver tool and extracted the contents to a temporary directory. Then I converted all the PNGs to JPGs with the same name, updated the relevant index files accordingly (content.xml, META-INF/manifest.xml), and archived it back as ZIP. Then I renamed the ZIP to ODT and tried opening it in Writer, and voila, it worked! All the images are still there and visible, I didn't see any problems. I then saved it under a different name and checked the resulting ODT, all the stored images were still in JPEG format. So I guess this kinda solves my problem for now, although I would still like to know how and why it happened to begin with. I need to do more editing on the document which means a lot more saving, so I'll keep an eye on what LO does with these JPEGs in the future. On Sun, Mar 2, 2014 at 10:55 PM, Regina Henschel rb.hensc...@t-online.dewrote: Hi Ra, Ra schrieb: I never insert images as pictures. The JPEG images are only ever used as backgrounds for frames. I also never open the JPEGs in any picture editing application and copypaste from there, the images are only ever used as files from disk. What I'm doing is precisely this: File Insert Frame... OK Then [right click on the frame created] Frame... Background As: Graphic Browse... [select the JPEG file from disk] Type: Area OK I think, that is the point. You do not insert the image directly, but use it as background image. If you insert the image directly, it should stay in JPEG format. Have you tried, whether other ways to make it a background (e.g. extending the palette) results in png too? Why do you try to make it a background of the frame? Kind regards Regina -- 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 -- 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] Chart legends
Heinrich Stoellinger wrote: Hello, I inserted a chart from a Calc table in LO 4.2.1, running Linux-Mint-16. Now I find that I cannot change the text displayed within the legend. It simply displays Row 1, Row 2, Row 3...). As far as I can see, one can only change the position of the legend. How do I define an arbitrary legend. 1. Double-click the chart to start editing it, if not already in that mode. 2. From the menu: Format Data Ranges... 3. Open the Data Series tab. 4. In the Data Series (left-hand) list, click the series for which you want to set the name. 5. In the Data ranges (right-hand) list, click Name 6. In the Range for Name (below that list), type the name you want to appear for the selected series, enclosed in double-quotes. 7. Repeat steps 4-6 for each series. 8. Click OK. Is there maybe a way to somehow connect the various data rows of a chart with (e.g.) a row/column in the Calc table on which the chart is based? Yes. At step 6 above instead of typing the literal text (in quotes), enter a cell reference (without quotes). This needs to include the sheet name as well, e.g.: $Sheet1.$A$3 You can also click the icon to the right of the Range for Name box (it looks like a window with an up-pointing arrow), then click the cell in the spreadsheet, and Calc will automatically fill in the reference for you. From the same dialog, you can also change the cells used for the series data (by selecting y-Values from the Data ranges list) and add new series to an existing chart. Useful if you add more data to the sheet beyond the range the chart was set up to use. Regards H. Stoellinger I hope that helps. Mark. -- 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] Weird situation with LO Writer
Sure, but how did you then get those images into LibreOffice? If you use Insert Picture From file, LO knows that the file is a JPEG and probably even copies the file as-is into the ODF file. If you open the JPEG file in another application (such as an image editor), then copy from there and paste into LO, in this case LO will only have the bitmap data copied from the image editor. It will not know about the original image file nor what type it was, and probably uses its default format, i.e. PNG, to save that image data within the ODF file. My suspicion is that, although you saved all the source images as JPEGs, those which appear as JPEG in the ODF file were inserted by Insert Picture From file, while those which appear as PNG in the ODF file were opened in another application and copied and pasted into LO Writer. Mark. Ra wrote: Good guess but sadly no. All the images are first stored as JPEGs. That's how I know they in fact *are* JPEGs. ;-) Ra wrote: Hello, I have noticed some unexpected (and possibly inconsistent) behavior of documents producet with LO Writer. Here's my scenario: I have several frames in the document and each of them has a JPEG photo as the background. Each frame has a different image as a background. There are no other graphics in the document, just some text. The resulting document ends up being considerably larger than the sum of all the images and all the text content put together. Knowing that ODFs are really just ZIP archives, I decided to dig a little deeper. Having opened an ODF file with an archiver I noticed most (but not all, surprisingly!) of my JPEGs got converted to PNGs before getting stored. I don't know much about this but up until now I believed LO stores all external images as direct file copies, or at the very least in the original format, so this striked me as odd. Just a guess, but if you copy and paste an image from another file, LO won't know what format it was in originally (all it has is bitmap data pasted from the clipboard), so will probably use PNG since it is a lossless format. Maybe those in JPEG format were inserted by Insert Picture From file (or similar), while those in PNG format were opened in another application, copied from there, and then pasted into LO? I've been told the ODF specification recommends using PNGs for bitmaps and SVG for vector graphics. This makes sense generally but is also quite inefficient for photos as PNG photos tend to be much larger than JPEGs. It is also weird that only some of my images got converted. Anybody know and can explain the logic behind this? My document currently contains about 100 such images, the JPEGs are all together about ~15MB in size, the rest of the document is mostly plain text with some formatting, and yet my document ends up at about ~47MB. I would like to optimize and reduce this if possible. In case it matters, the document was produced over several weeks in LO 4.x or newer on Windows (XP/x86 and 7/x64) and Linux (x86). Thank you. -- 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 -- 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] Weird situation with LO Writer
Ra wrote: Hello, I have noticed some unexpected (and possibly inconsistent) behavior of documents producet with LO Writer. Here's my scenario: I have several frames in the document and each of them has a JPEG photo as the background. Each frame has a different image as a background. There are no other graphics in the document, just some text. The resulting document ends up being considerably larger than the sum of all the images and all the text content put together. Knowing that ODFs are really just ZIP archives, I decided to dig a little deeper. Having opened an ODF file with an archiver I noticed most (but not all, surprisingly!) of my JPEGs got converted to PNGs before getting stored. I don't know much about this but up until now I believed LO stores all external images as direct file copies, or at the very least in the original format, so this striked me as odd. Just a guess, but if you copy and paste an image from another file, LO won't know what format it was in originally (all it has is bitmap data pasted from the clipboard), so will probably use PNG since it is a lossless format. Maybe those in JPEG format were inserted by Insert Picture From file (or similar), while those in PNG format were opened in another application, copied from there, and then pasted into LO? I've been told the ODF specification recommends using PNGs for bitmaps and SVG for vector graphics. This makes sense generally but is also quite inefficient for photos as PNG photos tend to be much larger than JPEGs. It is also weird that only some of my images got converted. Anybody know and can explain the logic behind this? My document currently contains about 100 such images, the JPEGs are all together about ~15MB in size, the rest of the document is mostly plain text with some formatting, and yet my document ends up at about ~47MB. I would like to optimize and reduce this if possible. In case it matters, the document was produced over several weeks in LO 4.x or newer on Windows (XP/x86 and 7/x64) and Linux (x86). Thank you. -- 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] Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Tanstaafl wrote: On 2/27/2014 1:25 PM, Tim Deaton t...@timdeaton.org wrote: Some time ago I created bug 39936 asking asking for an enhancement that would work the way Excel does. Maybe some more encouragement on that issue might move it up in terms of priority. Did you miss my request for anyone who knows how Excel does this to please chime in? I still can't figure out how to do this in Excel. It's much the same in Excel, except it's Shift+drag rather than Alt+drag. I think you also have to drag from the few-pixels-wide border around the selection, rather than from anywhere within the selection as LO allows. Mark. -- 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] Re: Calc - how to move (drag-n-drop using mouse) or cut/insert rows/columns
Pedro wrote: Hi Brian Brian Barker wrote What happens if you: o Select the row or column. o Drag it to the new position. o Hold down the Alt key whilst you drop? Yes! That works! I'm glad there is an easy way to do it! Thanks!!! Unfortunately (for LO) it is not obvious even for advanced users... Which means that for the average user the conclusion is that LO can't do that... There are also the following alternatives: - Hold down Ctrl whilst dropping, to copy a column overwriting any content already in the column you're dropping onto - Hold down Ctrl and Alt whilst dropping, to copy to a new column inserted in between two existing columns Although not particularly obvious, all these options are documented in the help - from the index, look up moving cells by drag-and-drop. Holding Ctrl while dragging to copy is quite common in other applications too. Not so common, but I have seen holding Alt while dragging to move things in other applications where copying in the default (i.e. with no key held down) action. So now you know about them, it might be worth trying Ctrl+drag and Alt+drag in applications other than LibreOffice too ;o) Mark. -- 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] LO 4.2.1 Math/Formula Format/spacing issue
Regina Henschel wrote: Hi Clarence, Clarence W. Robison schrieb: On 2/26/2014 9:55 AM, Clarence W. Robison wrote: I am not sure that this is a bug or I do not know were to find the setting to adjust vertical spacing of scalable bars. If I have the following formulas defined: abs{ x - y } newline newline abs{ x-y} over {x + y} newline newline lline { x - y } rline over { x + y } newline newline left lline { x - y } right rline over { x + y } newline newline left lline {x_i - y^2} right rline over {x + y} The result is: The scalable bars (used by abs), are not placed correctly in vertical space, they are to low. Other scalable grouping symbols: brackets, braces, and parenthesizes appear to be correctly placed. Using out of the package default fonts on Windows 7 64bit. Any advice would be appreciated. Thanks Clarence The in-line figure was stripped. If the attachment is stripped see: http://www.kimberly.uidaho.edu/Transfer/LO_ScalableBarIssue.png Which version do you use. The bars are correct here in LO4.2.1.1. and in LO4.3(dev). Looks OK here too, in LO 4.0.4.2 and 4.2.0.4 on Windows Vista 32-bit - the abs bars sit just above the division line, not crossing it as in Clarence's screenshot. Mark. -- 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] read-only problem
edo1 wrote: I saved a small (14 page) styled part of a large project as read-only to protect against accidents while I did something else. How did you do this? e.g.: - saved the file, then from Windows Explorer set the read only attribute? - set File Properties Security Open file as read-only in LibreOffice before saving the file? - or something else? Later wanting to check a style, I unchecked read-only and reopened the file. As far as I'm aware, this should have worked - assuming you removed the same option as you originally set. But again, what exactly did you do? Yet it still opens as read-only and styles and formatting is grayed out. Does anyone know how this can happen and how I can prevent it? Usually, editing is disabled if the file is read-only when it's opened; if the read-only attribute is changed while the file is open, it does not affect the editing options available. But you say you reopened the file after unchecking the read-only option, so I wouldn't expect that to be a problem. About the 5th icon in on the toolbar is one which looks like a pencil and paper, and hovering over it shows a tooltip Edit File. You could try clicking that, and then see if you can edit the file. This just allows or prohibits editing the document on-screen; it doesn't change the read-only attribute on the file, so you still might not be able to save the file with the same name if that attribute is still set for some reason. The best I could do was copy the contents into a new file from which I could retrieve the styles. That work-around will be a great pain with the rest of the project. I'm running LO 4.2.0.4 in Win7 x64. Thanks for any help! - edo1 -- 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] help pack configuration for other language
Cristian Baboi wrote: Hi! I've installed LibreOffice with the english help pack because it is not available for my language. Is there a way to activate offline english help without changing the language of the interface? The interface is translated. Thanks. You could try finding the folder containing the help files (C:\Program Files\LibreOffice 4.0\help\ in my Windows Vista installation). That should contain a folder corresponding to the language of help you installed (probably en-US, but may be en-GB if you installed UK English help). Try copying that folder, and name the copy to match your language code (if you're not sure what that is, let us know what your interface language is and we might be able to figure it out). I don't really know how well this will actually work. Of course, where the help mentions which buttons to click or options to select, it will use the English names. Context-sensitive help may or may not work correctly. e.g. if you have the Format Character dialog open, pressing F1 usually takes you straight to help on that dialog, but that might not work if the languages don't match - or it might work just fine, the easiest way to know is to try it. If you ever uninstall the help pack, you'd need to delete the extra copy of the folder you created yourself. Mark. -- 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] All of the messages in Nabble are suddenly going into the AndrOpen Office thread!
null wrote: Hello, Well, if this appears as a separate subject (in the Users archive on Nabble), then the problem was fixed. It seems as if all of the posts (even different subjects and conversations) are going into the What do you think of AndrOpen Office? thread on Nabble. A conversation about LibreOffice Base and MySQL (with a different subject) went into the AndrOpen Office thread on Nabble. Is this able to be fixed? I don't know if it's the case here, but people do sometimes reply to an existing email to the list and just change the subject line (presumably to save looking up the address for the list). That isn't enough to make it a different thread - there are separate headers in the email which link messages into threads - so the new message shows up as part of the original thread. Another disadvantage of doing this is that some other people use mail clients or news readers which they can set to automatically ignore any further messages in threads they're not interested in or can't help with. So those people wouldn't see the messages asking about a different problem in an existing thread, when they might otherwise have been able to help with that new problem. So it can be in the asker's best interest to create a new thread rather than replying in an existing one. To do that, they need to create a completely new email and send it to the list address (users AT global.libreoffice.org in this case). Mark. -- 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] Importing HTML in LO 4.2
Uploading the document to the W3C validator (http://validator.w3.org/) it appears the DOCTYPE is not valid. It should be: -//W3C//DTD HTML 4.0 Transitional//EN (the file is missing //EN from the end). The original document doesn't fail with the version of LO I have, so cannot check, but try correcting the DOCTYPE. If that allows the file to open as expected, it appears the problem is with moneydance producing invalid output, rather than with LO. Arbitrarily changing the DOCTYPE to indicate HTML5 may well also fail, as the rest of the document is not valid HTML5. Mark. null wrote: Hello, It looks like the problem is with LibreOffice interpreting DOCTYPEs. You see, every HTML is supposed to have a DOCTYPE at the top of the file, explaining what version of HTML (HTML5, HTML4.01, etc) the file uses. The file you uploaded has a DOCTYPE of HTML4.01 Transitional. Anyway, if I remove the !DOCTYPE ... part of the HTML file, and reopen it in LibreOffice, it works just fine, and shows the file's contents (not the source). Even switching the DOCTYPE to !DOCTYPE html (HTML5) causes the problem. So, in theory, if you want to view an HTML file in LibreOffice 4.2, you have to remove its !DOCTYPE ..., and it will work fine. Would you like an official bug to be filed so that the developers know of the problem and can try to fix it? Regards, xmlhttprequest.o...@gmail.com On 2/5/2014 12:05 AM, Keith Bates wrote: I've produced a document that doesn't work with LO. It is at https://www.dropbox.com/s/mbylcso4r2qm2r2/test.html Strangely it does open in Abiword. Earlier documents produced by moneydance as recently as last month open fine in LO. I have not upgraded moneydance in that time. Having quickly opened about 20 html's the problem is limited to those produced lately by moneydance. I haven't had time to look closely at the html source. I suppose it's possible that LO is now being more strict in its interpretation. The work around in the short term might be to use Abiword. -- 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] Error or what?
Brian Barker wrote: At 06:56 04/02/2014 +0100, Erik Erlandsson wrote: Still, ticking Precision as shown does no difference at all to the result even after closing and reopening. That's odd, as it's not how it behaves for me and definitely not how it is supposed to work. It may depend a bit on precisely what format you have set for the cells. Just experimented with this a bit, and Precision as shown does not seem to have any effect when the cells are set to General format. However, with the cell format set to 0.0 (to display a fixed number of decimal places), the Precision as shown option _does_ seem to work as expected. So it seems more like Precision as set by display format rather than literally as shown... Mark. PS. Apologies for the direct copies; my mail to the list doesn't seem to be getting through lately, although I receive it fine. If this one gets through to the list, I'll stop copying individuals... -- 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] google images and librewriter crash
Rich Giorgio wrote: I was searching for images on Google images and when I right click on an image and paste it into librewriter, the cpu usage goes to 100% and I have to force quit librewriter. This happens on all versions of librewriter from 3.x to 4.2 on Ubuntu (10.04 to 13.1). I've also seen it on Windows, but have not tested it as thoroughly. This does not happen in librecalc, impress, or draw. The drawback in writer is you may lose all your work once you paste an image. If you paste special - bitmap it pastes the image. Can this crash be prevented or treated the same as the other libreoffice applications? Thank you! It looks like a bug is already filed: https://bugs.freedesktop.org/show_bug.cgi?id=60415 I've just signed up for an account on the bug tracker, so will add more info to that report when I can get in. In the meantime... I can confirm this in LibreOffice Writer 4.0.4.2, copying from Mozilla SeaMonkey 2.23, on Windows Vista. Copying static images from a couple of other websites was no problem, so it seems to be partly to do with the way Google Images search works. Copying from other websites into Writer, I first see a placeholder which is then replaced with the image. The time it takes to show the image increased with image size, so looks like LibreOffice gets a link to the image, then downloads it itself. However, the URL copied from Google isn't a link to an image on a web server (it begins data: rather than http:) - I guess the image data is obtained via JavaScript or JSON or something in the web browser, but that link won't then work for another application. Not good that it crashes LibreOffice Writer though! I'm not sure about Linux, but on Windows a copy operation can put data on the clipboard in several formats, and the paste operation can then use any one of those (usually a default, with paste special giving the user a choice). Copying an image from the web browser appears to place data on the clipboard in HTML and bitmap formats, where the HTML includes a link to the image as well as alt text etc. It looks like Writer uses the HTML by default and attempts to download the image data itself, while Draw and Impress use the image data from the clipboard. Presumably Writer does something useful with the other HTML attributes which Draw and Impress don't, but looks like it needs to handle data: links more gracefully. As you've found, a workaround is to use Paste Special Bitmap (this tells writer to use the bitmap data from the clipboard rather than the HTML) - but that doesn't exactly help when you automatically hit default Paste and Writer hangs! Mark. -- 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] Help with libre
Some mailing lists insist on inline replies (and deleting parts not relevant to the response), since it's easier to follow the flow of a conversation and which part of the original message the reply relates to. This LibreOffice list is rather more tolerant though ;o) Where there are already some replies, I tend to just follow the same format, since it's even more difficult to follow when different people are alternating between inline and top posting! In Mozilla SeaMonkey (similar to Thunderbird), I just press enter a few times at the appropriate point, then type a reply. If you're using GMail's web interface, I notice it hides the original text when you start a reply, but there's a button with 3 dots at the bottom left of the reply box you can click to expand it. Then insert lines and add replies as needed. Mark. Tom Davies wrote: Hi :) Ahh, nicely done Mark! :) I wasn't looking forwards to trying to address each separate issue. I can't seem to figure out how to intersperse replies like that and rarely ever want to anyway. It's excellent for things like this though :) -- 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] Formatting Errors in Calc
James E Lang wrote: LibreOffice Version: 4.1.3.2 Build ID: 410m0(Build:2) on Kubuntu 13.10 Background: I use KingSoft Office Spreadsheet for Android on my phone because regrettably LibreOffice Calc for Android is not usable. KingSoft uses and saves .xlsx files. From time to time I upload one of these files to my Linux computer to enhance the layout. I use LibreOffice as noted at the top of this post to perform the enhancements. Problem: Formulas that evaluate to text strings are being displayed as a formatted zero value. Examples: • A formula that evaluates to 14.01.16.xlsx according to the Function Wizard displays as December 30, 1899 instead using a date format code. The formula is supposed to display the file name without the path. Since CELL(filename) formats the information differently in Kingsoft Office vs LibreOffice the formula tests the structure of the returned string and extracts the file name accordingly. The LibreOffice part of the formula is: =MID(CELL(filename),FIND(C1,CELL(filename),1)+LEN(C1),FIND('#, CELL(filename),1)-( FIND(C1,CELL(filename),1)+LEN(C1 ))) • A formula that evaluates to according to the Function Wizard displays as $0.00 instead using a currency format code. The simple formula is: =IF(ISNUMBER(F20),IF(F20C20,C20,),) This is a new phenomenon. To answer the question, what has changed, the only changes I've made to LibreOffice since these cells displayed correctly to try the 2525 color pallet mentioned in another thread on this list. The changes were in directory: .config/libreoffice/4/user/config/ • I moved file standard.soc to standard.soc.std and replaced it with a copy of standard.soc--jan-19--10_26---2525-color-blocks.txt following which I restarted LibreOffice. • After seeing the problem I am reporting I restored file standard.soc from standard.soc.std and again restarted LibreOffice. The problem is still there. After each restart I took a look at the Background Colors pallet and saw what I expected so I know that each change took effect when tried. Does anyone know what I should do next to resolve my problem? Don't know if either of these will help, but a couple of ideas to try if you haven't already... 1. Compatibility problems with MS Office Open XML (.docx, .xlsx, etc.) files are often reported here. I don't have personal experience of such problems, but the advice usually given is to avoid OOXML files if possible. The format apparently changes slightly with each version of MS Office, and even newer versions of MS Office can display OOXML files from older versions incorrectly - so what hope does anyone else have! The ideal would be to use Open Document Spreadsheet (.ods) but I'm not sure if Kingsoft supports that. Otherwise, it looks like it can output MS Excel 2003 format (.xls - without the extra x), which is probably more reliable. 2. Check what formatting is applied to the cells when saving the spreadsheet from Kingsoft (before importing into LibreOffice). Maybe the cells are formatted as General, which Kingsoft may interpret differently from LibreOffice. Try setting the format to Text in Kingsoft before transferring the file. Mark. -- 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] Error 2908 and 1935 after installing .Net 4.5.1 and attempting to update Libreoffice to 4.0.4
Tanstaafl wrote: Subject says it. I uninstalled the old version (3.6.3 I think it was), then installed .Net 4.5.1, and when I tried to install Libreoffice 4.0.4, the installation failed, first got the error 2908, then the 1935. Hope there is an easy fix, because this is the Boss's computer. The troubleshooting section at the bottom of: https://www.libreoffice.org/get-help/installation/windows/ describes a solution for error 1935. Error 2908 may also be related to the same problem. Or may be an error in the registry. Looks like this tool from MS might help: http://support.microsoft.com/mats/Program_Install_and_Uninstall Other pages indicate adware/virus scanners can cause these kind of errors: http://support.microsoft.com/kb/902330 http://helpx.adobe.com/acrobat/kb/error-1935-install-acrobat-reader.html Those links are related to problems installing MS and Adobe software, but the same issue may affect other installers. Mark. -- 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] Re: ASCII Filter Options - Help please!
Tom Davies wrote: Hi :( Sorry about that! I just tried opening the file here but it would open. Then i renamed the file-ending from .odt to .zip but that wouldn't open. I tried changing it to .docX on a whim but without MS Office that was never going to be any different so i don't know why i even tried it! I tried opening with GEdit (= a lot like Notepad) but the 1st 2 letters were not PK and then i checked a different Odt that someone else sent me earlier and that did start with PK. I'm not convinced about the whole PK thing but it's interesting All Zip files start with PK, so the fact this file doesn't indicates that it's not a valid zip file (and therefore not a valid ODT file). I didn't yet try finding some tool for fixing zip files. it might be worth testing on a copy of a couple of files. There might be an odt fixing tool around the internet somewhere too. Apols and regards from Tom :) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: ASCII Filter Options - Help please!
Jacob Marioni wrote: -I tried changing my user profile, but that didn't work -When I open the files with Notepad, the text is in a different language: Ḣ鈓䣪桠榤嘳斵䬝ꎆ붏蟀뵔䔽얩턖ѳ腵超쉫뱁䎾⻩䃬➤ That's because Notepad is interpreting the file as Unicode text. From Notepad, if you go File Open, change Encoding to ANSI and then select the file to open, you'll see something similar to the extract you included in your original message. -I'll try to upload the file so people can look at it, but how do I do that? Can I just upload it here on the forum? At_Least_you_Have_Something!.odt http://nabble.documentfoundation.org/file/n4091641/At_Least_you_Have_Something%21.odt Apart from the initial PK which others have mentioned, I can't see any of the other features which tend to be seen near the beginning and end of Zip files (such as the names of the files packed within the .zip). It looks like this file has either been encrypted by the virus (as someone else here suggested; it might help to know what the virus was), or both the beginning and end of the file have been lost which would also make it pretty much impossible to recover anything from a Zip file. In case you're wondering why everyone's going on about Zip files, it's because ODT files are Zip files with the contents formatted in a particular way. Easiest recovery is probably to restore the files from a recent backup... -- 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] Help with libre
David M. Pelly wrote: Hello Libre office Foundation, Just for information, most people on this mailing list are other users helping each other out, so you may get several replies with different ideas. Most of us aren't associated with LibreOffice in any official sense, just trying to help others out ;o) I am using Libre office on Windows XP. Firefox is my preferred browser. I am not a techie. ... The present problem is: Some how, ( I think it is when I open or start up my computer,) I get a pop up that there is a Libre office update. So I click to get the update. I get a webpage with two green buttons: Without going back there to that site to see what it actually exactly says, because I forget what they are exactly, but what ever they are, they are confusing, especially to a non techie, non geek. I think one button says it is a downloader or installer. The other is something else. ( It does not say, update software.) When I click to open the webpage with the updates, the two download options I see are labelled Main installer and LibreOffice built-in help. Is that what you see? The first is the main program, the second provides the LibreOffice Help, available from the Help menu, which is optional. That appears to mean that I need to use two functions. One to download an installer first. Then another one is required to download the actual update software to the installer, so the installer can install the software in my Libre office program. If you want to update both the main program and the built-in help, you need to download and run both installers. But to just update the main program you only need the first. As with any downloaded software, you do need to run the installer after downloading it. It does not say that, but it seems to imply that. (Your products assume ( and take for granted) that the user knows almost as much as the actual designers and program developers. ) Now I landed up clicking on some buttons, and there was no windows telling me what was happening. As far as I thought at the time, I did not get the update. I was ticked off. That sounds like the behaviour of recent versions of Firefox - rather than a separate window showing the download progress, it just shows a green arrow at the right-hand end of the toolbar, with a narrow bar just below indicating how far through the download it is. You can click that green arrow to see the list of files you've downloaded, and open/run them (you need to run the installer after downloading it). ... So I went back to my work on my Libre office program. And I still see the green something in the upper right hand corner. I click on it and it says there are updates for Libre. So therefore I thought I did not get the updates. Perhaps you just downloaded the installer, and didn't run it to actually install the update. Or maybe the update failed for some reason (were there any error messages when running the installer?) So I click on it and a window pops up and says that I have the 4.0.4.2 version. I think that is the new update version. (Maybe I am wrong.) Does it not also tell you that the latest available version is? By coincidence, 4.0.4.2 is the same version I currently use, and when I clicking the update button in LibreOffice it says: LibreOffice 4.1.4 is available. The installed version is LibreOffice 4.0.4.2. So there is a newer version available (which I haven't bothered to install yet). ... I just thought of another problem/ suggestion: Why don't you include an undo feature on the right click window? That should be common sense. I'm not a developer, but just a guess... looking at the options which /are/ in the right-click (context) menu, they're all things which would affect the document at the point you clicked. Undo wouldn't - it would affect wherever the last change was. Why would you need undo on the right-click menu anyway? It's under the Edit menu, or you can use the keyboard shortcut Ctrl+Z. Another one: Some how when I was doing a lot of work on libre office, I landed up with some solid lines running across my page, which I cannot delete or remove? Why? How can I remove them? That sounds like a border applied to the paragraph either above or below the line. Assuming that's what's happened, to get rid of it: - Right-click in the paragraph immediately above the line - Click the Paragraph... option from the context menu - Click the Borders tab - Click the far-left square of the row just below the Line arrangement label to get rid of all the borders - Click OK If that didn't work, try the same again but starting with right-click on the paragraph immediately /below/ the line. As for how it got there, I'm guessing you typed a line containing nothing but several - or * followed by Enter (some other characters may have a similar effect). This is a feature to make it quick to insert these borders when you
Re: [libreoffice-users] Feature Request - Categories for special characters
Doug wrote: On 11/21/2013 02:00 PM, Mark Bourne wrote: Kracked_P_P---webmaster wrote: Then there are the younger users that know # only as hash-tag and not pound-sign. Yes many of the standard characters have different names depending on the languages used. In the UK, # is more commonly known as hash or number sign. For us, pound sign usually means £ ;o) Windows Vista's character map (and probably Windows 7's as well?) displays the name of the selected character (and can search for characters by name). It calls # Number Sign and £ Pound Sign. I think those are the official names defined by Unicode. Mark. I always think of # as being a sharp sign. The musical sharp symbol is slightly different: ♯ When I was in grade school, over 60 years ago, lb. meant pound(s). Writing a script in the bash shell in Linux, you start with #! which is known as shabang. shabang, I think, is short for hash bang - another name for ! being a bang. -- 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] Feature Request - Categories for special characters
Kracked_P_P---webmaster wrote: On 11/21/2013 01:59 PM, Mark Bourne wrote: David Gast wrote: I have two ideas. Interestingly, Windows Vista's Character Map utility (and probably also Windows 7's?) has similar ideas... 1. Highlight the categories, so it is easy to tell where the category starts and ends. Vista's character map has an option to group by Unicode subrange, where only the characters from the selected subrange are shown - as opposed to LibreOffice's current behaviour of jumping to the first character in the range, but giving no easy indication where the range ends. As you suggest, highlighting the range would be similarly helpful. 2. Allow some input box so you could type some substring of the characters' names and get all matching characters. For example, if you typed equal, all characters with equal in the name would be listed. (I do not know if the names are i*18n or not.). Vista's character map does pretty much exactly this. I think the character names are defined in the Unicode standard. Not sure if they're internationalised though. The thing that keeps catching me out with Vista is that after searching, the Search button changes to Reset - so to do a new search you have to first reset, then type the query string, then search; you can't just type a new query and search for it. Mark. I think you are asking for something like Thunderbird's Insert Special Character option. That option might be used as a different Special Character option. I really do not think that it would work on the non-Latin fonts or give you all of the glyphs/characters, especially the Unicode font's glyphs/characters, that the font has to offer or needed. I don't know about Thunderbird, but Windows Vista's character map (which I was describing) does work for all Unicode characters in the selected font. I'd expect Window 7's character map to also work similarly. For example, search for sharp and it returns: ß (U+00DF: Latin Small Letter Sharp S) and ♯ (U+266F: Music Sharp Sign) Want a division sign? My initial attempt searching for divide didn't get it, but trying another term division gets: ÷ (Division Sign) ∕ (Division Slash - not the same as /) ⊘ (Circled Division Slash) ⋇ (Division Times) I'm not certain, but think the names for the characters are defined by the Unicode standard. So I really think we need to keep the existing Special Character option, but could add on the alternative and limited one that Thunderbird has to LO. Since Thunderbird is also Open Source [so I have been told] you should be able to find the coding for this option if you look for it. [maybe even ask their developers for it] I am using it now so I can give you examples. You select all of the a characters, and then go down the scrolled list for the a character you wish to add. à á â ã ä å a; a*' a* a^' There are 30 in the lowercase a list. It looks like that's just searching for characters which look similar to the one you type? Probably based on some sort of lookup table. The Categories are - and some samples from Times [if they go through correctly] Accent Uppercase - È È E`` O;- O^' ? T^ Accent Lowercase - t ? ë e^ e~ Other Uppercase - Æ Ø DZ( Œ Other Lowercase - æ ß ø œ Common Symbols - ¡ ¤ © ® ¶ ¿ -- 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] Feature Request - Categories for special characters
Ruth Ann wrote: OT maybe, but does anyone know the name for @ ? Something I have been trying to discover for years :-) Ruth Ann, Cincinnati, OH USA It depends who you ask, and in what language ;o) Unicode calls it commercial at. The article about it on Wikipedia is titled At sign, and mentions some other names: http://en.wikipedia.org/wiki/At_sign Mark. -- 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] Feature Request - Categories for special characters
Kracked_P_P---webmaster wrote: Then there are the younger users that know # only as hash-tag and not pound-sign. Yes many of the standard characters have different names depending on the languages used. In the UK, # is more commonly known as hash or number sign. For us, pound sign usually means £ ;o) Windows Vista's character map (and probably Windows 7's as well?) displays the name of the selected character (and can search for characters by name). It calls # Number Sign and £ Pound Sign. I think those are the official names defined by Unicode. Mark. -- 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] Expected Behavior
Joel Madero wrote: I agree about his second step - I should have clarified. What he means that if you go to the end of the first line of the new page (ie. you've pushed enter after a line test and all the text below it jumps down to the next page. Heading 1 style has its Next Style set to Text Body. When you add a new line after a Heading 1-styled line, that new line has Text Body style. That does not have Keep with next paragraph set, so the next paragraph is not forced to stay on the same page. If there was only one more Heading 1 line following that, it would indeed stay just below, on the same page. However, there are many more consecutive lines, each with Heading 1 style, so each having to be kept with the next. In an attempt to keep them all together, LO moves them all onto the next page, leaving a large gap (although this effort fails, since it still can't keep them all together anyway). It looks like you're trying to create a template with a load of headings but no content within them? (Sorry, didn't intend that to sound like something an irritating paperclip might pop up and say!) Perhaps just leave a blank Text Body line between each heading in the template, ready to type the content? Or accept that the headings will be bunched together on the next page to start with, but will be OK when content is inserted between them? Then go to the next page, place the cursor at the end of the first line and push enter again - you'll see that the heading jumps back up to the previous page (exactly where you'd expect it to be). Because the Heading 1 line has to be kept with the new blank line, but that new blank line doesn't have to be kept with the following heading - so it's free to be on the previous page. Additionally a real problem is that ctrl+z doesn't put the text back to its previous location - furthermore if you turn on non printing characters, it's impossible to really see what caused the jump (no characters show in all that empty space) That doesn't seem quite right. I'm not a LO developer, so this is all supposition on my part, but... it looks like something in the algorithm working out which paragraphs have to be kept together on the same page is being inconsistent when it can't actually fit them all on one page. If... You have just enough Heading 1 lines to reach to the bottom of the first page (without flowing onto the second page). Then insert a line after the first heading on the page, so the rest jump to the second page. Then undo. It does then put everything back on the first page as you'd expect, because it does all fit there. When it doesn't all fit on one page, after undoing the inserted line the stuff on the second page is still set to all be kept together, so is not broken apart. Since this can't fit on the same page as the original first line, which is also supposed to be kept with the following lines, a page break has to be made somewhere. It's supposed to all be on one page, but can't be. It's no less valid to break after the first line than after the 20th, so it seems to take the easy option and do nothing. Undo twice then redo might work as a workaround, but then the second undo and redo might cause a similar problem of their own. (For what it's worth, I've seen worse than this with M$ Word, where I frequently find that I undo something and a whole page vanishes from display and just shows a blank page in its place. Scrolling up and down a few times seems to refresh the page display and sort it out.) Mark. -- 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