Welcome to the NavList Message Boards.

NavList:

A Community Devoted to the Preservation and Practice of Celestial Navigation and Other Methods of Traditional Wayfinding

Compose Your Message

Message:αβγ
Message:abc
Add Images & Files
    or...
       
    Reply
    Re: Using Calc.
    From: Martin Collins
    Date: 2009 Jan 17, 05:05 +0000

    I agree, if you could spell out exactly what it is you're trying to
    do. Excel or Calc will usually give an error at any kind of circular
    reference in a spreadsheet. You might need to get grips with Visual
    Basic for Applications (VBA) or OpenOffice Basic to accomplish the
    task.
    
    
    http://www.amazon.co.uk/Learn-OpenOffice-Org-Spreadsheet-Macro-Programming/dp/1847190979/ref=sr_1_1?ie=UTF8&s=books&qid=1232168573&sr=8-1
    
    or
    
    http://booklaptop.com/book.php?id=4571&by=Office&ord=id
    
    Rgds,
    
    Martin
    
    2009/1/17  :
    >
    > The problem, George, is that there are in fact a great many of these books 
    available. There "may" be a monolithic, tell-it-all (and expensive) manual 
    among them, but is that really what you're looking for?
    >
    > And you wrote:
    > "Not that I've been trying to use Calc to do anything particularly exotic.
    > But (for example) if you try using a spreadsheet to do any sort of recursion
    > or accumulation, you soon find there are traps set to avoid "circular
    > references"."
    >
    > Yes, circular references are bad. Maybe you could spell out what it is 
    you're trying to do? There might be a simple solution, and it is apparent 
    that there are plenty of people on NavList who can help.
    >
    > -FER
    >
    >
    >
    > >
    >
    
    --~--~---------~--~----~------------~-------~--~----~
    Navigation List archive: www.fer3.com/arc
    To post, email NavList@fer3.com
    To unsubscribe, email NavList-unsubscribe@fer3.com
    -~----------~----~----~----~------~----~------~--~---
    
    

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Join NavList

    Name:
    (please, no nicknames or handles)
    Email:
    Do you want to receive all group messages by email?
    Yes No

    You can also join by posting. Your first on-topic post automatically makes you a member.

    Posting Code

    Enter the email address associated with your NavList messages. Your posting code will be emailed to you immediately.
    Email:

    Email Settings

    Posting Code:

    Custom Index

    Subject:
    Author:
    Start date: (yyyymm dd)
    End date: (yyyymm dd)

    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site
    Visit this site