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
    Name or NavList Code:
    Email:
       
    Reply
    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
    will."
    
    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).
    
    -FER
    
    
    
    --~--~---------~--~----~------------~-------~--~----~
    Navigation List archive: www.fer3.com/arc
    To post, email NavList@fer3.com
    To , email NavList-@fer3.com
    -~----------~----~----~----~------~----~------~--~---
    

       
    Reply
    Browse Files

    Drop Files

    NavList

    What is NavList?

    Get a NavList ID Code

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

    A NavList ID Code guarantees your identity in NavList posts and allows faster posting of messages.

    Retrieve a NavList ID Code

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

    Email Settings

    NavList ID 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