Accessing calculated value produced formula with MIN

Aspose.Cells Product Family
1

Hi, I am having problems accessing calculated value from a cell with a formula with MIN in it.
Please advise,
Alex.

2

Hi Alex,

Could you please elaborate your problem? What the formula? Could you please post related template file and sample code here? Thanks.

3

Please take a look at the attached test app.

4

Please try this fix.

5

Thanks, that worked.

6

Oops, I jumped the gun a bit. It works in my simple template, but when I add the real template, I get a NullPointer Exception in CalculateFormula().
Please see the attached.

7

Please try this fix.

8

Thanks, that fixed it.

9

@YarmulnikA,
Aspose.Excel is discontinued and replaced by Aspose.Cells that is much advanced and supports the latest features of MS Excel. You can work with all the formulas which are available in different spreadsheet handling softwares. Here is an example that demonstrates the working with formulas using Aspose.Cells.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
            
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int sheetIndex = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Adding a value to "A1" cell
worksheet.Cells["A1"].PutValue(1);

// Adding a value to "A2" cell
worksheet.Cells["A2"].PutValue(2);

// Adding a SUM formula to "A4" cell
worksheet.Cells["A3"].Formula = "=MIN(A1:A2)";

// Calculating the results of formulas
workbook.CalculateFormula();

// Get the calculated value of the cell
string value = worksheet.Cells["A3"].Value.ToString();

Console.WriteLine(value);
// Saving the Excel file
workbook.Save("output.xls");

Refer to the following article for working with formulas:
Using Formulas or Functions to Process Data

The latest free trial version can be downloaded here to test the product features:
Aspose.Cells for .NET (Latest Version)

A runnable solution is available here that can be used to test the new product features without any coding.