X - formulabar question?

Question

Hi,I want to use only formulabar control, how do i separate them from the grid. I have seen gridcontrol and spreadsheet but I have not found the property to hide the rest.also, Does it support intellisense list functions when typing?Thank!Edit tag: spreadsheet/gridcontrol and I still need to use Excel functions (vlookup, match, ..)...

Arulpriya Ramalingam · Answer

Hi khanh,

Thank you for your interest in Syncfusion support.

This can be achieved by updating the formula in a TextBox and compute it using the ParseAndComputeFormula() method of CalcEngine. We already provided a dashboard demo to achieve this use case and please make use of the below sample.

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/CS623846390

This sample can be retrieved in your local machine from the below location.

<Install location>Syncfusion/Essential studio/windows/<product version>/Calcualte/ Grid-Data-Bound-Grid Calculator Demo / CS

Please get back to us, if you need any further assistance.

Regards,

Arulpriya

The GridLock · Answer

hi Arulpriya ,Does it seem to work with arrays? is it possible to do this?----------------------------------------------/

Arulpriya Ramalingam · Answer

Hi khanh, 
 
Thank you for the update. 
 
We could reproduce the issue that the CalcEngine does not compute the sum formula with array values. We have forwarded the query to our development team for further validation and we need some more time to validate the issue and update you with proper details on 29th June 2020. 
 
We appreciate your patience till then. 
 
Regards, 
Arulpriya

Arulpriya Ramalingam · Answer

Hi Khanh,  
  
Thank you for the update.  
  
We confirmed that reported scenario is a defect from our end. We have logged a bug report for this issue “SUM formula returns improper result with Arrays” Here we have provided private feedback link, we request you to log in to view the link further      
   
https://www.syncfusion.com/feedback/15624/sum-formula-returns-improper-result-with-arrays 
    
The fix will be available in our upcoming Volume2 SP1 release which is scheduled to be rolled out at the end of July, 2020. Would waiting for the official release is OK for you? Otherwise, we can provide a patch in the reported version v18.1.0.42 on 13th July, 2020. If you have any more specification replication procedure or a scenario to be tested you can add it as a comment in the portal also if the version is not correct, please specify the version in which you need the patch.    
   
Regards,   
Arulpriya

The GridLock · Answer

Hi Arulpriya ,My current version is 18.1.042. I hope I can check it out soon if possible.

Arulpriya Ramalingam · Answer

Hi Khanh,   
   
Thank you for the update.   
 
We will fix this issue on or before 13th July 2020 and update you the patch details for the version 18.1.0.42. we appreciate your patience till then. 
 
Regards, 
Arulpriya

Arulpriya Ramalingam · Answer

Hi Khanh, 
 
Sorry for the inconvenience. 
 
We have fixed the issue and forwarded the fix to testing purpose to ensure all the existing test cases are working fine with the modified code changes. We need some more time complete the testing process and we will update you with patch details on 17th July 2020. 
 
We appreciate your patience till then. 
 
Regards, 
Arulpriya

The GridLock · Answer

Ok Arulpriya!

Arulpriya Ramalingam · Answer

Hi Khanh, 
 
Thank you for the update. 
 
As we promised, we will update you with patch details on 17th July 2020. 
 
Regards, 
Arulpriya

Arulpriya Ramalingam · Answer

Hi Khanh, 
 
We deeply regret for the inconvenience. 
 
From the testing result, we are facing some breaking cases with the updated fix from our end and our development team is working on this with high priority. We will update you with proper patch details on 21st July 2020. 
 
Regards, 
Arulpriya

The GridLock · Answer

Ok Arulpriya !

Arulpriya Ramalingam · Answer

Hi khanh,The issue with " SUM formula returns improper result with Arrays " has been fixed and the patch for this fix can be downloaded from the following location. Recommended approach - exe will perform automatic configurationPlease find the patch setup from below location:http://syncfusion.com/Installs/support/patch/18.1.0.42/1174432/F155419/SyncfusionPatch_18.1.0.42_1174432_7212020115216344_F155419.exe Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environmentPlease find the patch assemblies alone from below location:http://syncfusion.com/Installs/support/patch/18.1.0.42/1174432/F155419/SyncfusionPatch_18.1.0.42_1174432_7212020115216344_F155419.zip Assembly Version: 18.1.0.42Installation Directions : This patch should replace the files “Syncfusion.Calculate.Base.dll” under the following folder.$system drive:\ Files\Syncfusion\Essential Studio\18.1.0.42\precompiledassemblies\18.1.0.42\4.6Eg : $system drive:\Program Files\Syncfusion\Essential Studio\18.1.0.42\precompiledassemblies\18.1.0.42\4.0To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.Note : To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.https://www.syncfusion.com/account/licenseDisclaimer : Please note that we have created this patch for version 17.4.0.39 specifically to resolve the following issue(s) reported in this/the forum(s). 155419If you have received other patches for the same version for other products, please apply all patches in the order received.This fix will be included in our main release 2020 Volume2 SP1 which will be available in end of August 2020.Regards,Arulpriya

The GridLock · Answer

Hi Arulpriya ,Notice the "," and ";" signs. the formula must work for both. also i notice that only the .exe works. .dll patches are not working. did i miss something?

Arulpriya Ramalingam · Answer

Hi khanh, 
 
Thank you for the update. 
 
As per the current behavior of CalcEngine, the arguments will be separated based on the ParseArgumentSeparator property value and the list values will be separated based on the ParseListSeparator value. If you need to separate the list items with different character, we would suggest you to set the list separator based on your requirement. 
 
Example code 
 




CalcEngine.ParseListSeparator = ‘;’; 
 
Please get back to us, if you need any further assistance. 
 
Regards, 
Arulpriya

The GridLock · Answer

Hi ,I think it is not a separator argument. please check.

Arulpriya Ramalingam · Answer

Hi khanh, 
 
Thank you for the update. 
 
We could understand the use case and forwarded the query to our development team for further validation. We need some more time to validate completely and we will update you with proper details on 28th July 2020. We appreciate your patience till then. 
 
Regards, 
Arulpriya

Arulpriya Ramalingam · Answer

Hi khanh, 
  
Thank you for your patience. 
  
We added the specification in the same bug report and our development team is working on this with high priority. We will provide you the patch details on 30th July 2020. 
 
Regards, 
Arulpriya

Arulpriya Ramalingam · Answer

Hi khanh,The issue with " SUM formula returns improper result with Arrays" has been fixed and the patch for this fix can be downloaded from the following location. Recommended approach - exe will perform automatic configurationPlease find the patch setup from below location:http://syncfusion.com/Installs/support/patch/18.2.0.44/1174432/F155419/SyncfusionPatch_18.2.0.44_1174432_7302020111431328_F155419.exeAdvanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environmentPlease find the patch assemblies alone from below location:http://syncfusion.com/Installs/support/patch/18.2.0.44/1174432/F155419/SyncfusionPatch_18.2.0.44_1174432_7302020111431328_F155419.zip 
Assembly Version: 18.2.0.44Installation Directions : This patch should replace the files “Syncfusion.Calculate.Base.dll” under the following folder.$system drive:\ Files\Syncfusion\Essential Studio\18.2.0.44\precompiledassemblies\18.2.0.44\4.6Eg : $system drive:\Program Files\Syncfusion\Essential Studio\18.2.0.44\precompiledassemblies\18.2.0.44\4.0To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.Note : To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.https://www.syncfusion.com/account/licenseDisclaimer : Please note that we have created this patch for version 18.2.0.44 specifically to resolve the following issue(s) reported in this/the incident(s). F155419If you have received other patches for the same version for other products, please apply all patches in the order received.This fix will be included in our main release 2020 Volume2 SP1 which will be available in end of August 2020.Regards,Arulpriya

The GridLock · Answer

Chào Arulpriya ,my s-vesion is 18.1.042 can i install this?

Balamurugan Thirumalaikumar · Answer

Hi khanh,The issue with "SUM formula returns improper result with Arrays" has been fixed and the patch for this fix can be downloaded from the following location.Recommended approach - exe will perform automatic configurationPlease find the patch setup from below location: http://syncfusion.com/Installs/support/patch/18.1.0.42/1174432/F155419/SyncfusionPatch_18.1.0.42_1174432_8032020092712954_F155419.exeAdvanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environmentPlease find the patch assemblies alone from below location: http://syncfusion.com/Installs/support/patch/18.1.0.42/1174432/F155419/SyncfusionPatch_18.1.0.42_1174432_8032020092712954_F155419.zipAssembly Version: 18.1.0.42Installation Directions :This patch should replace the files “Syncfusion.Calculate.Base.dll” under the following folder.$system drive:\ Files\Syncfusion\Essential Studio\18.1.0.42\precompiledassemblies\18.1.0.42\4.6Eg : $system drive:\Program Files\Syncfusion\Essential Studio\18.1.0.42\precompiledassemblies\18.1.0.42\4.0To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.Note :To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.https://www.syncfusion.com/account/licenseDisclaimer :Please note that we have created this patch for version 18.1.0.42 specifically to resolve the following issue(s) reported in this/the incident(s). F155419If you have received other patches for the same version for other products, please apply all patches in the order received.This fix will be included in our main release 2020 Volume2 SP1 which will be available in end of August 2020.Thanks & Regards,Balamurugan Thirumalaikumar