values in formulas are not updated and save error

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

Subscribe to this post

Tags: XlsIO

Manolo Capdevila

Asked On December 11, 2019 12:35 PM UTC

Hi,

I've an excel with formulas, and I've two problems

1. When I insert data in cell, formulas values are not updated

2. When I close de worksheet saving, the worksheet is not saved

I attach an example. In the example, if I set SI value in B2 cell, B9 cell has 100 value, else 500.

So, in the code, I set SI value, but the B9 value is 500 not 100.

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

Attachment: WebApplication5_aa908199.zip

Reply | Reply with quote

Konduru Keerthi Konduru Ravichandra Raju [Syncfusion]

Replied On December 12, 2019 12:08 PM UTC

Hi Manalo,

Greetings from Syncfusion.

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:

string value;

value = sheet.Range["B9"].CalculatedValue;

We have modified the sample for your reference and the sample can be downloaded from the following link.

Sample Link: https://www.syncfusion.com/downloads/support/forum/149843/ze/WebApplication5-684413535.zip

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.

Regards,

Keerthi.

Reply | Reply with quote

CONTACT US

values in formulas are not updated and save error

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US