Essential Calculate (CalcQuick) question: YEAR(TODAY()) not working?

[hui zheng]

Hello,

we use CalcQuick to calculate some formula. The below test code uses the YEAR(TODAY()) to get the year of today. But it receives #value error. Can you give example how to use it correctly?

var calculator = new CalcQuick();

calculator.setAutoCalc(false);

calculator.setKeyValue("__formula", "=YEAR(TODAY())");

calculator.refreshAllCalculations();

var val = calculator.getKeyValue("__formula");

console.log(val); 

=> result is #VALUE! error

Thanks!

Hui

[Piruthiviraj Malaimelraj]

Hi Hui, 

Thanks for your interest in Syncfusion products, 

We have analyzed your scenario and able to reproduce the scenario at our end. In order to resolve the reported issue, enable ExcelLikeComputations value of CalcEngine. Please make use of the below code and refer to the attached sample, 

Code snippet: 

var calculator = new CalcQuick(); 

calculator.getEngine().setExcelLikeComputations(true); 

calculator.setAutoCalc(false); 

 

calculator.setKeyValue("A", "=YEAR(TODAY())"); 

calculator.refreshAllCalculations(); 

var val = calculator.getKeyValue("A"); 

Sample link: 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/CalcQuickDemo1758329892  

Regards, 

Piruthiviraj 

[hui zheng]

Hi,

Yes, after ExcelLikeComputations is enabled, it works.

Thanks!

Hui

[Mohanraj Gunasekaran]

Hi Hui,  

 

Thanks for your update. 

 

We are glad to know that your reported problem has resolved. 

 

Please let us know if you have any further assistance. 

 

Regards, 

Mohanraj G