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

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 is probably fairly poor right now.  The docs team needs more people even to get 
> through the proper full guides let alone important extras like the built-in help or the Faq.  On 
> the plus side they are really getting through the work and the 3.4.x guides have been pulled 
> together in an amazingly short  time.
>
> They have an excellent team right now even though some of the regular long-term stars appear to be 
> taking a breather (or are they working hard behind the scenes?  It's difficult to know)
>
> Regards from
> Tom :)

BLAH, BLAH, BLAH. Fanboyism by Tom.

Back on topic:
Calc is almost identical to Excel and Gnumeric. Point! Conceptually is 
still similar to any spreadsheet since 1979 (a reference sheet for 
VisiCalc is still online).
A function reference for Excel or Gnumeric can help you to work with 
Calc if you really understand the content and that it does not apply 
literally.

There is no need to know each and every function in detail. What you 
need to know _and_understand_ is:
- Text vs. Number (and vs. Boolean in other applications)
- Format vs. Value (percent, bool, date/time formatting in particular)
- Relative vs. absolute reference
- The lookup functions of all spreadsheets are somewhat special. In the 
first place they had been designed for something that is not that much 
required by today's spreadsheet users.
- The most serious incompatibility between Calc and anything else is the 
radically awkward string processing which makes it unusable for too many 
of today's users.



--
For unsubscribe instructions e-mail to: users+help@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