Bug Report T317956
Visible to All Users

The calculation chain is not updated after formulas that contain custom functions are removed during the document export

created 9 years ago (modified 9 years ago)

When i save my worksheet with option:

C#
ws.Options.Export.CustomFunctionExportMode = CustomFunctionExportMode.CalculatedValue ws.SaveDocument(outputFile, DocumentFormat.Xlsx);

CalcChain in outfile is not updated. All formulas are replaced by values but this cells are still in CalcChain.

For MS Excel this is not problem, but if i load this file with code, i get a nullpointer exception in DevExpress-class:

C#
public class CalculationChainElement ... private bool CellsChainContainsCell(CellsChain chain, ICell cell) => ((cell.FormulaInfo.NextCell != null) || object.ReferenceEquals(chain.Footer, cell))

because cell.FormulaInfo is null. Remember, cell-formula was replace by value in step 1.

Is it possible to fix that?

  1. Update CalcChain while saving worksheet with CustomFunctionExportMode.CalculatedValue.
  2. Be more fault-tolerant while loading document.

Thank you for your help,
Sascha

Comments (1)
DevExpress Support Team 9 years ago

    Hello Sascha,

    I've passed this ticket to my team. Our developers will research this issue in detail. We will get back to you once we have any results.

    P.S. Would you mind if I mark this ticket public in order to notify other customers of the issue? If you wish, I can remove your project from the attachment.

    Answers approved by DevExpress Support

    created 9 years ago (modified 9 years ago)

    We have fixed the issue described in this ticket and will include the fix in our next maintenance update. To apply this solution before the official update, request a hotfix by clicking the corresponding link for product versions you require.

    Note: Hotfixes may be unavailable for beta versions and updates that are about to be released.

      Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

      Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.