RE: XLS from RPGLE

Thanks, I was just looking at Poi and evaluateformulacell(cell cell) function, and dreading trying to create the prototype. I know nothing about Java. I'll give this a try.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Darren Strong
Sent: Wednesday, April 06, 2016 3:06 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: XLS from RPGLE

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.

D setRecalc PR
D ExtProc(*JAVA
D : SHEET_CLASS
D :
'setForceFormulaRecalculation')
D Ind n value


SetRecalc(Sheet:*on);



From: "Roche, Bob" <broche@xxxxxxxxxxxxxxxxx>
To: "rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
Date: 04/06/2016 03:50 PM
Subject: XLS from RPGLE
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



I am using Scott Klement's port of HSSF POI to create a few spreadsheets from RPGLE programs. These are then sent by email and look fine in Excel. I have one person trying to view them on their IPhone and the formulas do not show properly. It always displays 0. In excel I see =SUM(B1:B9) for example. Has anyone come across this before? If I save the spreadsheet off in excel with a new name and then email it they formulas work properly.

To make testing even more fun. I have to work with my manger. I use android phones and tablets.

I am making .XLS at this point not .XLSX files.

--
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=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=hcQhhUZfU6KUwsGcbTu2UmxOwOojrWRwQ8VrtLkDlPo&s=_ThwJXjYdOQBJaHkBbUYktwnZMJHrClR9zNXsNfj7cw&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=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=hcQhhUZfU6KUwsGcbTu2UmxOwOojrWRwQ8VrtLkDlPo&s=hlKxGXAj2EIYpnB_I2kqTl2RzeWucDpSSiB48uoe-PY&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=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=hcQhhUZfU6KUwsGcbTu2UmxOwOojrWRwQ8VrtLkDlPo&s=_ThwJXjYdOQBJaHkBbUYktwnZMJHrClR9zNXsNfj7cw&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=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=hcQhhUZfU6KUwsGcbTu2UmxOwOojrWRwQ8VrtLkDlPo&s=hlKxGXAj2EIYpnB_I2kqTl2RzeWucDpSSiB48uoe-PY&e= .

Please contact support@xxxxxxxxxxxx for any subscription related questions.