Skip to content

Cell Formula is not persisted when editing the file #46

@RazinBharde

Description

@RazinBharde

Describe the bug
When a formula is add to a cell, correct calculation is performed and cell value is updated as per the formula. However, after downloading the file is the fields are edited automatic calculation is not performed.

Eg.
var ref1 = worksheet.Cell(row, 10); var ref2 = worksheet.Cell(row, 11); cell.FormulaA1= $"={ref2}-{ref1}"; var value = cell.Value;

above gives me value of '3' when ref1=3 and ref2=6. However, when the file is downloaded, edited in MS excel and value of ref2 is changed to 10 the formulated cell value is still 3.

Expected behavior
Formula should persist as it would in excel file

Screenshots
If applicable, add screenshots to help explain your problem.

Versions (please complete the following information):

  • CSVHelper: [eg. 22.1.1]
  • CSVHelper.Excel.Core: [eg. 27.2.1]

Additional context
Add any other context about the problem here. The file being parsed, etc.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions