Re: XLS from RPGLE

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.