scottklement.com

This is the CLASSPATH I am currently using, and it seems to work just fine.

ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/java/poi3.6/poi-3.6-20091214.jar+
:/java/poi3.6/poi-ooxml-3.6-20091214.jar+
:/java/poi3.6/poi-ooxml-schemas-3.6-20091214.jar+
:/java/dom4j/dom4j-1.6.1.jar+
:/java/xmlbeans ...

Just to give full disclosure: I found that the spreadsheet needed to be updated to force formula calculations when opened. The way I did this was to right click on a tab and then "View Code". Once that opened, I clicked on "ThisWorkbook" and found the attribute "ForceFullCalculation" was set to ...

Does anyone have any insight on why this occurring? Shouldn't the formulas work once you open up the spreadsheet or am I missing something.

Thanks for your input.

Okay, I updated it to use the 2-500 (e.g. =SUMIF(D$2:D$500,BJ4,J$2:J$500)/2000) in the formula and the number of rows that contain data are through 575 and still the same thing, the formula doesn't execute until I click on it and press Enter. Hmmm... very peculiar. With this change some of the ...

I changed the formula to the following: =SUMIF(D$2:D$1900,BJ4,J$2:J$1900)/2000

This didn't change anything on how the spreadsheet calculates the cell when it opened and it still shows as it did with the entire row being in the formula. Again, if I click on the cell and press Enter it will execute ...

I have this spreadsheet called TestExcelReplace.xlsx that has the formulas pre-loaded as follows:

=SUMIF(D:D,BJ4,J:J)/2000 in column BK4
=SUMIF(D:D,BJ5,J:J)/2000 in column BK5
=SUMIF(D:D,BJ6,J:J)/2000 in column BK6
etc.

TestExcel-Before.jpg


I then load the data in the columns A through J from ...

I'm having something of a similar problem. I have some cells with formulas that are I want to have the Spreadsheet use once I've loaded the data in cells that the formulas are referencing. For some reason the pre-set formulas will not calculate until I open the spreadsheet and click on the formula ...

I found where there were some formulas in the spreadsheet where my code was overwriting those formulas that were in place. I'm not sure why that causes an issue since I am "overwriting" the cell with another value or formula. It could be I don't understand how that works but thought it would just ...

I did put it in my classpath and things started working instead of failing like before. Geez, I'm not the quickest to these things and I'm sorry it took so long to get to this point. I could not figure out how to download it and I thought I needed to add it to the classpath so that part I understood.

I was able to download the xmlbeans-2.5.0.jar and I put it in the IFS directory /java/xmlbeans and is that all I am supposed to do with it.