RE: XLS from RPGLE

The user is traveling today, but I think they use numbers. I have suggested trying excel for IOS. I have installed the android version and it works with the formulas I use. Nothing fancy some divisions or SUM functions.

I was able to generate a working prototype for the formula evaluator using the Source-new-JavaMethodCall. We have POI 3.6 installed so I had an error when using the provided prototype. Thanks for the detailed description on generating them. I found the POI location yesterday when I was trying to determine which version we are on. This is definitely a nice skill to have for other requests that Scott never needed in his port of POI.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Thursday, April 07, 2016 9:57 AM
To: Rpg400 Rpg400-L <rpg400-l@xxxxxxxxxxxx>
Subject: Re: XLS from RPGLE

No argument - but I was merely pointing out that arbitrarily discussing compatibility without knowing what the OP was using to render the sheet was somewhat pointless. I have not tried the Excel version for iOS but would expect it to do better than Apple’s Numbers - and that does a halfway decent job.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Apr 7, 2016, at 12:07 AM, John Yeung <gallium.arsenide@xxxxxxxxx> wrote:

On Wed, Apr 6, 2016 at 7:12 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> 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://urldefense.proofpoint.com/v2/url?u=https-3A__itunes.apple.com
_ca_app_microsoft-2Dexcel_id586683407-3Fmt-3D8&d=CwIGaQ&c=S6jE3hMA0s1
6gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1
D5-5Jv01Y&m=tHZClJmi5EjJXM3mUZy7XRKxMdJKXLZMFWqhgHD5OHk&s=onbbB0Muue_
Jlp8B_HeWNgXD567slk-V1DQBQfNUWqo&e=

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

There's more to Excel support than just being a full-featured
spreadsheet program. As I just explained, reading, parsing, and
calculating Excel formulas is highly nontrivial. This remains true no
matter how much other functionality you have. It may well be that
Apple Numbers is a wonderful product, and that if you start off with
Numbers and create native Numbers files and never touch Excel, you
will be a very happy spreadsheet camper. That doesn't mean Numbers
will necessarily do a good job opening an Excel file.

Also, I'd like to note that an iOS version of an app isn't necessarily
as capable or full-featured as the OS X version of that app.

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:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com
_mailman_listinfo_rpg400-2Dl&d=CwIGaQ&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLu
nI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=tHZClJmi
5EjJXM3mUZy7XRKxMdJKXLZMFWqhgHD5OHk&s=wzMvJtD0e7znk7iT8qWgfRuS8-EWz1xo
DoFEF9y4imA&e= or email: RPG400-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_rpg400-2Dl&d=CwIGaQ&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=tHZClJmi5EjJXM3mUZy7XRKxMdJKXLZMFWqhgHD5OHk&s=XB7TDWik__nQ5p3nWOdgYhoTyjNj-mCztVRi12tGhoY&e= .

Please contact support@xxxxxxxxxxxx for any subscription related questions.

--
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: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=CwIGaQ&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=tHZClJmi5EjJXM3mUZy7XRKxMdJKXLZMFWqhgHD5OHk&s=wzMvJtD0e7znk7iT8qWgfRuS8-EWz1xoDoFEF9y4imA&e=
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_rpg400-2Dl&d=CwIGaQ&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=tHZClJmi5EjJXM3mUZy7XRKxMdJKXLZMFWqhgHD5OHk&s=XB7TDWik__nQ5p3nWOdgYhoTyjNj-mCztVRi12tGhoY&e= .

Please contact support@xxxxxxxxxxxx for any subscription related questions.