Custom Formula in Spread12 not calculate

Custom Formula in Spread12 not calculate

Posted by: olivier.rondeau on 26 May 2019, 9:26 pm EST

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 May 2019, 9:26 pm EST

  Hi,
  
  I’m having a problem loading custom functions in the spread since the migration from version 10 to version 12.
  
  Our custom Formulas are no longer recognized when opening files in the spread. The formulas must be modified to be considered. Before that recalculations always returns the value “#Name?” indicating that the entered formula is not recognized.
  
  You will see that in the attached project, cells C4 and C5 referencing the formula FORM_AC are not recognized at the opening.
  
  You have to change the formula so that they are.
  
  Scenario:
  
  Change the Formula of cell C5 to “FORMAC()”, then change back to FORM_AC(), the formula is then recognized.
  
  With Version 10 of Spread

  With version 10 of Spread, we did not have this concern and the formulas were well recognized during the first recalculation following the opening of the file without any modification on the cells are necessary.

  I tried to program a formula overload of each cell referencing a custom formula but this has no effect. The modification must be done by the user interface for the formula to be recognized.

  I noticed the same problem with the namespace function Grapecity (preferred since version 11.40)

  I do not know how fixed this problem that will force me to stay in version 10 …
  
  So I hope you can help me.
  
  Thanks in advance.

  Best regards.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 26 May 2019, 9:28 pm EST

  TestSpread12.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2019, 5:06 pm EST

  Hello,

  This issue is fixed in the next spread release.
  
  Please refer to the release note in the following link:
  
  https://help.grapecity.com/spread/SpreadNET12ReadMe/webframe.html#ReleaseNotesforVersion12.45.20191.0.html

  After opening an Excel file, the custom functions can now be recalculated without any issues. [269202]

  The next release is scheduled to release on end of this week or first week of June.

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 29 May 2019, 5:14 am EST

  Many thanks. How can I be noticed about this new version?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 29 May 2019, 2:21 pm EST

  Hello,

  I am glad to tell you that the new version is released now. You can download the latest version 12.45.20191.0 here:

  https://www.grapecity.com/download/spreadnet

  Hope it helps.

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 2 June 2019, 8:55 pm EST

  TestSpread12.zip

  Hi,
  
  I updated the solution with this new version 12.45.20191.0 but I do not see any change in the problem.
  
  The formulas are still not considered as such until they have been modified by the end-user.

  Do you manage to reproduce the problem with the project attached?

  Best regards.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 3 June 2019, 6:17 pm EST

  Hello, Someone can answer about my last post please. Actually, our migration to new version is impossible. Many Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 3 June 2019, 10:10 pm EST

  Hello,

  I have modified the sample according to the new API. Please refer to the attached sample.
  
  Also, We have also added a new demo sample(C:\Program Files (x86)\GrapeCity\Spread.NET 12\Windows Forms\v12.45.20191.0\Samples\C#\Spread.Features\Spread.Calculation\Features\ZetaCalculator.cs) for custom function in the Spread.NET Control Explorer demos, which you can use for reference. I suggest checking this demo sample to see how to port your code from using the old calculation engine (FarPoint.CalcEngine.dll) model and the old FunctionInfo class to using the new GrapeCity.CalcEngine.dll and the new Function class instead, as this is the more efficient way to handle custom functions in v12.

  Hope it helps.
  
  Thanks.
  
  TestSpread12.zip

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 4 June 2019, 6:42 pm EST

  Hi mohitg,
  
  thank you for this answer, indeed, the problem does not seem to be present with the formulas of the new CalcEngine.
  
  I had read that the old formulas were fully compatible with the new engine, it seems that this is not quite the case.
  
  For the case that concerns me, I voluntarily created a sample with a simple “fake” formula. The reality is that we have a large collection of extremely complex formulas interconnected with a large amount of class. The migration will take a lot of work and seems to compromise the migration of the component in a version post 10 …
  
  Is the issue of loading custum formulas using FunctionInfo is in your roadmap?

  Thanks in advance for your answer.
  
  Best regards

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2019, 11:07 pm EST

  Hello,

  I have forwarded the issue to our development team(269202) and will inform you once I get any reply from them.

  Thanks.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2019, 3:57 pm EST

  Hello,

  Could you please confirm whether you added the old FunctionInfo function and you want to keep them available after open XLSX file?

  Thanks.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2019, 3:57 pm EST

  Hello,

  Could you please confirm whether you added the old FunctionInfo function and you want to keep them available after open XLSX file?

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 24 June 2019, 12:15 am EST

  Hello,
  
  Yes, our custom functions are made from FunctionInfo because they were developed with version 10 of Spread.
  
  We can not invest the time necessary for their migration because of their number. We therefore wish to preserve them as they are.
  
  Best Regards

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 24 June 2019, 7:42 pm EST

  Thanks for the information. I have passed the information to our development team and will inform you once I get any reply from them.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 10 July 2019, 7:37 pm EST

  Hello,

  This issue will be fixed in next major release i.e V12 SP2.

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 11 July 2019, 3:47 am EST

  Any dead line for this version?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 17 July 2019, 4:08 pm EST

  Hello,

  Spread V12 Sp2 is scheduled to release on end of July.

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 18 August 2019, 6:53 pm EST

  Hello Mohitg,
  
  Any link or news about Spread.net V12 SP2?
  
  Many thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 18 August 2019, 8:46 pm EST

  Hello,

  Spread v12 release last week. You can download the latest build from the following link:
  
  https://www.grapecity.com/download/spreadnet

  Thanks.

• 

  olivier.rondeau

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 6:59 pm EST

  Ok, many thanks. A release note somewhere?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 2:44 am EST

  Hello,

  Please refer the following link for release note;
  
  https://help.grapecity.com/spread/SpreadNET12ReadMe/webframe.html#rnoteswin20193.html

  Thanks,