Conventions differ. I use + for west and - for east.
Many use that convention, however,many use it the
other war around.
Locked spreadsheets in DocsToGo happen under several
circumstances.
1. Formulae of a nature that DocsToGo cannot cope, so
it locks the spreadsheet as a protective measure
against a future hotsync. (that is my deduction based
on experience).
2. Size of the net .xls file
My spreadsheet can trigger both unless split up. The
big spreadsheet is big because of (1) the astronomical
EOT worksheet which also has many complex formulae
repeated, (2) the big spreadsheet is only many
worksheets because of the first page which links to
them with [a] conditional formatting, [b] common
geographic data that almost all sheets use.
In other words my big spreadsheet,
illustrating-shadows.xls, can be broken up with little
harm. The only programming issue being the references
back to the first page.
HOPE IN SITE: However, enough people use that big
sheet, and enough use PDAs, including me, so, I shall
try and get a PDA version for DocsToGo in the next
week or so.
Simon
--- Peter Mayer <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been meaning to thank Simon for his super
> suggestion of using Documents
> to Go on a PDA, and for the link to his great Excel
> spreadsheets. The
> combination is excellent.
> Two questions, though: i) am I correct in
> assuming that Longitudes east of
> Greenwich are prefixed by a minus sign?
> ii) on my Palm E2, the spreadsheet transferred
> as 'locked'. I can't seem
> to find out how to 'unlock' it. It's simple, I'm
> sure, but I don't know where I
> should be looking.
>
> Thanks again, Simon,
>
> best wishes,
>
> Peter
>
>
> >{snip}
> > However, if you have Documents To Go, then you
> have
> > Excel on your PDA, and my Excel dialling aids, or
> any
> > of the others, can be used. And DocsToGo has
> graphing.
> >{snip}
> >
> > Simon
> > www.illustratingshadows.com
> >
>
> --------------------------
> Peter Mayer
> Politics Department
> The University of Adelaide, AUSTRALIA 5005
> Ph : +61 8 8303 5606
> Fax : +61 8 8303 3443
> e-mail: [EMAIL PROTECTED]
> CRICOS Provider Number 00123M
>
-----------------------------------------------------------
> This email message is intended only for the
> addressee(s)
> and contains information that may be confidential
> and/or
> copyright. If you are not the intended recipient
> please
> notify the sender by reply email and immediately
> delete
> this email. Use, disclosure or reproduction of this
> email
> by anyone other than the intended recipient(s) is
> strictly
> prohibited. No representation is made that this
> email or
> any attachments are free of viruses. Virus scanning
> is
> recommended and is the responsibility of the
> recipient.
>
---------------------------------------------------
https://lists.uni-koeln.de/mailman/listinfo/sundial
