CalculateFormula() not updating correctly

Kai_Iske · September 17, 2006, 11:37pm

Hi,

we have an Excel Workbook that we load into Excel. It contains a single formula (=TEXT(…) in A2). When I put a new date in column G1 (Date_Start) and then call Workbook.CalculateFormula, the text in A2 doesn’t get updated with 4.0.1.8.

Regardless of this being a useless example - I could have set the custom format on my cell A2 and put the date directly there - I guess CalculateFormula does not pick up the TEXT() formula properly?!

Regards

Kai

Laurence · September 17, 2006, 11:56pm

CalculateFormula doesn’t support TEXT function yet. I will add it within one week.

Kai_Iske · September 18, 2006, 12:01am

Laurence, sounds good to me. Great, thanks

Kai

Laurence · September 19, 2006, 6:25am

Hi Kai,

Now Aspose.Cells supports TEXT function.

I found a problem in your Excel file. Please click formula bar of cell A2 and press enter, then it shows "#VALUE" error. I think maybe the format text is not correct.

Please check the attached file.

Kai_Iske · September 19, 2006, 6:44am

Laurence,

great stuff, thanks very much. The reason for the error is that we’re using german formatting strings.

Kai

Laurence · September 19, 2006, 7:10am

Hi Kai,

Please try this attached version.

Kai_Iske · September 19, 2006, 7:13am

Thanks for the update, Laurence

Kai