BUG: Formula IsFormula returns false- but is actually a valid formula

Aspose.Cells Product Family
1

Hi,

I have a problem with an Excel 2007 file which I’ve attached for reference. The Aspose.Cells object model reports cell F39 as having no formula; i.e. IsFormula is false. However the cell does have a formula, which can be verified by opening the file in Excel. Note this cell is not the only incorrectly parsed item, other cells in the spreadsheet are incorrectly reported as having no formula.

Below is a code snippet I used to demonstrate this error:

class Program
{
public static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.Open(Path.Combine(Environment.CurrentDirectory, “Rand Version 2 Formula Deleted.xlsx”));

WriteCellDetails(workbook.Worksheets[0].Cells[38, 5]);
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
}

private static void WriteCellDetails(Cell cell)
{
Console.WriteLine("Name: " + cell.Name);
Console.WriteLine("Value: " + cell.Value);
Console.WriteLine("Formula: " + cell.Formula);
Console.WriteLine("IsFormula: " + cell.IsFormula);
Console.WriteLine("IsError: " + cell.IsErrorValue);
Console.WriteLine("IsMerged: " + cell.IsMerged);
}
}

Kind regards

–
Edward Wilde |http://blogs.edwardwilde.com|

2

Hi Edward,

Thanks for providing us the template file.

We found the issue after an initial test related RAND() formula, we will fix it soon.

Thank you.

3

Hi Amjad,

Thank you for your response. When a fix is available how will I be informed?

Kind regards Ed.

4

Hi,

Could you try the attached version (4.5.1.19), it fixes your issue.

Thank you.

5

Hi Amjad,

I can confirm that the attached Apose.Cells dll fixes the problem I reported. Thank you for the quick turn around.

Kind regards Ed.

6

The issues you have found earlier (filed as 6750) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Laurence.