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:
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.
midrange.com
