Thread ID: |
Created: |
Updated: |
Platform: |
Replies: |
149843 | Dec 11,2019 12:35 PM UTC | Dec 12,2019 12:08 PM UTC | ASP.NET Core - EJ 2 | 1 |
![]() |
Tags: XlsIO |
Query |
Answer | |
1. When I insert data in cell, formulas values are not updated |
From the project you have shared us, we found that you are trying to access FormulaStringValue and hence the formula values are not updated.
We suggest you to use CalculatedValue to get the updated formula values.
Code Snippet:
We have modified the sample for your reference and the sample can be downloaded from the following link.
| |
2. When I close de worksheet saving, the worksheet is not saved
Also, if I do workbook.save(true) (Close the workbook and save) B2 cell is empty, but if I save with other filename, B2 has SI value
|
Currently, we do not have support for workbook.Save() in ASP.NET Core. So, while closing the workbook by passing true (workbook.Close(true)) won’t save the workbook.
We suggest you to save the document using workbook.SaveAs() method to resolve the issue. |
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.
This page will automatically be redirected to the sign-in page in 10 seconds.