I'm trying to create a spreadsheet and after I populate it with the data I want to use the subtotal on a range. This is easy to do through the interop (range.Subtotal(...)), but I haven't figured out how to do it through the Excel Engine (if I can at all).
Is it possible? If so, how?
Thanks
Jason
Ok, there seems to be a bug in 8.2.20082.1000 which seems to be fixed in 8.3.20083.1009.
Regards,
Mark Junker
You apply a formula to a cell by using the ApplyFormula method on a cell or by creating a new Formula instance with the static Formula.Parse or Formula.TryParse methods, then calling ApplyTo on it and passing it a cell reference.
HI,
How to apply formula to excel,
Please send me the code.
I have formula like =HYPERLINK("c:\test\Doc1.doc","TEXT")
How to apply this formula. This formula displaying as =HYPERLINK("c:\test\Doc1.doc","TEXT") I am not getting hyperlink.To get hyperlink manually I have to press enter key.
I was able to use these formulas in cells, save out the workbook, and verify that the formulas evaluated correctly. Are you getting an exception when you apply the formula or is it solving incorrectly in Excel? Also, what version of the Excel assembly are you using? Its possible this was a bug with an older version and it has since been fixed.
Mike Dour"]What code are you using to apply the formula?
I tried
Formula::Parse("=SUBTOTAL(3,RC1:R4C1)", CellReferenceMode::R1C1)->ApplyTo(objCell);
and
objCell->ApplyFormula("=SUBTOTAL(3,B1:B5)");