× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Just a bit to add - Apple Numbers is a pretty weak Excel renderer - I think DocsToGo has a more complete list of supported functionality - I wanted to avoid writing a sharedstrings.xml when creating XLSX with CGIDEV2 = the recommended alternate was data type of inlinestr - but Numbers could do nothing with it. So I ended up using simple formulas for text - not pretty but it worked.

We now have Office 365 corporately, I think, so all of that would be available for our iPhones and should render things very nicely - no test yet, but it IS from MS.

Later
Vern

On 4/6/2016 6:12 PM, Jon Paris wrote:
Perhaps it is worth asking exactly _what_ is being used to view the spreadsheet on the iPhone. Didn’t MS introduce free iOS versions of their tools a while back?

Yup - says he answering himself - https://itunes.apple.com/ca/app/microsoft-excel/id586683407?mt=8

I would think that that went well beyond being a viewer. Apple Numbers on the iPhone should also work.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 6, 2016, at 4:22 PM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Wed, Apr 6, 2016 at 4:06 PM, Darren Strong <darren@xxxxxxxxx> wrote:
[Re: Setting a flag to force recalculation]
I don't know if it helped, but I did this once. If you have a way to test
it, you might add that to your code and see if it tricks the iPhone into
evaluating the formulas.
I suppose it's worth a try, but I would not expect that to work. The
issue is that the viewer program most likely doesn't have any facility
to calculate formulas. It's probably just a pure reader, grabbing
whatever data it can that is written into the file.

This happens to also be one of the major reasons that very few
third-party programs out there actually evaluate Excel formulas. There
are a TON of formulas you'd have to support if you want to do it
right, and you can't guarantee you'll get the math *exactly* the same
as how Excel does it. (Not because you don't know the "proper" way to
calculate a formula, but because you don't know if *Excel* is doing it
*exactly* that way.) And that's assuming you've already successfully
parsed all the references, possibly including named ranges and so
on... it's just a stunning amount of work to re-engineer what Excel
does.

John Y.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.