[libreoffice-users] animation in an impress documennt

2012-06-29 Thread Eric S. Johansson
https://docs.google.com/document/d/1In11apApKozw_UOPAhVz0ePqns72_6652Dra34xWp4E/edit if you look at this document here (yes yes it's Google docs. It was easiest way to share and get comments from others) you'll see I'm trying to describe a different approach to speech driven programming. What I

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Ken Springer
On 6/28/12 11:42 PM, Andreas Säger wrote: Hi, Like any other programming language Calc can nest functions as far as the data types of the incoming parameters match the data types of the nested function results. The details are mostly the same as with any other spreadsheet program of the past 30

[libreoffice-users] stubborn macro security

2012-06-29 Thread Girvin R. Herr
Greetings, I am trying to run the macro from the LibreOffice 3.4 Writer Guide, page 293, "Note: To re-enable updating from a template:". However, every time I try to run it, I get a security message saying I can't do that. I even used the Tools -> Options -> Security -> Macro Security... -> L

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Ken Springer
On 6/28/12 3:38 AM, Dan wrote: Ken Springer wrote: On 6/27/12 7:57 PM, Dan wrote: Ken Springer wrote: On 6/27/12 5:48 PM, Dan wrote: Ken Springer wrote: Is there a more detailed set of examples of using the functions anywhere? The Help Files have a general outline of each, but only very gen

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Ken Springer
Hi, Tom, On 6/28/12 3:29 AM, Tom Davies wrote: This link has the guides but also has links to 3rd party documentation and stuff https://wiki.documentfoundation.org/Documentation/Publications The official guides are uploaded there before officially released on the website and individual chapters

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 28.06.2012 02:43, Jay Lozier wrote: Generally you can nest functions several levels deep in any spreadsheet. Typically the maximum is 7 levels but I would not go beyond about 3 because it becomes to difficult to follow the logic. You could have something like =if( (x or y), if( (a and b), sum

Re: [libreoffice-users] About libreoffice 3.5.4 calc

2012-06-29 Thread webmaster-Kracked_P_P
On 06/29/2012 08:54 AM, qiufucheng20 wrote: Hi, I have a problem about calc: When I use "copy" to copy something ,and use "paste" to do it ,sometimes I can't use "paste". But After I saved the file to 123.ods , I open it again .The problem runs normally,Why? OS: Windows XP You might want to c

[libreoffice-users] About libreoffice 3.5.4 calc

2012-06-29 Thread qiufucheng20
Hi, I have a problem about calc: When I use "copy" to copy something ,and use "paste" to do it ,sometimes I can't use "paste". But After I saved the file to 123.ods , I open it again .The problem runs normally,Why? OS: Windows XP -- For unsubscribe instructions e-mail to: users+h...@global.lib

Re: [libreoffice-users] Re: Question about Calc

2012-06-29 Thread Ian Whitfield
Thanks Brian and Andries (and Tom) for helping out. With your help, (and it being a fresh day), we have cracked it!! The Syntax I have used - and works fine is... '=INDIRECT("SheetName.$ROW"&<$cell $ref>)' Using INDIRECT converted it from a text string, the SheetName and ROW have to b

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 10:49, webmaster-Kracked_P_P wrote: Is there a place where users can "drop off" a description on how to do something that is not explained in the current documentation? The current docs are "guides" and not "how-to" books. For me, "how-to" books are more example driven where there

[libreoffice-users] Re: Question about Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 11:10, Ian Whitfield wrote: Morning All Can you help me out - I've done this before but now can not get it to work!! I'm working in Calc (latest) on PCLinuxOS (latest) and have a multi-page spreadsheet. I have my dates in SHEET 1.Col 'C' with the matching data in the same ROW. Lo

[libreoffice-users] Question about Calc

2012-06-29 Thread Ian Whitfield
Morning All Can you help me out - I've done this before but now can not get it to work!! I'm working in Calc (latest) on PCLinuxOS (latest) and have a multi-page spreadsheet. I have my dates in SHEET 1.Col 'C' with the matching data in the same ROW. Lower down I use a dropdown box to select

Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread webmaster-Kracked_P_P
On 06/29/2012 04:10 AM, Andreas Säger wrote: Am 29.06.2012 09:04, Tom Davies wrote: Hi :) It makes a lot of sense. Hopefully the proper LO documentation is far better than most! The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate

[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Andreas Säger
Am 29.06.2012 09:04, Tom Davies wrote: Hi :) It makes a lot of sense. Hopefully the proper LO documentation is far better than most! The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate to where you want quickly. The built-in help i

Re: [libreoffice-users] Referencing slides from external impress presentation (Menu Insert -> File, selecting link), no visual clue?

2012-06-29 Thread Tom Davies
Hi :) I think it would be great to add a feature request for that.  People in my office are very unclear about the current arrangement and never know whether they should or whether they MUST NOT allow those sorts of links to update when they open a file.  Having any sort of information about

Re: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc

2012-06-29 Thread Tom Davies
Hi :)  It makes a lot of sense.  Hopefully the proper LO documentation is far better than most!  The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate to where you want quickly.  The built-in help is probably fairly poor right now.  Th