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: Astron version 1.14 release
    From: Bill Ritchie
    Date: 2017 Jun 12, 14:49 +0100
    Thanks for that input, Stan.  I can reproduce the input locking symptom using Google Sheets, albeit using a windows 10 device. Regardless of that, however, Astron (in either .xls or. xlsx format) doesn't seem to work in Google Sheets. Closer investigation shows that named variables (of which there are over 150) don't seem to be recognised when referenced by name. 

    May I suggest, Örjan, that you use Polaris Office as Stan suggests or download free Microsoft Excel for Android? Use the .xlsx version as Peter published at the beginning of this thread with either.

    If anyone else reading this knows of a fix for Google Sheets to recognise named variables, maybe by using an Add-In, please let me know.

    Bill Ritchie.

    On Mon, Jun 12, 2017 at 1:53 AM, Stan K <NoReply_StanK@fer3.com> wrote:
    Bill and Örjan,

    I downloaded the xlsx version onto my Samsung Galaxy S4, and it opened in Polaris Office, which came on the phone.  The only problem was that I could also not initially edit the input fields, but it was because it opens as protected sheets.  After I unprotected it, it worked fine.  Could Örjan's problem be similar?


    -----Original Message-----
    From: Bill Ritchie <NoReply_Ritchie@fer3.com>
    To: slk1000 <slk1000---.com>
    Sent: Sun, Jun 11, 2017 6:14 pm
    Subject: [NavList] Re: Astron version 1.14 release

    Hello Örjan,
    I have saved the published .xlsx version in .xls format, which I attach.
    Excel lists 22 'significant loss of function' occurrences and
    363 minor losses of fidelity, so please don't expect faultless operation. It is 
    also 50% larger!
    It works ok on my Android tablet running under Excel for Android - can't
    test it with Google spreadsheet unless I delete some other apps.
    Good luck with it,
    Bill Ritchie. 

    On Sun, Jun 11, 2017 at 4:58 PM, Örjan Sandström <NoReply_Sandstrom@fer3.com> wrote:
    Hmm, I have trouble with this in my android devices.
    all the other .xls spreadsheets from the .tar work but not the astron.xlsx, any "pure" xls version?
    main trouble is that I can not edit the input fields in google spreadsheet app.

    Attached File: 139206.astron-1.14.xls

    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