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

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » BUG: Formula IsFormula returns false, but is actually a valid formula

Last post 12-15-2008, 1:42 AM by Laurence. 5 replies.


	Sort Posts: Previous Next

11-21-2008, 4:02 AM 153610

duarteconsulting
Joined on 11-19-2008
Posts 3
Issues: CELLSNET-6750 (Unknown)

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

Attachment: Present (inaccessible)

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 |

Filed under: Aspose.Cells bug;Aspose.Excel;Formula

11-21-2008, 5:24 AM 153617 in reply to 153610

Amjad Sahi
Joined on 08-30-2006
Posts 18,410

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

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.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

11-21-2008, 6:26 AM 153633 in reply to 153617

duarteconsulting
Joined on 11-19-2008
Posts 3

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

Hi Amjad,

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

Kind regards Ed.

11-24-2008, 6:56 AM 153882 in reply to 153633

Amjad Sahi
Joined on 08-30-2006
Posts 18,410

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

Attachment: Present (inaccessible)

Hi,

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

Thank you.

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

11-26-2008, 4:23 AM 154232 in reply to 153882

duarteconsulting
Joined on 11-19-2008
Posts 3

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

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.

12-15-2008, 1:42 AM 156430 in reply to 153610

aspose.notifier
Joined on 04-14-2009
Posts 8,872

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

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.