Excel formulas convert to PDF


#1

I have an applicationt that is using your Excel component to create spreadsheets, then is converting those spreadsheets to PDF. Several of the cells in the spreadsheet have formulas, and when I convert to PDF, those cells are all zero.

The formulas are set using the following sample code: Cells[1,1].Formula = “=SUM(B1-C1)” (this is not my actual formula, simply the way I was setting the formula).

When I was creating the spreadsheet using the Microsoft Excel API, the values for the cells would be in the PDF, but there were other issues there.

I want to use your component to create the Excel file, because it’s MUCH faster, and it seems to convert to PDF much better (except for this formula problem, of course).

Any help would be greatly appreciated!

Thanks!

Theresa


#2

Nevermind. I just had to call Excel.CalculateFormula() before I saved the XML file.

My bad!

Theresa


#3

I spoke too soon… My =SUM() formulas are showing fine in the PDF, but I have some other formulas that are are not - SUBTOTAL() does not show up in the PDF, and neither does some of more complicated ones that look like this -
=IF(ROUND(D14,0)=0,“NA”,IF(H14/D14>1,“NA”,H14/D14))

Do you have any suggestions?

Theresa