[libreoffice-users] Re: Opening worksheets from the terminal in linux?
Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) Nino -- 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: Opening worksheets from the terminal in linux?
Hi :) I think some of the parameters of the problem weren't clear. A default spreadsheet file normally has 3 sheets. Is it possible to select which of the 3 gets opened? I think that is what the o.p. meant. Err, i usually delete any sheets that i'm not using so that when i open an ancient file i don't have to faff around trying to see if i hid anything on one of the other 2 sheets. This might be a work-around for the o.p. because then each file would only have 1 sheet and hopefully that would be the one opened by default - but it'd probably be annoying. I sometimes find i have to add extra sheets, such as 1 per month or per quarter and breaking those out into separate files would be annoying. Also i tend to find the i don't need to include the path to soffice but do need the path to the file (unless i'm already in the correct folder). So for me it's more like soffice path-name/file-name Regards from Tom :) On 9 September 2014 09:19, Nino Novak nn.l...@kflog.org wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) Nino -- 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] 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
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. 22 divided by 5 (always the total number of readings minus 1) = 6.4 minutes or 6m and 24s per interval. Good: but only as long as it's 32, not 22, we are dividing. 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. Why do a manual calculation for the first value (where you could easily make mistakes - oh, you did!) and only then make the computer do the work? The computer can do all the work. 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? But chacun à son goût! 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] 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] Cross References To Page# Do Not Render
Hi :) If something suddenly starts happening that didn't happen before then it's worth renaming the User Profile to see if soemthing went wonky with that. https://wiki.documentfoundation.org/UserProfile If it doesn't seem to do anything then it might be worth renaming it back over the auto-generated one to make sure you get back all your normal settings and tweaks. Again it might be worth looking into using Zotero as an Extension/Add-on/Plugin (actually it's an independent project that can be plugged into MS Office AND LibreOffice/OpenOffice and maybe others too) since you also seem to be pushing the default one further than most of us. Regards from Tom :) On 8 September 2014 14:52, Adam Tauno Williams awill...@whitemice.org wrote: Version 4.1.6.2 Build ID 410m0(Build:2) I have a large multi-document document that contains many cross references. This has always worked. Recently however references to Page to no work. They render as empty. The area is still `hot` and jumps to the related section but nothing displays but the gray hot area, no page#. Cross references to Reference display the Reference text, but references to Page# display nothing. So I have, for example, text that reads '''(see Wiki, pg.)''' where both Wiki and the missing number after pg. references a section of the document. I test the cross references by exporting the master document to a ODT which combines all the documents into one - and thus makes the cross-document cross-references work. -- Adam Tauno Williams mailto:awill...@whitemice.org GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- 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] Re: Generate a column of times
At 07:22 09/09/2014 -0400, William Drago wrote: 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. And I had - *of course* - no problem with that. 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. My only quibble was that you presented it as what I was trying to say - which wasn't so. Sorry if I gave any impression of being dismissive. This is a discussion list, after all. I merely offered an alternative to someone who was struggling. Splendid! And exactly why I offered my approval by finishing chacun à son goût. 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] Re: Opening worksheets from the terminal in linux?
I go one step further and change my default to only have one sheet in any new file. I can always add more as needed, but most of the time I don't need to add anything. Regards, On Tue, Sep 9, 2014 at 5:23 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I think some of the parameters of the problem weren't clear. A default spreadsheet file normally has 3 sheets. Is it possible to select which of the 3 gets opened? I think that is what the o.p. meant. Err, i usually delete any sheets that i'm not using so that when i open an ancient file i don't have to faff around trying to see if i hid anything on one of the other 2 sheets. This might be a work-around for the o.p. because then each file would only have 1 sheet and hopefully that would be the one opened by default - but it'd probably be annoying. I sometimes find i have to add extra sheets, such as 1 per month or per quarter and breaking those out into separate files would be annoying. Also i tend to find the i don't need to include the path to soffice but do need the path to the file (unless i'm already in the correct folder). So for me it's more like soffice path-name/file-name Regards from Tom :) On 9 September 2014 09:19, Nino Novak nn.l...@kflog.org wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) Nino -- 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 -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] [HELP] Send Mail With LO - AppCrash
Hello everyone again :DI've got a problem when trying to send email with the LO.I want to send in PDF format to send when I go confirm it closes the program.Stating that the SendDoc.exe stopped working.does anyone know what might be happening?I need to configure something in the LO to be sending the email?I'm using version 4.3.1.2 on WIN7.Thanks again. -- View this message in context: http://nabble.documentfoundation.org/HELP-Send-Mail-With-LO-AppCrash-tp4121663.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] Finding hidden Draw objects
All, I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. Thanks, Dave -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Send your email first class -- 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: Opening worksheets from the terminal in linux?
On 09/09/2014 03:19 AM, Nino Novak wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? It was me not including the path that caused the problem. localc [path to]/file1.ods works. 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) If I use the correct path then when the file opens I do not get the prompt back. I haven't had a chance to see if error messages appear in the terminal. Nino Thanks, Jim -- 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: Opening worksheets from the terminal in linux?
On 09/09/2014 04:23 AM, Tom Davies wrote: Hi :) I think some of the parameters of the problem weren't clear. A default spreadsheet file normally has 3 sheets. Is it possible to select which of the 3 gets opened? I think that is what the o.p. meant. Err, i usually delete any sheets that i'm not using so that when i open an ancient file i don't have to faff around trying to see if i hid anything on one of the other 2 sheets. This might be a work-around for the o.p. because then each file would only have 1 sheet and hopefully that would be the one opened by default - but it'd probably be annoying. I sometimes find i have to add extra sheets, such as 1 per month or per quarter and breaking those out into separate files would be annoying. Also i tend to find the i don't need to include the path to soffice but do need the path to the file (unless i'm already in the correct folder). So for me it's more like soffice path-name/file-name Regards from Tom :) Yeah, my bad. I should have been taking about somefile.ods not sheets and workbooks. See my reply to Nino. Thanks, Jim On 9 September 2014 09:19, Nino Novak nn.l...@kflog.org wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) Nino -- 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] Re: Generate a column of times
Hi :) I thought it was really kind to de-geekify Brain's answer. The tpyo was unfortunate but these things happen [shrugs]. The main thing, for me, was that i could then go back to Brian's answer and understand it more easily. Thanks and regards from Tom :) On 9 September 2014 12:22, William Drago wdr...@suffolk.lib.ny.us wrote: 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[Solved] Re: [libreoffice-users] Re: Opening worksheets from the terminal in linux?
Hi :) Congrats!! :)) There is no bad. Often problems are mainly made of trying to figure out what the actual problem is. Once it's clear exactly what the problem is the answer is often immediately obvious. It's trying to figure out the right question in the first place that is the real challenge. All posts to the list go to everyone on the list so you only really needed to post once. So i am replying to the important part of the reply and ignoring the rabbit-hole. Regards from Tom :) On 9 September 2014 15:45, Jim Byrnes jf_byr...@comcast.net wrote: On 09/09/2014 03:19 AM, Nino Novak wrote: Hi Jim, Am 09.09.2014 03:51, schrieb Jim Byrnes: 1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message. just a simple [path_to]/soffice file1.ods works fine here (4.3.1/SUSE) What error message do you get? It was me not including the path that caused the problem. localc [path to]/file1.ods works. 2. If I solve [1] will error messages appear in the terminal? (I suppose so - but don't know really, so someone else has to help you) If I use the correct path then when the file opens I do not get the prompt back. I haven't had a chance to see if error messages appear in the terminal. Nino Thanks, Jim -- 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] Finding hidden Draw objects
Hi :) Perhaps; 1. create a copy of the file 2. rename the file-ending from .ods to .zip 3. open with an archive-manager (on GnuLinux you might be able to skip step 2 but if not then just double-clicking on the .zip should open it) 4. inside the zipfile is a folder called something like images. 5. open each image in turn until you find the bad ones and delete them 6. rename the file-ending from .zip to .ods 7. does the file still open or does it crash or not open at all? Sorry this answer is a bit of a painful route and totally inelegant! Regards from Tom :) On 9 September 2014 14:58, dave boland dbola...@fastmail.fm wrote: All, I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. Thanks, Dave -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Send your email first class -- 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] Styles Don't Retain Bold?
Hi All, Quick question. Are styles supposed to retain properties like bold. I am consistently getting mixed results using styles. I can provide an example if need be. 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] Styles Don't Retain Bold?
Well, styles are over-ridden by manual formatting, for one. So if a Style specifies a bold font, but you click a button to turn it off, it should go off. Regards, On Tue, Sep 9, 2014 at 4:17 PM, Joel Madero jmadero@gmail.com wrote: Hi All, Quick question. Are styles supposed to retain properties like bold. I am consistently getting mixed results using styles. I can provide an example if need be. 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 -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- 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] Finding hidden Draw objects
Try this: * Open Navigator (F5) * This should show the Navigator, with a list of slides, but no objects in the slides (or at least, only named objects). * Click on the far right tool button (with Show Shapes as the tooltip) * This should open a drop down menu with the options Named shapes and All shapes * Select All shapes * Now the list of slides should have small plus signs next to them, and expanding them should show all drawing objects in the slide. * I'll note that neither right-clicking nor double-clicking them actually does anything, but at least you can see that they are there. This seems far easier, and is, I think, what you want to know. Although if it doesn't show everything, Tom's way will be more complete. If you find things you aren't sure about, you may have to make a copy of the file, and go through the copy, deleting or naming everything, until you find the offending item or items, but if you're first going to all that trouble, Navigator isn't really necessary in the first place, so I guess a feature request should be filed to give a right-click menu to Navigator allowing at the very least a bring to front option. Paul On Tue, 9 Sep 2014 19:56:14 +0100 Tom Davies tomc...@gmail.com wrote: Hi :) Perhaps; 1. create a copy of the file 2. rename the file-ending from .ods to .zip 3. open with an archive-manager (on GnuLinux you might be able to skip step 2 but if not then just double-clicking on the .zip should open it) 4. inside the zipfile is a folder called something like images. 5. open each image in turn until you find the bad ones and delete them 6. rename the file-ending from .zip to .ods 7. does the file still open or does it crash or not open at all? Sorry this answer is a bit of a painful route and totally inelegant! Regards from Tom :) On 9 September 2014 14:58, dave boland dbola...@fastmail.fm wrote: All, I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. Thanks, Dave -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Send your email first class -- 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] Finding hidden Draw objects
Hi Dave, dave boland schrieb: All, I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. You can use the tab key to traverse all drawing objects, hidden or not. They will become active with green handles one by one. But make sure all layers are visible. If a layer is not visible, you cannot access its objects. If they are invisible because they are transparent, then select all should work. You can make a copy of the file, select all and assign an alarming background and line color. If you get some new objects, you knew where to search in your original file. You can use the Navigator. It has an icon to make it show objects too, which are not named. If you name all your real drawing objects, then the other faulty objects will be listed as Shape with a number. Unfortunately you cannot select them in the Navigator. But you can see, whether such objects exist. If you work with an editor directly on the file, then you can identify them, because they have no draw:name attribute. Custom shapes produce currently two additonal zero size points in PDF export (bug report exists). If your problem has its reason in that bug, you should export to PDF in Apache OpenOffice and look whether you get better results. 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] [HELP] Send Mail With LO - AppCrash
Possible suggestions - have you cleared the cache recently? if you have, then ... how large is the file you're attempting to send? - could it be too large to send via e-mail?; if so, upload to DropBox - or another of these clouds' - then send the URL to the file in the e-message. Hoping this helps, From: Luckshor diego.si...@admceos.com.br Date: Tue, Sep 9, 2014 at 8:05 AM Subject: [libreoffice-users] [HELP] Send Mail With LO - AppCrash To: users@global.libreoffice.org Hello everyone again :D I've got a problem when trying to send email with the LO. I want to send in PDF format to send when I go confirm it closes the program. Stating that the SendDoc.exe stopped working. does anyone know what might be happening? I need to configure something in the LO to be sending the email? I'm using version 4.3.1.2 on WIN7.Thanks again. -- 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] Cross References To Page# Do Not Render
On Tue, 2014-09-09 at 12:38 +0100, Tom Davies wrote: If something suddenly starts happening that didn't happen before then it's worth renaming the User Profile to see if soemthing went wonky with that. https://wiki.documentfoundation.org/UserProfile If it doesn't seem to do anything then it might be worth renaming it back over the auto-generated one to make sure you get back all your normal settings and tweaks. I'll try that. Again it might be worth looking into using Zotero as an Extension/Add-on/Plugin (actually it's an independent project that can be plugged into MS Office AND LibreOffice/OpenOffice and maybe others too) since you also seem to be pushing the default one further than most of us. I do not see how Zotero is relevant to what I am doing. I am maintaining a large hundreds-of-pages technical document which I occasionally release as a PDF. The support for Master Documents in OpenOffice/LibreOffice make this feasible, especially in addition to the Stylist. But cross-references are a bit of a pain, as I can see the references in the Navigator one cannot 'use' them, out-of-document cross references have to be manually keyed into. That works once the document is exported as a single document, but now there is the issue with the reference just not rendering. It is hard to believe I am the only one using LibreOffice in this way - as this is the point of a full-featured office suite, to ease the create and maintenance of 'real' documents. Version 4.1.6.2 Build ID 410m0(Build:2) I have a large multi-document document that contains many cross references. This has always worked. Recently however references to Page to no work. They render as empty. The area is still `hot` and jumps to the related section but nothing displays but the gray hot area, no page#. Cross references to Reference display the Reference text, but references to Page# display nothing. So I have, for example, text that reads '''(see Wiki, pg.)''' where both Wiki and the missing number after pg. references a section of the document. I test the cross references by exporting the master document to a ODT which combines all the documents into one - and thus makes the cross-document cross-references work. -- Adam Tauno Williams mailto:awill...@whitemice.org GPG D95ED383 Systems Administrator, Python Developer, LPI / NCLA -- 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] Finding hidden Draw objects
At 19:56 09/09/2014 +0100, Tom Davies wrote: On 9 September 2014 14:58, Dave Boland wrote: I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. Perhaps; 1. create a copy of the file 2. rename the file-ending from .ods to .zip 3. open with an archive-manager (on GnuLinux you might be able to skip step 2 but if not then just double-clicking on the .zip should open it) 4. inside the zipfile is a folder called something like images. 5. open each image in turn until you find the bad ones and delete them But these are (presumably) Draw objects, not images. 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] Finding hidden Draw objects
All, Thanks for the ideas. Unfortunately none of the ideas revealed the extranous line that ended up in the pdf file. I like the idea of the Navigator, but as is, it is worthless. What needs to happen is that when an object is clicked in Navigator, it is selected in the editor so it can be seen. A description would also be nice (name if available, shape, location, size). Of course there is also the possibility that the pdf conversion process is flawed and that the extranous line does not really exist. Dave, On Tue, Sep 9, 2014, at 07:39 PM, Brian Barker wrote: At 19:56 09/09/2014 +0100, Tom Davies wrote: On 9 September 2014 14:58, Dave Boland wrote: I did a drawing using Draw, then exported to PDF. The PDF had some extraneous objects in it, so I was trying to figure out where they came from. The first step is to see if there are any objects that are hidden (behind something else, or a color the same as the background, etc.) in the source drawing. How do I do that? Select All doesn't seem to help. Perhaps; 1. create a copy of the file 2. rename the file-ending from .ods to .zip 3. open with an archive-manager (on GnuLinux you might be able to skip step 2 but if not then just double-clicking on the .zip should open it) 4. inside the zipfile is a folder called something like images. 5. open each image in turn until you find the bad ones and delete them But these are (presumably) Draw objects, not images. 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 -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - One of many happy users: http://www.fastmail.fm/help/overview_quotes.html -- 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] Finding hidden Draw objects
At 22:32 09/09/2014 -0400, Dave Boland wrote: I like the idea of the Navigator, but as is, it is worthless. What needs to happen is that when an object is clicked in Navigator, it is selected in the editor so it can be seen. A description would also be nice (name if available, shape, location, size). The name is one thing you can have. Select a Draw object. Go to Modify | Name... (or right-click | Name...) and set a name there. Names will then appear in the Navigator. 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] Re: Generate a column of times
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
At 17:22 09/09/2014 -0700, Nobody Noname wrote: My earlier example was a simplified version of the data I'm working with. When Brian Wdragos technique ... They were not one technique but two different ones, in fact. ... 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. My formula technique will get it right for you. Mr Drago's will also, provided you do his initial manual calculation correctly. If your calculation only comes pretty close, you must be getting something wrong. The reason for this is there's a limit to the precision you can do with Times in OpenOffice Calc. There is always a limit to precision in anything, but this will not create the problems you describe. (My formula technique is probably less prone to rounding errors than Mr Drago's repeated addition method.) There is no reason for any reasonable length of data sequence that you should notice any rounding errors. 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. You can format times to show fractions of a second; the normal precision of numbers in a Calc spreadsheet means that you can represent times down to around ten fractional places of a second! But in any case, you are here confusing formatting with the precision of a number: values are stored to full precision in a cell even if your cell formatting restricts the display - as it usually will. If you have a long list of samples, you will need to do Mr Drago's initial manual calculation to a greater significance than your cell formatting will perhaps show, or any errors will add up and eventually show in your list. My formula technique will not suffer the same problem. By the way, there is an option at Tools | Options... | LibreOffice Calc | Calculate | Precision as shown. That causes any calculation to be performed on the rounded value displayed in any cell instead of the actual (potentially more accurate) value actually stored in the cell. Having that ticked would certainly cause rounding errors in Mr Drago's technique, so you want to have that *not* ticked for normal spreadsheet use. In Calc there's a time format that looks like this, but in practice it doesn't 'roll over' like say minutes or seconds. Three points here: o The formats listed are just samples; you can have more fractional places displayed simply by adding more zeroes to the format code. o The formats don't affect the calculation, only the display in each cell (providing you don't have that option above ticked). o I'm not sure how you think things don't roll over, but accumulated fractions of seconds will certainly become seconds, minutes and even hours when they need to. It looks like Calc's stock functions won't do the job. Believe me: my formula works. Mr Drago's does, providing you don't round the initial result too much. You are welcome to give up trying, but please don't blame Calc: of course it will do the job. I'm thinking of getting around this by finding some source for a stopwatch program, and maybe modifying it to do something similar, but with a greater precision of incrementation. You have about fifteen significant decimal digits in spreadsheet calculations: that is enough for almost anything, providing you don't introduce errors yourself. Why don't you get someone to look at your spreadsheet (or a sample copy, showing the problem) to see where you are going wrong? 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] Re: Generate a column of times
Hi. I think the trick is to not calculate the difference/no. samples and keep adding but to calculate the difference and multiply by position over number of samples added to start time. For a quick test this seems to give times to 0.00 of a second and the finish time is always the finish time exactly. i.e. for the 29th reading of 54 readings taken between 12:04 aqnd 12:36 the time is 12:04+28/53*(12:36-12:04) Got to dash to beat the traffic, but can post the formula when I'm home. Steve . On 2014-09-10 16:32, Brian Barker wrote: At 17:22 09/09/2014 -0700, Nobody Noname wrote: My earlier example was a simplified version of the data I'm working with. When Brian Wdragos technique ... They were not one technique but two different ones, in fact. ... 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. My formula technique will get it right for you. Mr Drago's will also, provided you do his initial manual calculation correctly. If your calculation only comes pretty close, you must be getting something wrong. The reason for this is there's a limit to the precision you can do with Times in OpenOffice Calc. There is always a limit to precision in anything, but this will not create the problems you describe. (My formula technique is probably less prone to rounding errors than Mr Drago's repeated addition method.) There is no reason for any reasonable length of data sequence that you should notice any rounding errors. 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. You can format times to show fractions of a second; the normal precision of numbers in a Calc spreadsheet means that you can represent times down to around ten fractional places of a second! But in any case, you are here confusing formatting with the precision of a number: values are stored to full precision in a cell even if your cell formatting restricts the display - as it usually will. If you have a long list of samples, you will need to do Mr Drago's initial manual calculation to a greater significance than your cell formatting will perhaps show, or any errors will add up and eventually show in your list. My formula technique will not suffer the same problem. By the way, there is an option at Tools | Options... | LibreOffice Calc | Calculate | Precision as shown. That causes any calculation to be performed on the rounded value displayed in any cell instead of the actual (potentially more accurate) value actually stored in the cell. Having that ticked would certainly cause rounding errors in Mr Drago's technique, so you want to have that *not* ticked for normal spreadsheet use. In Calc there's a time format that looks like this, but in practice it doesn't 'roll over' like say minutes or seconds. Three points here: o The formats listed are just samples; you can have more fractional places displayed simply by adding more zeroes to the format code. o The formats don't affect the calculation, only the display in each cell (providing you don't have that option above ticked). o I'm not sure how you think things don't roll over, but accumulated fractions of seconds will certainly become seconds, minutes and even hours when they need to. It looks like Calc's stock functions won't do the job. Believe me: my formula works. Mr Drago's does, providing you don't round the initial result too much. You are welcome to give up trying, but please don't blame Calc: of course it will do the job. I'm thinking of getting around this by finding some source for a stopwatch program, and maybe modifying it to do something similar, but with a greater precision of incrementation. You have about fifteen significant decimal digits in spreadsheet calculations: that is enough for almost anything, providing you don't introduce errors yourself. Why don't you get someone to look at your spreadsheet (or a sample copy, showing the problem) to see where you are going wrong? 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] Re: Generate a column of times
At 16:58 10/09/2014 +1200, Steve Edmonds wrote: I think the trick is to not calculate the difference/no. samples and keep adding but to calculate the difference and multiply by position over number of samples added to start time. For the avoidance of doubt, you will see that this is what my original suggestion (two days ago) does. For a quick test this seems to give times to 0.00 of a second ... No, it gives times to about *ten* fractional places of a second (0.00), but it may well *display* with less precision - depending on your cell formatting. This is one of the original questioner's misunderstandings. Got to dash to beat the traffic, but can post the formula when I'm home. Or see my original reply: In B2, enter: =B1+(B$6-B$1)/5 and fill this down to B5! 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