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

[office76#xt]

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

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

[Jim Byrnes]

Couple of questions about opening LibreOffice 3.5 worksheets from the 
terminal in Ubuntu 12.04


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.


2.  If I solve [1] will error messages appear in the terminal? I am 
working with some python macros and would like better access to python 
error messages.  I got the impression from some messages I read on the 
net that the error messages would appear in the terminal if the work 
sheet was started from the terminal.  So far when I get an new sheet to 
open from the terminal, it immediately reverts back to the prompt so no 
error message would appear.


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

Re: [libreoffice-users] Footnotes

[Tom Davies]

Hi :)
I thought Zotero was often used as an Extension/Add-on/Plug-in to improve
the handling of this sort of thing?  The default one included in
LibreOffice is more than good enough for me but uni students and others
might benefit from adding in a specialist tool such as Zotero
Regards from
Tom :)




On 8 September 2014 17:50, Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net> wrote:

> Hi Brian,
>
> Le 08/09/2014 13:43, Brian Barker a écrit :
> >
> > I'm not sure a note that doesn't relate to any point in the text makes
> > sense, but ...
>
> neither am I
>
> >
> > You may have to tinker with spacing in the footnote itself. And I don't
> > guarantee what will happen to the automatic numbering of any other
> > footnotes: you may have to resort to manual numbering of those.
>
> Very clever! I've tested this hint and it works very nicely (I've added
> the DT autotext for testing the footnote contents). The other footnotes
> numbering stays normal. Great hint! Thanks a lot!
>
> --
> Jean-Francois Nifenecker, Bordeaux
>
> --
> 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] Generate a column of times

[Paul D. Mirowsky]

If on windows, suggest looking at http://realterm.sourceforge.net/

Linux: Realterm has been tested with Wine  1.0, Opensuse 11.0, Realterm 
2.0.0.62.

A cursory test with Com1, running as root, was successful.

Realterm is a terminal program specially designed for capturing, 
controlling and debugging binary and other difficult data streams.


See command :
TIMESTAMP   

0-4



During capture, Prepends a timestamp to each line. Only works in text 
files with EOL



Good luck

On 9/8/2014 11:54 AM, office76#xt wrote:

Hi,
Imagine you've collected samples from a data acquisition device, and
know the time you started taking samples (12:04 pm), and when you stopped
(12:36 pm). You'd end up with two columns of data like this:

12.7 12:04 pm
8.9
3.5
2.1
7.2
6.1   12:36 pm

My question is, is there a way to generate the intermediate time values in
the second column?



--
View this message in context: 
http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568.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] Generate a column of times

[Brian Barker]

At 08:54 08/09/2014 -0700, Nobody Noname wrote:
Imagine you've collected samples from a data acquisition device, and 
know the time you started taking samples (12:04 pm), and when you 
stopped (12:36 pm). You'd end up with two columns of data like this:


12.7 12:04 pm
8.9
3.5
2.1
7.2
6.1   12:36 pm

My question is, is there a way to generate the intermediate time 
values in the second column?


No - simply because the samples may well have been taken at irregular 
intervals!


If you mean that we are to suppose that the intervals were regular, 
let's suppose that these values are in cells A1:B6. In B2, enter:

=B1+(B$6-B$1)/5
and fill this down to B5. Note that your times may need to be proper 
times (numbers formatted as times) and not text values for this to 
work. If the number of samples is itself to be variable, you could 
develop a more complicated formula that would count the items and not 
have the "5" hard-coded in it.


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] Footnotes

[Jean-Francois Nifenecker]

Hi Brian,

Le 08/09/2014 13:43, Brian Barker a écrit :
> 
> I'm not sure a note that doesn't relate to any point in the text makes
> sense, but ...

neither am I

> 
> You may have to tinker with spacing in the footnote itself. And I don't
> guarantee what will happen to the automatic numbering of any other
> footnotes: you may have to resort to manual numbering of those.

Very clever! I've tested this hint and it works very nicely (I've added
the DT autotext for testing the footnote contents). The other footnotes
numbering stays normal. Great hint! Thanks a lot!

-- 
Jean-Francois Nifenecker, Bordeaux

-- 
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] Generate a column of times

[office76#xt]

Hi,
   Imagine you've collected samples from a data acquisition device, and
know the time you started taking samples (12:04 pm), and when you stopped
(12:36 pm). You'd end up with two columns of data like this:

12.7 12:04 pm
8.9
3.5
2.1
7.2
6.1   12:36 pm

My question is, is there a way to generate the intermediate time values in
the second column? 



--
View this message in context: 
http://nabble.documentfoundation.org/Generate-a-column-of-times-tp4121568.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] Cross References To Page# Do Not Render

[Adam Tauno Williams]

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  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] Footnotes

[Brian Barker]

At 16:44 08/09/2014 +1200, Steve Edmonds wrote:
How do I add a footnote when it doesn't have a reference. I have 
some footnotes with and some without references (anchors).


I'm not sure a note that doesn't relate to any point in the text 
makes sense, but ...
o At some suitable (random?) place in the text, go to Insert 
Footnote/Endnote... .

o Select Footnote and Character.
o Click the "..." button.
o Select a suitable font, so that you can find U+200B, the "zero-width space".
o Click OK and OK.
o Enter your footnote text.

You may have to tinker with spacing in the footnote itself. And I 
don't guarantee what will happen to the automatic numbering of any 
other footnotes: you may have to resort to manual numbering of those.


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] Re: Footnotes

[Owen Genat]

steveedmonds wrote
> How do I add a footnote when it doesn't have a reference.
> I have some footnotes with and some without references (anchors).

Please clarify, with an example, exactly what is meant by "doesn't have a
reference" and "without references (anchors)" as this is not clear.
Footnotes consist of:

- Anchor (identifier in-line in the text, styled by the Footnote Anchor
character style).
- Identifier (in the footnote area, styled by the Foonote Characters
character style).
- Text (in the footnote area, styled by the Footnote paragraph style).

By way of example, do you mean you have a situation (e.g., natural sciences
referencing) where anchors can be specified as "2-4" in the text (i.e., some
anchors need to be hidden) but all three footnotes (identifier and text) are
shown in the footnote area? If so, this is reported as:

https://bugs.freedesktop.org/show_bug.cgi?id=54393

Best wishes, Owen.



--
View this message in context: 
http://nabble.documentfoundation.org/Footnotes-tp4121515p4121546.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] Writer auto indenting?

[Tom Davies]

Hi :)
I think the easy answer is, put a tab (and the extra space?) in front of
the 1st line;
"
 This is my first line of typing. 
 Type another line. 
Now I want this line to begin at the same place as the previous line, at
the "T" in the word "Type".
"

This is not going against what Brian was saying, just cutting it down to
the specific use-case asked about.
Regards from
Tom :)



On 8 September 2014 04:53, Steve Edmonds  wrote:

> I too say it's not a stupid question. The behaviour you describe is
> exactly the way my text editor performs when I am writing scripts, it is
> quite normal in some situations. LO makes the process a little more
> sophisticated and gives you many more options.
> Steve
>
>
> On 2014-09-08 14:47, lo-u...@jevb.tuffmail.com wrote:
>
>> Thank you, Brian. I stand duly chastised. I'll try to not ask any more
>> stupid questions when I'm frustrated.
>>
>>
>>
>>> The solution to "getting all mixed up" is to learn how to use the
>>> facilities properly, so you are not "mixed up" - not to dismiss the
>>> facilities that the product provides.
>>>
>>
>>
>>> No: you don't want any tabs (unless you are using a typewriter); you
>>> want persistent indentations.
>>>
>>>
>>
>>> 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
>

-- 
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