We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Reading the formula value from an Excel sheet

Aspose.Cells Product Family
#1

Hi ,

I am trying to read a spread sheet with formulae .When I do so , I am not able to get the value , instead what I get is a string value #Name?
Eg below
workBook.Worksheets[0].Cells[rowCounter, columnCounter].Value
The first thing I do after I open the spreadsheet is doWorkbook.CalculateFormula(); However this does not seem to have any effect.
Any advise would be appreciated.
Version I am using is 4.8.1.6
Thanks
#2

Hi,

Could you post your template file here and point out which cell value is #Name?.

Thank you.

#3

Please find attached the spread sheet in question . Example of one of the cells that we are having issues with are in Column E,Column I etc . To summarize we are not able to read the value of any cell with a formula

#4

Hi,

We found the issue using your template file and extracting the calculated values in I Column.

Your issue has been registered into our issue tracking system with an issue id: CELLSNET-12533.
We will figure it out soon.

Thank you.

#5

Hi,

rgin: 0pt;
font-family: Arial,Verdana,Tahoma;
font-size: 12px;
}
.footer { color:Gray; font-size: 11px; text-align: center; }
.back1 { background-color: whitesmoke; }
.back2 { background-color: #f1f5e1; }
.back3 { background-color: cornsilk; }

Actually, we do not support the referred row index >= 65536 and column index >= 255 in formulas. We are working on this issue now.
We will let you know when it is done!

Thanks for your patience.
#6

Since excel 2007 supports more that 255 columns we anticipate having data and formulae in those columns. Would you happen to have an ETA on when we can get a resolution to this issue

Thanks

#7

Hi,

Thank you for considering Aspose.

We will get back to you soon regarding the ETA on this enhancement.

Thank You & Best Regards,

#8

Hi,

Since it is a bit complex feature, hopefully we can support it at the end of Q1 2010 or at the start of Q2 2010.

Thank you.

#9

Do you have an update on the status of the bug fix on Formulas within the 255 column limit not flowing through?

We have a dead line that we are working against and really need a resolution for it

#10

Hi,

Please try this fix (attached).

We have provided a temporary resolution in this fix. Hopefully, it will meet your needs.


Thank you.


#11

Hello,

Any update yet on the issue relating to formulas in columns 256 and greater? We're still experiencing this issue and it's causing some major problems.

Thank you.

#12

Hi,

The issue is not resolved yet, we will inform you when it is sorted out.

Thank you.

#13

Hi,

To further update you, we will try to implement it in the next month.

So keep in touch.

Thank you.

#14

Hi,

Please try the attached latest version of Aspose.Cells. We have removed the limitation of the formula reference.

Thank You & Best Regards,