Formula are recalculate after opening workbbok in excel

Aspose.Cells Product Family
1

Hi Aspose Team,

I've a workbook which use a user-defined function from an xla.
I've replicated the function in a ICustom so that Aspose.Cells can recalculate the workbbok.

My problem is :
when I send the workbook to a user, after Aspose.Cells has recalculate it,
the user see #Name? in all cells that use the user-defined function

I know Aspose.Cells recalculate it well because,
when i set the workbook calculation option to manual (tools : option : calculation : manual)
The formula appears with the rigth value.
But, calculation are not automatic and user can work right away with the workbook.

Is there a way to send the recalculated workbook from Aspose.Cells to a user,
so that formula are not recalculate right after opening the workbook?
The user need to check the result from Aspose first, then do minor adjusment.
That is so, because recalculate the whole workbook is too long within Excel.
(but really pretty much faster with Aspose : great works guys!)

2

Hi,

Thank you for considering Aspose.

Well, you may use Workbook.ReCalcOnOpen = false, so that workbook formulas should not get calculated on opening the workbook and Workbook.CalcMode = CalcModeType.Manual to set the formula calulation type as manual as per your requirement.

Thank You & Best Regards,

3

thanks for your help.

Is it possible to set these option from Excel directly?
I can find Workbook.CalcMode (Tools, Option, Calculation tab)
But I don't see Workbook.ReCalcOnOpen.
Is ReCalcOnOpen an Excel 2007 settings?
I'm using Excel 2003.

4

Hi,

Thank you for considering Aspose.

Well, I think, ReCalcOnOpen is an internal process and you cannot manually set it using the MS Excel.

Thank You & Best Regards,