Welcome to the NavList Message Boards.


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

Compose Your Message

Add Images & Files
    Re: Using Calc
    From: Frank Reed
    Date: 2009 Jan 21, 17:25 -0800

    "which seem to be printed on request by an Australian outfit
    called Lulu, at reasonable prices. What I would like to have is a printed
    version of that Calc documentation printed out in the same way, but alas!
    Calc doesn't seem to feature in the list. I live in hope that some day it
    Email them and ask (if you haven't already). Technical document printing 
    companies are rapidly approaching the ideal of print-on-demand.
    I looked at your test case for an iterative calculation, and I would say that 
    you have found an "anomaly" in Calc (anomaly is polite for "bug"). If it 
    doesn't behave as Excel behaves, then it's behaving badly. 
    Incidentally, I still feel that circular references are a "bad idea", in part 
    because we can't be quite sure how they're operating behind the scenes, just 
    as you've found. There is no obviously logical way to do them. For what it's 
    worth, in those rare circumstances where I do an iterative calculation in a 
    spreadsheet, I use a bunch of off-screen cells to accomplish the job. If it 
    can't be done that way, then to me it's not a spreadsheet problem and it's 
    best done in code (which may be accessible from the spreadsheet, e.g. VBA, 
    but it's not part of the spreadsheet analysis paradigm).
    Navigation List archive: www.fer3.com/arc
    To post, email NavList@fer3.com
    To unsubscribe, email NavList-unsubscribe@fer3.com

    Browse Files

    Drop Files


    What is NavList?

    Join NavList

    (please, no nicknames or handles)
    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 Settings

    Posting Code:

    Custom Index

    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