Search found 30 matches

by wdwisser
Tue Feb 27, 2024 6:49 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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 "ForceFullCal...
by wdwisser
Tue Jul 25, 2023 4:29 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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.
by wdwisser
Thu Jul 13, 2023 3:34 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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 formu...
by wdwisser
Tue Jul 11, 2023 12:15 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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 th...
by wdwisser
Mon Jul 10, 2023 4:44 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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 my iSe...
by wdwisser
Mon Jul 03, 2023 2:41 pm
Forum: HSSFR4
Topic: trouble with formulas
Replies: 12
Views: 11573

Re: trouble with formulas

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 c...
by wdwisser
Wed Jun 28, 2023 7:35 pm
Forum: HSSFR4
Topic: Java Exception on Procedure SS_OPEN
Replies: 3
Views: 4920

Re: Java Exception on Procedure SS_OPEN

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 wou...
by wdwisser
Fri Jun 23, 2023 7:18 pm
Forum: HSSFR4
Topic: xmlbeans download
Replies: 10
Views: 9322

Re: xmlbeans download

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.
by wdwisser
Thu Jun 22, 2023 6:30 pm
Forum: HSSFR4
Topic: xmlbeans download
Replies: 10
Views: 9322

Re: xmlbeans download

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.
by wdwisser
Thu Jun 22, 2023 6:12 pm
Forum: HSSFR4
Topic: Java Exception on Procedure SS_OPEN
Replies: 3
Views: 4920

Re: Java Exception on Procedure SS_OPEN

Just to add a little more context to this thread... I copied an original unmolested by POI .xls to the /tmp folder then ran my program posted prior and it runs fine. When I run the program another time it fails with the error specified in the original post. I'm not sure what is different between the...