[libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Nino Novak
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

Re: [libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Tom Davies
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Brian Barker
At 17:29 08/09/2014 -0700, Nobody Noname wrote: The data acquisition device samples at approximately 1 sample per second not a nice fixed sample rate. That's odd, as your example had them over six minutes apart. If the sample values are in column A1, ... Hold on: A1 is a cell, not a

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread William Drago
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.

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Brian Barker
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 -

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread William Drago
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

Re: [libreoffice-users] Cross References To Page# Do Not Render

2014-09-09 Thread Tom Davies
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Brian Barker
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

Re: [libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Kevin O'Brien
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

[libreoffice-users] [HELP] Send Mail With LO - AppCrash

2014-09-09 Thread Luckshor
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

[libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread dave boland
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

[libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Jim Byrnes
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

[libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Jim Byrnes
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Tom Davies
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

[Solved] Re: [libreoffice-users] Re: Opening worksheets from the terminal in linux?

2014-09-09 Thread Tom Davies
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread Tom Davies
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.

[libreoffice-users] Styles Don't Retain Bold?

2014-09-09 Thread Joel Madero
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?

Re: [libreoffice-users] Styles Don't Retain Bold?

2014-09-09 Thread Kevin O'Brien
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread Paul
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread Regina Henschel
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

Re: [libreoffice-users] [HELP] Send Mail With LO - AppCrash

2014-09-09 Thread anne-ology
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

Re: [libreoffice-users] Cross References To Page# Do Not Render

2014-09-09 Thread Adam Tauno Williams
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread Brian Barker
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread dave boland
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

Re: [libreoffice-users] Finding hidden Draw objects

2014-09-09 Thread Brian Barker
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,

[libreoffice-users] Re: Generate a column of times

2014-09-09 Thread office76#xt
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Brian Barker
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Steve Edmonds
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

Re: [libreoffice-users] Re: Generate a column of times

2014-09-09 Thread Brian Barker
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