having more Areas of Knowledge than they can write-up quickly.
Regards from
Tom :)
--- On Wed, 11/7/12, Ken Springer snowsh...@q.com wrote:
From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
To: users@global.libreoffice.org
Hi, Tom,
On 7/7/12 5:59 PM, Tom Davies wrote:
I think one advantage of wiki's is that they are easy for anyone to update
anytime.
Hopefully information from that gets fed into blogs and official documentation
and
maybe even the help files.
The question I would pose to you is, is the wiki
very complex ideas with no training.
Regards from
Tom :)
--- On Thu, 5/7/12, Ken Springer snowsh...@q.com wrote:
From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
To: users@global.libreoffice.org
Date: Thursday, 5 July, 2012, 14
Am 04.07.2012 17:42, Ken Springer wrote:
For the ordinary user, not only does LO need to explain the basics by
using =FUNCTION(number ; text ; range ; vector ) and =FUNCTION(
function_number(x) ; function_text(x) ; function_range(x) ;
function_vector(x) ) with explanations, you need examples
On 7/5/12 2:41 AM, Andreas Säger wrote:
snip
All this had been written hundreds of times for dozends of spreadsheets
applications in books, web-pages, mailing lists and forums. People don't
read this.
I know, but I have a hard time blaming X percent of them. I run into
many users who have
Hi, Andreas,
Sorry for the late reply, but I just came off 4 workdays, 11 hours each
plus commuting time. :-) I didn't have time to do any newsgroup replies.
Comments for discussion, not for assistance. :-)
On 6/30/12 10:54 AM, Andreas Säger wrote:
Am 30.06.2012 14:09, Ken Springer
Ken,
There is no way to help further without a single formula nor data. I
have no idea what your problem is.
Like in any programming language un-nesting is a good way to debug
steps. Threre are a billion of cells on each sheet. Use as many as
possible and things will clear up.
Have a nice
Am 30.06.2012 02:17, Ken Springer wrote:
chapters are there before they get put together to form the entire book.
Unfortunately, there's nothing there for 3.5.x.x.:-( And the
Formula Wizard is different in 3.5.x.x.
I compared the wizard in 3.5 with the one in OOo 1.1 of 2004. Apart
Ken Springer wrote:
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
Am 30.06.2012 02:37, Ken Springer wrote:
And I've not been able to come up with a competent explanation of what
I'm trying to accomplish. :)
That's what *you* have got to explain to the application. Any competent
resource on spreadsheets tells you how to tell anything to the
Hi, Andreas,
On 6/30/12 2:25 AM, Andreas Säger wrote:
Ken,
There is no way to help further without a single formula nor data. I
have no idea what your problem is.
Like in any programming language un-nesting is a good way to debug
steps. Threre are a billion of cells on each sheet. Use as many
On 6/30/12 5:28 AM, Dan wrote:
When it comes to databases, it is always a matter of planning and
designing. Doing this correctly may result in a subcompact car rather
than a Mack truck for a simple database. Obviously, when you want more a
more complex output, it will increase in
On 6/30/12 5:33 AM, Andreas Säger wrote:
Am 30.06.2012 02:37, Ken Springer wrote:
And I've not been able to come up with a competent explanation of what
I'm trying to accomplish. :)
That's what *you* have got to explain to the application. Any competent
resource on spreadsheets tells you
Am 30.06.2012 14:09, Ken Springer wrote:
After reading your other new replies, I'm wondering if the way I wrote
my posts led you to some wrong conclusions. Possibly, it came out
sounding more complicated than the problem really was, as I did get it
solved.
It wasn't the logic or the functions
Am 30.06.2012 14:52, Ken Springer wrote:
What frustrates me is there seems to be very few simple and easy to
grasp and use database programs anymore.
Some database such as MySQL is a development tool for well paid
professional computer geeks. To some extent you need to get the same way
of
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.
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
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
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 are
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),
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
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
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
to form
the entire book.
So, smaller targeted downloads :)
Regards from
Tom :)
--- On Thu, 28/6/12, Ken Springer snowsh...@q.com wrote:
From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
To: users@global.libreoffice.org
Date
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 generic examples of how to use
On 6/28/12 3:29 AM, Tom Davies wrote:
So, smaller targeted downloads:)
Now that I have DSL, I don't mind downloading the entire book. Don't
know which chapter to look in anyway. LOL
--
Ken
Mac OS X 10.6.8
Firefox 13.0.1
Thunderbird 13.0.1
LibreOffice 3.5.2.2
--
For unsubscribe
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
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 years with the only exception
that
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 generic examples of how to use them.
I need to nest some of the functions, if that's possible.
On 6/27/12 6:43 PM, Jay Lozier wrote:
Ken,
On 06/27/2012 07:24 PM, 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 generic examples of how to use them.
I need to nest some of the
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 generic examples of how to use them.
I need to nest some of the functions, if that's
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 generic examples of how to use them.
I need to nest
On 06/27/2012 09:58 PM, Ken Springer wrote:
On 6/27/12 6:43 PM, Jay Lozier wrote:
Ken,
On 06/27/2012 07:24 PM, 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 generic examples of how
33 matches
Mail list logo
