Re: [libreoffice-users] Re: Heads up -- LibreOffice 5.0 is on the horizion
The thumbnail view of recently used docs is one of the things that I LOVE about LibreOffice. To hear that it is a critical design element that can not be removed is wonderful news to me. Thanks, -Bill On 4/12/2015 1:42 PM, V Stuart Foote wrote: Jorge Rodríguez Thank you for submitting. I've uploaded your proposed StartCenter mockup to the Wiki--please log-in there (create an account if you do not already have one) and adjust the licensing and description for your artwork. https://wiki.documentfoundation.org/Design/Whiteboards/5.0_Branding Also, please consider that in your mockup, you appear to have eliminated the thumbnail view of recently used documents. That is a critical design element that can not be removed. So, your design needs additional work. You'll need to rework your mockup to show where thumbnail views and templates would be presented. Stuart -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146064.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] Calc: How to concat CTRL+ENTER to a string?
All, To place two lines of text in a cell I type the first line then press CTRL+ENTER and type the second line. I am trying to do this in an equation and don't know how. Here's what I have: =CONCATENATE(Target Balance Assuming , E2*100, % Growth) I want everything after Target Balance to appear in the second line of the cell so that the cell looks like this: Target Balance Assuming xx% Growth How do I modify the above equation to achieve this? Thanks, -Bill -- 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: Not happy with LO Calc worksheet tabs in 4.4.1.2
Thank you for posting that. The discussion is very interesting and clearly explains why the scrollbar was moved. No rational was given for changing the shape of the tabs however. Comment 29 by Tomaz Vajngerl: I have also made some visual changes to the tabs (rectangular, more plain look)... That change has no purpose, why was it made? To put another nail in the coffin of skeuomorphic design? (Rhetorical, don't waste your time trying to answer.) Visual cues are important and I think the rectangular tabs suggest columns rather than overlapping worksheets. Sorry, that's just my opinion. A new building on our campus opened last year and featured many modern technologies, including very nice-looking glass doors through which you enter and exit the building. The problem is that the doors have identical handles on either side. The handles themselves are very attractive, but they don’t tell me what to do when I want to enter the building—should I push or pull the door? The handles on these particular doors suggest to me that they are made for grasping and pulling. However, the door goes in only one direction, and the very same handles appear on both sides of the door. Therefore, to enter the building, I have to use the handle to pull the door, and to exit, I have to use the identical type of handle to push the door. How would someone possibly know which way the door swings when approaching it? Continued here: http://www.humankinetics.com/excerpts/excerpts/Push-or-Pull On the positive side, I love the new icons on the tool bars especially the one for inserting a chart. Also, I've been using and promoting LO since the beginning. I started with Open Office some moons ago and when Oracle messed everything up I switched over to LO and love it. So, I apologize for the rant. (My wife says I'm getting old and grumpy. Maybe she's right.) -Bill On 3/22/2015 6:48 PM, V Stuart Foote wrote: wdrago wrote All, I just upgraded to 4.4.1.2 (Windows) and I am not happy to see that the worksheet selection buttons now look like columns instead of folder tabs. Was there any logic behind this change or is this change for the sake of change? How does this make Calc more useable? What problem were users having that this change solved? Sorry for the rant, but I am getting tired of unnecessary changes. I see this happening in all software, not just LO. I do appreciate the product and all the hard work that goes into it. -Bill Sorry, but fully shown in the 4.4 release notes https://wiki.documentfoundation.org/ReleaseNotes/4.4#Tab_changes posted since January. /Tab changes Sheet tabs (Calc) and layer tabs (Draw) were moved to an independent row and are no longer displayed next to the horizontal scrollbar. As many visual styles under Linux (in addition to the default OS X configuration) use very thin scrollbars, these rendered the tabs too small to be clickable and, most importantly, readable. The tabs have an updated, flatter look./ You can read the rational and dev actions on tdf#36772 https://bugs.documentfoundation.org/show_bug.cgi?id=36772 --UI: Sheet tabs appear too small because LibreOffice has problems with certain themes or does not force a minimim hight for tabs And some counter discussion on tdf#87684 https://bugs.documentfoundation.org/show_bug.cgi?id=87684 -- UI: Calc sheet tabs and horizontal scroll bar are now wasting twice the space Point is, this is nothing new or exceptional, the change was implemented Aug 2014. If you'd like to avoid such unpleasantness, perhaps you should invest a little of your own time and check out some of the more current builds spun out by the project TinderBox's at http://dev-builds.libreoffice.org/daily/ -- View this message in context: http://nabble.documentfoundation.org/Not-happy-with-LO-Calc-worksheet-tabs-in-4-4-1-2-tp4144102p4144114.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] Not happy with LO Calc worksheet tabs in 4.4.1.2
All, I just upgraded to 4.4.1.2 (Windows) and I am not happy to see that the worksheet selection buttons now look like columns instead of folder tabs. Was there any logic behind this change or is this change for the sake of change? How does this make Calc more useable? What problem were users having that this change solved? Sorry for the rant, but I am getting tired of unnecessary changes. I see this happening in all software, not just LO. I do appreciate the product and all the hard work that goes into it. -Bill -- 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 opens behind Windows Explorer
To All, Thank you for the replies. Now I know there is nothing wrong with my computer. (LO 4.3.5.2, Windows 7 Professional. Yes I forgot to include that in my original post. Sorry.) Regards, -Bill On 2/27/2015 9:22 AM, Tom Davies wrote: Hi :) Comments to bug-reports should include new information such as version of Windows and/or version of LO that hasn't already been included in previous posts. Otherwise it only increases ire. I didn't realise the issue was that common. It's the first time i've seen anyone mention it on this mailing list as far as i remember. I might well have missed it earlier though. Regards from Tom :) On 27 February 2015 at 13:41, Dave dave.ta...@gmail.com wrote: All, Does anyone else have this problem and is there a solution? When I double click on a writer or calc file it opens behind the windows explorer window that I double clicked in. I'll explain this another way in case that's not clear. Say I have a folder open on my screen with some .odt and .ods files in it. If I double click on a file to open it, it will open behind the folder that contains the file I clicked on. Does anyone know what I'm talking about? Is there a solution? Thanks, -Bill COPY OF ORIGINAL MESSAGE RESENT TO LIST FROM DIFFERENT EMAIL ADDRESS TO BYPASS TDF's BROKEN EMAIL FILTERS!!! Yes Bill, I know exactly what you are talking about. I have seen and used numerous Windows and Linux machines where opening the LO does not grab the focus in the same way as most other programs do. A LO defect I have simply learned to live with. There are at least 2 open Bugzilla related reports: https://bugs.documentfoundation.org/show_bug.cgi?id=48300 https://bugs.documentfoundation.org/show_bug.cgi?id=75471 Some argue that they are different issues, I disagree, because it is only the splash logo that pulls the focus to the LO window, with the -nologo parameter set or for second instances where LO doesn't already hold the focus, the code makes no attempt to set the window focus. Coding to set the the window focus under Windows Linux (don't know OSX) is Programming 101 stuff and should be listed as an Easy Hack. It has been suggested that this _might_ be fixed in version 4.5, but not in any the dev builds I have tested so far. Is there a solution? None that I am aware of, but adding a comment to one or both the above report may help to attract a developer's interest. Regards Dave -- 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
[libreoffice-users] LO opens behind Windows Explorer
All, Does anyone else have this problem and is there a solution? When I double click on a writer or calc file it opens behind the windows explorer window that I double clicked in. I'll explain this another way in case that's not clear. Say I have a folder open on my screen with some .odt and .ods files in it. If I double click on a file to open it, it will open behind the folder that contains the file I clicked on. Does anyone know what I'm talking about? Is there a solution? Thanks, -Bill -- 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 Writer, how to insert horizontal line
Thank you to everyone who replied to my question. The problem is now solved. Regards, -Bill On 11/15/2014 10:57 AM, William Drago wrote: I'm trying to insert a horizontal line into my LO document. The help says: 1. Click in the document where you want to insert the line. 2. Choose *Insert - Horizontal Rule* see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line Well, there's no Horizontal Rule under insert. So how is this done? Thanks, -Bill -- 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] LO Writer, how to insert horizontal line
I'm trying to insert a horizontal line into my LO document. The help says: 1. Click in the document where you want to insert the line. 2. Choose *Insert - Horizontal Rule* see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line Well, there's no Horizontal Rule under insert. So how is this done? Thanks, -Bill -- 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: Generate a column of times
It might be helpful if you post the actual start/stop times for the 2026 samples. There's more than one way to skin this cat and I'd only look for solutions outside of Calc as a very last resort. -Bill On 9/9/2014 8:22 PM, office76#xt wrote: Thanks for the replies. My earlier example was a simplified version of the data I'm working with. When Brian Wdragos technique is applied to the 2026 samples I really have, it sort of works so I can see what your talking about. I keep altering the incrementation that takes place in this technique to try to get the last cell to say the stop time. It comes pretty close but is always off by a few minutes. The reason for this is theres a limit to the precision you can do with Times in OpenOffice Calc. Using the hr/mn/sec format you can't generate small enough increments to get the generated times to match the stop time. If there was a hr/mn/sec/fraction of a second format you could do it. In Calc theres a time format that looks like this, but in practice it doesn't 'roll over' like say minutes or seconds. It looks like Calc's stock functions won't do the job. I'm thinking of getting around this by finding some source for a stopwatch program, and maybe modifiying it to do something similar, but with a greater precision of incrementation. -- View this message in context: http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568p4121744.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
Re: [libreoffice-users] Re: Generate a column of times
This is what Brian is trying to explain... You've got 6 samples. The first one taken at 12:04PM, the last one at 12:36PM. The total elapsed time is 12:36PM - 12:04PM = 22 minutes. 22 divided by 5 (always the total number of readings minus 1) = 6.4 minutes or 6m and 24s per interval. Adding 6:24 to 12:04PM gives you the time of the second reading, 12:10:24PM. Enter that value into cell B2. Now we make the computer do the work for all remaining readings. Follow these instructions carefully: Highlight cells B1 and B2. Hover the mouse over the little black square in the lower right hand corner of the the highlighted cells until it turns into a cross (+). Now hold the left mouse button down and drag the mouse downward. As you drag the mouse each cell will fill with the correct time stamp. You will end up with this: 12.7 12:04:00 PM 8.912:10:24 PM 3.512:16:48 PM 2.112:23:12 PM 7.212:29:36 PM 6.112:36:00 PM If you want to use 1S as your interval the just enter 12:04:01PM in B2 and drag the mouse as explained above. Hope that helps... -Bill On 9/8/2014 8:29 PM, office76#xt wrote: Thanks Brian for the reply, The data acquisition device samples at approximately 1 sample per second not a nice fixed sample rate. And unfortunately time stamps the first and last sample only. If the sample values are in column A1, then I'd like an approximate time-line in the cells between the start logging and stop logging times in column B2. What I'm after is to look at my notes taken at different times (the time noted) during logging, and identify the approximate sample that corresponds to them. I'm afraid I don't understand your example as it looks like you have the samples in a row not a column. -- View this message in context: http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568p4121600.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
Re: [libreoffice-users] Re: Generate a column of times
On 9/9/2014 6:18 AM, Brian Barker wrote: At 05:45 09/09/2014 -0400, William Drago wrote: This is what Brian is trying to explain... I was doing more than try! And no: what you suggest here is not what I was saying. You've got 6 samples. The first one taken at 12:04PM, the last one at 12:36PM. The total elapsed time is 12:36PM - 12:04PM = 22 minutes. Er that's *thirty*-two minutes , not twenty-two, by my arithmetic. 32 minutes, yes! That's what happens when I do math so early in the morning. Follow these instructions carefully: Why not follow my instructions instead (which are quite different), where a formula does all the calculation for you, not just the last bit? Since the OP was confused by your instructions (indicating his level of inexperience with spreadsheets) and you did not explain how to fill the column or the purpose of $, I offered what I thought would be easier for someone at his level to understand. It is not necessarily the best approach, but something I thought would solve his problem and he would understand. It also demonstrates the ability of a spreadsheet to generate data based on a pattern in selected cells. This can be a time saver and is not something everyone is aware of. My solution is not intended as a criticism of your solution, which made perfect sense to me and is frequently what I do in my own spreadsheets. I merely offered an alternative to someone who was struggling. Regards, -Bill -- 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 - Chart border
Well, there's always the stable release. That's supposed to be less buggy than the fresh. I guess I just enjoy punishing myself. -Bill On 6/6/2014 10:09 AM, anne-ology wrote: yet another reason to not update ;-) from the 'out-of-date' corner: I'm still using 3.4 ;-) From: J. Van Brimmer jerry...@gmail.com Date: Wed, Jun 4, 2014 at 8:42 AM Subject: Re: [libreoffice-users] Calc - Chart border To: LibreOffice List users@global.libreoffice.org I have noticed that somewhere along the update path, the borders around charts inserted into Calc have disappeared. I'm now using LO 4.2.3.3 on Linux. But I don't know exactly when it happened. When I create a new chart, and set up a border, the border doesn't show up. Sorry, Willian, I know this doesn't answer your question, it's just that I have noticed the same problem. On Wed, Jun 4, 2014 at 2:20 AM, William Drago wdr...@suffolk.lib.ny.us wrote: All, Can anyone tell me how to add a border around a chart? Thanks, -Bill Jerry Van Brimmer -- 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 - Chart border
Okay, so chart borders no longer work, that's why I can't figure out how to do it. Is this an official bug yet? I don't have a Bugzilla account. http://ask.libreoffice.org/en/question/34953/chart-border/ -Bill On 6/4/2014 9:42 AM, J. Van Brimmer wrote: I have noticed that somewhere along the update path, the borders around charts inserted into Calc have disappeared. I'm now using LO 4.2.3.3 on Linux. But I don't know exactly when it happened. When I create a new chart, and set up a border, the border doesn't show up. Sorry, Willian, I know this doesn't answer your question, it's just that I have noticed the same problem. On Wed, Jun 4, 2014 at 2:20 AM, William Drago wdr...@suffolk.lib.ny.us wrote: All, Can anyone tell me how to add a border around a chart? Thanks, -Bill -- 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
[libreoffice-users] Calc - Chart border
All, Can anyone tell me how to add a border around a chart? Thanks, -Bill -- 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] Can't get leading zeros in Calc
To preserve leading 0's in a spreadsheet type the number with an apostrophe before it. For example, instead of typing 1234, type '001234. That will preserve the leading 0's. If I don't care about formatting in the spreadsheet, I'll add the leading 0's in the code that does the passing. Typically I read the cell, convert to string, pad with the appropriate number of 0's, then write to the database. -Bill On 5/31/2014 7:34 PM, Oogie McGuire wrote: I'm tearing my hair out here. I have a spreadsheet and the data was originally entered as 4 digits. I need to pass it to a database system that requires 6 digits. I've tried formatting with 2 leading zeros but I still cannot get the number to properly show up as 00number Any ideas? Eugenie (Oogie) McGuire Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/ LambTracker - Open Source SW for Shepherds http://www.lambtracker.com Paonia, CO 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] Calc worksheet stalls when opening. Solved!
All, I tried Tom's suggestion and opened the file with Gnumerics. This awesome little program opened the spreadsheet and let me know what was wrong with it: Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/static/netbenefits/common/images/nb_footer_logo.gif'. At one time I had copied pasted some information from my retirement account into the spreadsheet. Unless I'm logged into my Fidelity account, none of these URLs will work. Now I have 3 questions: 1) Why doesn't LO tell us what the problems are like Gnumerics does instead of stalling for 20 minutes or more? 2) Why is the timeout period so long? 20 minutes? Really? 3) When we copy paste a webpage why is LO storing links to images instead of the actual images? Anyway, at least now I know how to fix this. -Bill On 3/12/2014 11:11 AM, Tom Davies wrote: Hi :) Also wondering what the memory setting are like Tools - Options - Memory On most machines you can bump al those values right up. the defaults are for very low spec machines. How large/heavy is the spreadsheet? If it's over 10Mb then that might explain it. Does it have lots of embedded images in it? Could those be just linked to rather than embedded? Have you tried using Gnumeric for that spreadsheet? Gnumeric is a dedicated spreadsheeting program so it's far more sophisticated than Calc/Excel for some things. Quite a few people have it alongside LibreOffice or other office suite for use when they need something really serious. Regards from Tom :) On 12 March 2014 07:39, pete nikolic pg.nikol...@gmail.com wrote: On Tue, 11 Mar 2014 22:25:32 -0400 Alan B abo...@gmail.com wrote: On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet? Calc on Ubuntu does this to me fairly often with any spreadsheet. I filed a bug report but I don't think there's active interest in it. When the report was filed I got a suggestion to upgrade, did so and the problem stopped. Now, a few Ubuntu patches later, and the stall when open behavior is back. My work around has been Apache OpenOffice. When I get tired of the stalling (and it's only Calc not Write or other programs) I start using AOO Calc. Usually after a few LO patches are part of the Ubuntu updates the stalling stops. So... if is a problem with any spreadsheet, check if there is a newer LO and install that to see if the issue is resolved. If the issue isn't resolved by upgrading LO consider installing AOO and try opening the spreadsheet with AOO Calc. If the problem persists when the spreadsheet is opened with AOO Calc it is definitely the spreadsheet. Regardless of trying AOO, if it is only one particular spreadsheet, a bit more information would be helpful trying to diagnose the problem. - did this spreadsheet always act this way? - if no, -- what changes were made to the computer between the time the spreadsheet last opened normally and first opened slowly? i.e., add/remove, upgrade, or patch software -- what changes were made to the spreadsheet between the time it last opened normally and it first opened slowly? ie, add borders to cells, create new formulas, add more data Hi Just a suggestion from personal experience . I use Presents quite a lot i was having problems with very slow opening of certain ODP files like 2 to 3 mins . I started having problems logging into my user on the system so bit the bullet thought sod it created another user moved some important stuff to the new user No more slow opening problems . Like i said at the start just a suggestion from personal experience Pete . -- Linux 7-of-9 3.13.6-1-ARCH #1 SMP PREEMPT Fri Mar 7 22:47:48 CET 2014 x86_64 GNU/Linux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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
Re: [libreoffice-users] Calc worksheet stalls when opening. Solved!
Did you try embedded those images in a LO spreadsheet to see if they load, or did you just open them in your browser? -Bill On 3/14/2014 7:00 AM, Cley Faye wrote: 2014-03-14 11:41 GMT+01:00 William Drago wdr...@suffolk.lib.ny.us: All, I tried Tom's suggestion and opened the file with Gnumerics. This awesome little program opened the spreadsheet and let me know what was wrong with it: Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300. fidelity.com/images/savings2/alert.gif'. Unable to load the file 'https://retiretxn300.fidelity.com/static/ netbenefits/common/images/nb_footer_logo.gif'. At one time I had copied pasted some information from my retirement account into the spreadsheet. Unless I'm logged into my Fidelity account, none of these URLs will work. Now I have 3 questions: 1) Why doesn't LO tell us what the problems are like Gnumerics does instead of stalling for 20 minutes or more? Not sure, maybe he is just trying to open them. But these images load fine without being logged anywhere (I can see them), so I'm not sure that the problem is there. It might be related to another resource on internet anyway. 2) Why is the timeout period so long? 20 minutes? Really? My previous statement kinda invalid the idea of a timeout (unless the website was down all the time you tried to open the file...). But if the issue lies in Calc behing unable to open a file with https links, the timeout per file isn't insanely high: 2-3 minutes is a fairly reasonable value to accomodate with dead-slow connections. But since the images load correctly... moot point :( 3) When we copy paste a webpage why is LO storing links to images instead of the actual images? I believe it's by design: it is not always desirable to create multiple copies of the image source; especially if it's not a static image, that is used to convey updated informations for example; or if you are working on a document where graphic designers can update their work, put placeholder in places, etc. In this regard, it keeps the URL as the image source as it would keep the abolute file path from a file source. Note that you can see and kill these links by going in the Edit menu: Edit-Links. There you can select all links and hit Break Links. If the issue lies in Calc loading a file with linked images on the web, this can avoid the issue (given you do it before saving, of course). However, since these links are publicly accessible, a failure to load them by Calc is likely a bug if it is confirmed. -- 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 worksheet stalls when opening
On 3/11/2014 10:25 PM, Alan B wrote: On Tue, Mar 11, 2014 at 9:21 PM, William Drago wdr...@suffolk.lib.ny.uswrote: I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I Just looking for confirmation the issue is with only one particular spreadsheet? Yes. Only one spreadsheet. Calc on Ubuntu does this to me fairly often with any spreadsheet. I filed a bug report but I don't think there's active interest in it. When the report was filed I got a suggestion to upgrade, did so and the problem stopped. Now, a few Ubuntu patches later, and the stall when open behavior is back. My work around has been Apache OpenOffice. When I get tired of the stalling (and it's only Calc not Write or other programs) I start using AOO Calc. Usually after a few LO patches are part of the Ubuntu updates the stalling stops. So... if is a problem with any spreadsheet, check if there is a newer LO and install that to see if the issue is resolved. If the issue isn't resolved by upgrading LO consider installing AOO and try opening the spreadsheet with AOO Calc. If the problem persists when the spreadsheet is opened with AOO Calc it is definitely the spreadsheet. Regardless of trying AOO, if it is only one particular spreadsheet, a bit more information would be helpful trying to diagnose the problem. - did this spreadsheet always act this way? No. - if no, -- what changes were made to the computer between the time the spreadsheet last opened normally and first opened slowly? i.e., add/remove, upgrade, or patch software I Upgraded to LO 4.2.1 from 4.2.0. -- what changes were made to the spreadsheet between the time it last opened normally and it first opened slowly? ie, add borders to cells, create new formulas, add more data No changes were made to the spreadsheet. I'd post a copy of it somewhere, but it's my personal budget from last year. -- 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] Calc worksheet stalls when opening
All, I have a spreadsheet that stalls when I try to open it and when I try to save it. It does eventually open after a very long time. I don't know how long, I just walk away from the computer, eat breakfast, and then come back. Are there any log files that I can look at to try and determine what is wrong with this file? Is there any way to test the integrity of the file? Thanks, -Bill LO 4.2.1 -- 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] What happened to the release notes for 4.2.1?
All, The LibreOffice website looks different and some information is missing that was there last week. In particular I'm looking for the 4.2.1 release notes which used to be here: http://www.libreoffice.org/download/release-notes/ I just noticed that the 4.1.5 release notes are gone too! What's going on here? -Bill On 3/7/2014 7:42 PM, Stephan Petersen wrote: Hi guys, does anyone know how to set the default number of slides per page when printing handouts? LO unfortunately contains a bug (which goes way back and remains unfixed) that causes it to forget what you were printing (notes, handouts, ...) between print jobs. And with the latest version it even got worse. Now, if you want to print handouts, you not only have to select handouts every time, but now you also have to pick the number of slides per page again, unless you want the default, which seems to be 6 (for whatever reason). Does anyone know a workaround for this nuisance? Thanks and all the best, Stephan -- 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 convert text to numbers
I just tried this extension. It's easy to use and seems to work very well. Is there a way to move its icon to a different place on the tool bar? Thanks, -Bill On 11/10/2013 5:08 PM, Joel Madero wrote: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates That extension should do the trick - we're trying to incorporate it into the core code but so far you need the extension. All the best, Joel On 11/10/2013 01:57 PM, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and help at Libre Office are less than useful. https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that this conversion happens automatically but it sure doesn't I found reference to a value function, but no information on how to apply it to this data. I tried just changing the format of the cells to be number but that didn't do anything at all. I've also attempted various styles of paste special but still it doesn't work. There has got to be a way to quickly say this text is all really numbers and get it working! Please help Eugenie (Oogie) McGuire Desert Weyr http://www.desertweyr.com/ Paonia, CO 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] Re: Including code example in documents
If you are using NetBeans (available on most Linux flavors) you can export to HTML by clicking File Print to HTML. -Bill On 8/12/2013 6:30 PM, aihaike wrote: Dear all, Thank for all your suggestion. I use Linux and Notepad++ or NoteTab are available on widows only. I think I'll try the RTF generation option. Thanks again. Éric.. -- View this message in context: http://nabble.documentfoundation.org/Including-code-example-in-documents-tp4069680p4069788.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
Re: [libreoffice-users] Re: Including code example in documents
I do this all the time using the syntax highlighter in Notepad++. If you don't have Notepad++ (my favorite code/text editor), get it here: http://notepad-plus-plus.org/ Here's how to get syntax highlighted code into your LibreOffice documents: 1: Open source file with Notepad++ 2: In Notepad++ click Plugins NppExport Export to RTF You will now have a syntax highlighted copy of your source file however, it will be double spaced. To remove the extra spaces proceed as follows: 1: With any editor, open the .rtf file you just created 2: Search and replace \par with \line 3: Save file Open the .rtf file with LibreOffice Writer, select all (CTRL-A), copy paste into your working document. This sounds like a bit of an ordeal, but I do this quite frequently, and once you've done it a few times, it becomes very fast and easy. Good luck, -Bill On 8/11/2013 9:22 PM, aihaike wrote: Hey Miguel, thank you for you reply. This the kind of macro I need but it does not seem to work with LibreOffice 4 unfortunately. I think I'm going to make a snapshot of my codes and include them as a picture. Éric. -- View this message in context: http://nabble.documentfoundation.org/Including-code-example-in-documents-tp4069680p4069685.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
Re: [libreoffice-users] Augmented Matrix in Math
Never mind... It's done with 2 matrices as follows: left[ matrix{ 1#3#2## 2#0#1## 5#2#2} mline matrix{ 4## 3## 1} right] On 7/20/2013 5:58 PM, William Drago wrote: All, I am trying to create an augmented matrix in LO Math. (http://en.wikipedia.org/wiki/Augmented_matrix) The code below generates a regular matrix. To make it an augmented matrix I need a vertical line between the 3rd and 4th columns. left [matrix{1#3#2#4##2#0#1#3##5#2#2#1} right ] I've had no luck with lline and riline. The vertical line can be solid or dashed, and I'd like the option to use either so I can choose the one that looks best. Thanks, -Bill -- 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] Augmented Matrix in Math
Hi Brian, Thanks, that does look better. Why does using the tick marks add space around the line? -Bill On 7/21/2013 4:03 PM, Brian Barker wrote: At 07:49 21/07/2013 -0400, William Drago wrote: On 7/20/2013 5:58 PM, William Drago wrote: I am trying to create an augmented matrix in LO Math. Never mind... It's done with 2 matrices as follows: left[ matrix{ 1#3#2## 2#0#1## 5#2#2} mline matrix{ 4## 3## 1} right] You might even prefer: [...] `mline` [...] 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
[libreoffice-users] Augmented Matrix in Math
All, I am trying to create an augmented matrix in LO Math. (http://en.wikipedia.org/wiki/Augmented_matrix) The code below generates a regular matrix. To make it an augmented matrix I need a vertical line between the 3rd and 4th columns. left [matrix{1#3#2#4##2#0#1#3##5#2#2#1} right ] I've had no luck with lline and riline. The vertical line can be solid or dashed, and I'd like the option to use either so I can choose the one that looks best. Thanks, -Bill -- 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 header outside right margin
Negative indents are rejected by LO. If I type -1.00 the minus sign is dropped as soon as I click Apply. -Bill On 6/26/2013 1:31 PM, Regina Henschel wrote: Hi William, William Drago schrieb: All, I am working on a research paper. The required page layout puts last name, working title, and page number in the upper right hand corner of each page, outside the right hand margin. It is similar to what is shown here, but has to appear on every page, not just the first page, and has to be outside the right margin and closer to the top of the page. http://www15.uta.fi/FAST/PK6/CITEX/TRADMOD/trad-mla.html How can this be done in LO Writer? Something, that should be repeated on each page, goes into the header or footer. If this should be beyond the right edge of the text area, you can use a negative indent of the paragraph in the header. You can use a frame anchored to the header paragraph as well. A frame has the advantage, that the position is more flexible. 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
Re: [libreoffice-users] LO 4.0.3.3: 'Insert: Horizontal rule' is missing
I was desperately look for this yesterday morning. I finally resorted to drawing a line using the draw menu. Now I am trying to do it the new way, described below, and that doesn't work either. On this page (https://help.libreoffice.org/Common/Drawing_Lines_in_Text) the instructions say: 1. Create a horizontal line by applying the preset Paragraph Style Horizontal Line. Click into an empty paragraph, and double-click the Horizontal Line Style in the Styles and Formatting window. If the entry for horizontal lines is not visible in the list of Paragraph Styles, select All Styles in the lower listbox. Well, there is no Horizontal Line Style listed even after selecting All Styles. So, what is the official, documented replacement for Insert Horizontal Line? -Bill On 6/13/2013 10:48 AM, Maurice Batey wrote: Having installed Mageia-3 on a trial basis, I have come across an omission in its LO 4.0.3.3 that I have been using on Mageia-2's LO 3.5.7.2, namely 'Insert: Horizontal rule' The result is that any document prepared with 3.5.7.2 does not appear correctly under 4.0.3.3. I see from: http://ask.libreoffice.org/en/question/14922/why-is-horizontal-line-broken-in-401/ that the omission is a deliberate change rather than accidental (although it seems the Help info still thinks otherwise...). Why on earth drop a feature that people are using? What is the rationale? Failing any other solution to my problem, is there any way I can copy the 3.5.7.2 'ruler' file over in to 4.0.3.3 so that the latter shows the lines properly? -- 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] Need header outside right margin
All, I am working on a research paper. The required page layout puts last name, working title, and page number in the upper right hand corner of each page, outside the right hand margin. It is similar to what is shown here, but has to appear on every page, not just the first page, and has to be outside the right margin and closer to the top of the page. http://www15.uta.fi/FAST/PK6/CITEX/TRADMOD/trad-mla.html How can this be done in LO Writer? Thanks, -Bill -- 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 header outside right margin
Hi Virgil, Thank you for the detailed reply. I've been meaning to learn how to use styles, so I'll give this a try. Regards, -Bill On 6/26/2013 7:55 AM, Virgil Arrington wrote: William, Your document would use page styles. The page style for the first page would not have any headers. Then the page style for the subsequent pages would have a header. You can then format the lines (paragraphs) within the header to any left and right margin you would like. (To have margins extend beyond the normal page margin, use negative numbers in your paragraph indent settings.) To get to the page styles, make sure you're styles list is showing (press F11 if it isn't). Then, at the top of the list are icons for (from left to right) paragraph styles, character styles, frame styles, and then page styles (it looks like a sheet of paper). Click on that icon to see a list of the page styles available for your document. You can then right click on any one of them to modify them or create new ones. At this point, it would be best for you to experiment with the page styles yourself, creating new ones or modifying existing ones to get the result that you want. Take careful note of the option on the organizer tab for next style as it will show what page style will be used for the following page. Sometimes this can cause some frustration. Also, there is an option in the header tab to set left and right margins. It may not allow negative margin settings here (I just tried it and it ignored me), so you may need to set negative margins at the paragraph indent level rather than the header margin level. It's all about learning to use styles, paragraph styles for paragraph level formatting and page styles for page level formatting. It's a pain to learn, and while you're learning you want to cuss out the LO developers, but once you learn it, you'll bless them as you'll be able to make your documents sing. The only way I know to learn is to experiment and play with them, creating your own styles along the way. I know its frustrating when all you want to do is finish the current project, but the more you learn now, the more you'll be able to apply to future projects to make your work so much quicker, automated, and consistent. It really is worth the effort. What I find most interesting is the dark ages style of formatting papers that you've been handed, with paragraph indents measured in spaces and lines in terms of single double and triple spacing. Is this an Underwood we're using or a computer? As long as we remain entrenched in a typewriter mentality (even though many of us have never typed a single letter on a typewriter), we will never learn the advanced capabilities of our computers, which act more like printing presses than typewriters. Virgil -Original Message- From: William Drago Sent: Wednesday, June 26, 2013 6:01 AM To: LibreOffice List Subject: [libreoffice-users] Need header outside right margin All, I am working on a research paper. The required page layout puts last name, working title, and page number in the upper right hand corner of each page, outside the right hand margin. It is similar to what is shown here, but has to appear on every page, not just the first page, and has to be outside the right margin and closer to the top of the page. http://www15.uta.fi/FAST/PK6/CITEX/TRADMOD/trad-mla.html How can this be done in LO Writer? Thanks, -Bill -- 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 header outside right margin
Well, I provided a bad example. What I'm being asked to do is pretty close to the latest format from MLA. The only difference is that outside the margin thing. I don't know where that's from, but that's what I have to do. If I can't get styles to work, I'll try your technique. Thanks, -Bill On 6/26/2013 1:19 PM, Brian Barker wrote: At 06:01 26/06/2013 -0400, William Drago wrote: I am working on a research paper. The required page layout puts last name, working title, and page number in the upper right hand corner of each page, outside the right hand margin. It is similar to what is shown here, but has to appear on every page, not just the first page, and has to be outside the right margin and closer to the top of the page. http://www15.uta.fi/FAST/PK6/CITEX/TRADMOD/trad-mla.html Aargh! To follow that, you might want to time-travel to the previous millennium and purchase a typewriter! How can this be done in LO Writer? Fairly easily, I think. First, the page margins are the printing limits, so you need to set these wide enough to contain the extra material at the top of each page. Now insert a header, using Insert | Header, and enter the required material. Now your only problem is that you need the main text not to spread as far as your newly extended right margin. There are probably a number of ways to do that; the easiest may be to modify your paragraph style. Right-click in the text and go to Edit Paragraph Style... | Indents Spacing | Indent and set the After text value to however much you extended the right margin to accommodate your header. This will move the paragraph margin for all your text back to where you want it. (This won't work if you have applied contradictory local paragraph formatting, of course. If necessary, use Format | Default Formatting (or Ctrl+M) to remove this.) 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
[libreoffice-users] How to center a pasted drawing?
All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there must be a better way to do this than dragging it around until it looks centered. Can anyone tell me how? Thanks, -Bill -- 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 center a pasted drawing?
When I highlight the drawing the text object menu disappears and is replaced by the drawing object menu. When I click View Tool Bars Text object, the text object tool bar does come back, but all of its buttons are ghosted. When I right-click the drawing the Alignment menu has one item in it that says No selection possible and the Arrange menu only has Bring to front, Bring forward, Send backwards, Send to back, and To background. I am using LO 4.0.3.3 and the drawings are pasted in from LO Draw and Impress. BTW, pasting drawings into Writer is the correct way to get them from Draw to Writer isn't it? Thanks, -Bill left-right-center buttons disappear and are replaced by a bunch of buttons On 5/12/2013 12:37 PM, Tom Davies wrote: Hi :) I use the left-right-centred buttons same as for text Recently i found the right-click Arrange and Align that give more options. Regard from Tom :) From: William Drago wdr...@suffolk.lib.ny.us To: LibreOffice List users@global.libreoffice.org Sent: Sunday, 12 May 2013, 17:27 Subject: [libreoffice-users] How to center a pasted drawing? All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there must be a better way to do this than dragging it around until it looks centered. Can anyone tell me how? Thanks, -Bill -- 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] How to center a pasted drawing?
Okay, the Position and Size feature does the trick. Thank you very much... -Bill On 5/12/2013 1:12 PM, Regina Henschel wrote: Hi William, William Drago schrieb: All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there must be a better way to do this than dragging it around until it looks centered. Can anyone tell me how? Use the PositionSize dialog from its context menu. It allows a large varieties of settings. For example you can center to page or center to text area. 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
Re: [libreoffice-users] How to center a pasted drawing?
Thanks for the suggestion, Peter, but that doesn't work either. I can anchor the image as character, but as soon as I select the image to center it the text object menu disappears and the image object menu replaces it. If I use Format from the menu bar the expected options for alignment are gone. The only thing that works is Position Size. And it works quite well, so I'll stick with that... Regards, -Bill On 5/12/2013 5:33 PM, Andrew Douglas Pitonyak wrote: I always anchor the image as character, then it can be manipulated as a character (so just center it as you would a line of text). On 05/12/2013 12:27 PM, William Drago wrote: All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there must be a better way to do this than dragging it around until it looks centered. Can anyone tell me how? Thanks, -Bill -- 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] 4.0.3.3 - Thanks!
Just a thank you to say 4.0.3.3 fixed my 2 most annoying bugs 1) calc losing cell formatting after re-open and 2) writer losing drawings after re-open. I do appreciate the hard work... Thanks, -Bill -- 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] java macro
Tom Vieri, Let's not get the Java browser plugin and the Java programming language confused... Java is an excellent programming language and in no way can be considered any less solid than C++. In fact, in many ways it is more secure and more reliable than code written in C++. What people are uninstalling/disabling (even me) is the Java browser plugin, not the JRE/JDK. The plugin has indeed had many security issues, and with Flash and HTML5 very few people are using Java applets in their websites anymore. So... Java plugin = bad. Java programming language = excellent. Now that that's settled, C++ is a language that every programmer should at least be familiar with. Whatever language you choose as a primary programming language is determined by a variety of factors, but as a general rule you'll be more productive in Java than C++. Python is also an excellent programming language, but I have too little experience with it to comment any further than that. -Bill On 5/9/2013 5:25 AM, Tom Davies wrote: Hi :) Errr, now that you have learned about programming in a general way and looking to consolidate details would it be a good time to learn something more solid? C++ or Python perhaps? Oracle seem to be having a lot of trouble writing code that doesn't get compromised really fast. So, many people are getting rid of Java and moving away from it as fast as possible. Even the US Homeland Security apparently sent a notice to tell people to avoid Java and uninstall it asap. Of course a lot of large companies are a bit stuck and there are still a lot of adverts for programmers that know java. In my country jobs for Java programmers start at 20k but for C++ programmers start at 30k Regards from Tom :) From: Vieri rentor...@yahoo.com To: users@global.libreoffice.org Sent: Thursday, 9 May 2013, 9:12 Subject: [libreoffice-users] java macro Hi, I'm new to making Java macros. I compiled my Java class, created the parcel-descriptor.xml file and placed the .xml, .jar and .class files within the following folders I also created: C:\Users\USERNAME\AppData\Roaming\LibreOffice\4\user\Scripts\java\MACRO1 C:\Program Files\LibreOffice 4.0\share\Scripts\java\MACRO1 When I re-launch LO and go to Macros- Run Macros, I don't see my MACRO1 java macro under My Macros or LibreOffice Macros. Why is that? Shouldn't I at least see the listing? Java JRE 7 seems to work because if I select the LibreOffice java HelloWorld example, it prints a message in my document. Thanks, Vieri -- 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
[libreoffice-users] How to turn off the global menu
All, I am using LO 4.0.2.2 in Ubuntu with the Unity desktop. I want to turn off the very annoying global menu and put the menu back where it belongs. In Firefox there's a very convenient setting to enable or disable global menu integration. Is there anything like that in LO? BTW, I don't want to get too far off topic, but can someone explain to me why putting the menu way off on the top of the screen is better than keeping it close to the application? Am I not using it correctly? Thanks, -Bill -- 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] Integer degrees in Draw
If you are going to use 4.0.2, you will have to use these degree Integers: 0 14 29 43 57 71 and 86. I'm using 4.2.0.2/Win7 and I can type in any integer I want between 0 and 359. Right click on the line, select Position and Size then select the Rotation tab. That doesn't completely solve your problem, but it's better than the restrictions noted above. -Bill On 5/3/2013 7:14 AM, Dan Lewis wrote: On 05/03/2013 06:09 AM, robertoo...@libero.it wrote: Hi, I need to set the degrees of a line to a decimal value, like 51,43 to divide 1 turn in 7. In 4.02 I am able to input only integer values. Is it a feature or a bug, or I miss an option? Thanks, Roberto Occa. It is a feature that has been introduced in 4.0. 3.6.6 permits you to set the degree angle for a line to 100th of a degree (English system). 4.0.2 and 4.0.3 both limit the degree angle to integers. If you are going to use 4.0.2, you will have to use these degree Intergers: 0 14 29 43 5771 and 86. Not as exact as you may want but the accuracy is less that 0.5 degrees. --Dan -- For unsubscribe instructions 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 downgrade from 4.0.2. to 3.6.6
Well, I may wait for 4.0.3 and see if that fixes anything. I did check the bugs list and I don't see my specific bug mentioned, but it may manifest itself in different ways, so maybe it will be fixed in 4.0.3. The bug that makes LO 4 unusable for me is drawings no longer save when pasted into Writer (exit LO, re-open the document, and the drawings are gone). A significant amount of my work involves making drawings in LO Draw and using them in Writer documents. What I have been doing as a workaround is pasting screenshots of the drawings into Writer. Thanks for all the replies... -Bill On 4/23/2013 4:58 AM, Tom Davies wrote: Hi :) I found this link on the official website http://www.libreoffice.org/download/pre-releases/ I got there from the main website http://www.libreoffice.org/ then the trail Main website - Get involved - QA got me to http://www.libreoffice.org/get-involved/qa-testers/ Hmm, you caught me out. What i described is what i wish i did and i keep promising myself i will do next time, this time, each time but never quite get around to it. Errr, well tried the 4.0.0 fairly early but really liked it and stuck with it. I was going to hunt around the different articles published at the time to solve problems raised in their various lists of comments. A few seemed so very trivial that it made me wonder if the commenter had ever installed anything before. Sadly i didn't even get through that let alone helping with testing out listed bugs. So, this time i really have downloaded the beta. Hopefully my good intentions wont get so side-tracked this time! Regards from Tom :) From: Upscope upsc...@nwi.net To: users@global.libreoffice.org Sent: Tuesday, 23 April 2013, 1:27 snip / Do you have a link to the beta versions? I have the opensuse version of 4.0.2 with latest update (yesterday) and 4.0.2 from LibreOffice parallel installed. Both had same two major problems for me since my cleints now usually send .docx documents and I do alot of table formatting with the number formatting columns, some of it doesn't work again. If I could get a hold of 4.0.3 and if it still has the problems I'll report them again as bugs. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6
The problem is solved. I increased memory as was suggested and that fixed it. The strange thing is, I reverted back to the old memory settings and it's still fixed. Don't know why. There was a Windows update this evening. I wonder if that had anything to do with it and it wasn't a LO issue at all? -Bill On 4/23/2013 4:50 PM, Upscope wrote: On Tuesday, April 23, 2013 08:10:49 PM Tom Davies wrote: Hi :) Steve! I think that was the trick the Docs Team mentioned! Turn off the auto-back-ups and stuff. Just remember to save often and make your own back-ups. Regards from Tom :) Turned off everything on the options/load-save/general page, still no help. From: Steve Edmonds steve.edmo...@ptglobal.com To: William Drago wdr...@gmail.com Cc: users@global.libreoffice.org Sent: Tuesday, 23 April 2013, 19:58 Subject: Re: [libreoffice-users] How to downgrade from 4.0.2. to 3.6.6 Hi. I have had this with EPS drawings (with/without preview) for a long time. For those to not cause a problem I turn off OptionsLoad/SaveGeneralSave auto recovery information. Just a suggestion, you could give it a try. Steve On 2013-04-23 22:21, William Drago wrote: Well, I may wait for 4.0.3 and see if that fixes anything. I did check the bugs list and I don't see my specific bug mentioned, but it may manifest itself in different ways, so maybe it will be fixed in 4.0.3. The bug that makes LO 4 unusable for me is drawings no longer save when pasted into Writer (exit LO, re-open the document, and the drawings are gone). A significant amount of my work involves making drawings in LO Draw and using them in Writer documents. What I have been doing as a workaround is pasting screenshots of the drawings into Writer. Thanks for all the replies... -Bill On 4/23/2013 4:58 AM, Tom Davies wrote: Hi :) I found this link on the official website http://www.libreoffice.org/download/pre-releases/ I got there from the main website http://www.libreoffice.org/ then the trail Main website - Get involved - QA got me to http://www.libreoffice.org/get-involved/qa-testers/ Hmm, you caught me out. What i described is what i wish i did and i keep promising myself i will do next time, this time, each time but never quite get around to it. Errr, well tried the 4.0.0 fairly early but really liked it and stuck with it. I was going to hunt around the different articles published at the time to solve problems raised in their various lists of comments. A few seemed so very trivial that it made me wonder if the commenter had ever installed anything before. Sadly i didn't even get through that let alone helping with testing out listed bugs. So, this time i really have downloaded the beta. Hopefully my good intentions wont get so side-tracked this time! Regards from Tom :) From: Upscope upsc...@nwi.net To: users@global.libreoffice.org Sent: Tuesday, 23 April 2013, 1:27 snip / Do you have a link to the beta versions? I have the opensuse version of 4.0.2 with latest update (yesterday) and 4.0.2 from LibreOffice parallel installed. Both had same two major problems for me since my cleints now usually send .docx documents and I do alot of table formatting with the number formatting columns, some of it doesn't work again. If I could get a hold of 4.0.3 and if it still has the problems I'll report them again as bugs. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe / Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] How to downgrade from 4.0.2. to 3.6.6
All, While I appreciate the tremendous amount of work that has gone into LO 4, it's still a little too buggy for me and I'd like to go back to LO 3.6.6. Is it a simple matter of uninstalling 4 and re-installing 3? (I'm running Windows 7). Thanks, Bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc does not remember formatting
Renaming (or deleting) my profile does not fix the problem. Thanks for the suggestion though. -Bill On 4/15/2013 7:07 PM, Tom Davies wrote: Hi :) That all sounds horribly wrong, except for the odd 1 part where it does actually work. Can you try renaming your User Profile to see if that fixes that problem? Regards from Tom :) *From:* William Drago wdr...@gmail.com *To:* users@global.libreoffice.org *Sent:* Sunday, 14 April 2013, 11:48 *Subject:* [libreoffice-users] Calc does not remember formatting All, I am using LO 4.0.2.2 on Windows 7. In Calc when I format cells so that negative numbers are red they won't be red next time I open the spreadsheet. The only way to make them red again is to recalculate those cells. Of course, when I save and re-open the spreadsheet the formatting is gone again. Thanks, -Bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org mailto:h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc does not remember formatting
All, I am using LO 4.0.2.2 on Windows 7. In Calc when I format cells so that negative numbers are red they won't be red next time I open the spreadsheet. The only way to make them red again is to recalculate those cells. Of course, when I save and re-open the spreadsheet the formatting is gone again. Thanks, -Bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Strange fonts on my Windows system
All, I have a bunch of fonts on my Windows system that have weird names like cmbx6 Regular, cmdunh10 Regular, cmsltt10 Regular... Did these come with LibreOffice and if so what are they for? Also, why such cryptic names? Thanks, Bill -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted