<![endif]–> The expression: 1/(B$2:B2<>0) looks strange.
Do you have any plans to support it? I just came across it from a post. Do you know what it actually does (having to spend so much time in this space I assume that you might have come across it)?
Please provide us your source excel file having these formulas and sample code replicating this issue with the latest version. We will look into it and update you asap.
I guess the general question is whether aspose supports array formulas. I thought it did. There are some edge cases where you have operations such as 1 / which becomes an array <1/a1, 1/a2, …> where a1, a2 are the elements of the array.
If you want to test your product I came across this site: Excel is Fun!
They have a lot of different spreadsheets. They also have videos.
With regards to the second spreadsheet, if I run this function:
public static void TestArrayFormula2() { Workbook workbook = new Workbook(@“C:\temp\spreadsheets\EMT984.xlsx”); Worksheet sheet1 = workbook.Worksheets[0]; Worksheet sheet2 = workbook.Worksheets[1];
Thanks for the template files and sharing the sample code.
After an initial test, I noticed the issue i.e.., "#N/A" error for the formulas as you mentioned by using your template file "test03.xlsx" and sample code.
Yes, the exception was thrown when I used 7.5.1.0 . I posted the message, then I upgraded to 7.5.1.2, tested again, no exception was thrown so I updated the message.
What version of Excel did you use? I used Excel 2010 and it works fine. I clicked on the Calculate Now button, I pressed F9 and it is fine.
I am attaching it again just in case there was something wrong.
Thanks for providing further details and sample file.
Earlier I was using MS Excel 2007. Now I use MS Excel 2010 to evaluate the formula on G2 cell in the second sheet for your second file, it actually gives “happy” for its calculated value. I have also logged the problem to attach with your existing issue “CELLSNET-41874”, we will look into it as well.
Hello, can you please tell me what is the status of this?
I also have another issue (see the attached spreadsheet) that might be related.
This is the formula from the spreadsheet that doesn’t work in the Aspose calculation engine: =SUMPRODUCT(Table1[Value],(–(Table1[Date]>=DATEVALUE(“2013-09-15”))))
<![endif]–> Any chance that you might support these formulas as well?
Code:
using System; using System.Collections; using System.Data; using System.Drawing; using System.Drawing.Imaging; using System.Linq; using System.Linq.Expressions; using System.Text; using Aspose.Cells; using Aspose.Cells.Charts; using Aspose.Cells.Drawing; using Aspose.Cells.Pivot; using Aspose.Cells.Rendering; using Aspose.Cells.Tables; using TestAspose.NorthwindDataSetTableAdapters; //using pk =DocumentFormat.OpenXml.Packaging; //using ox=DocumentFormat.OpenXml; //using oxs = DocumentFormat.OpenXml.Spreadsheet;
Thanks for your posting and using Aspose.Cells for .NET.
We are afraid, your issue logged as CELLSNET-41874 is not resolved yet. Please spare us some time. Once, it is fixed or we have some other update for you, we will let you know asap.
We were also able to observe this issue with your sample code and source file. The calculated value is 360 for cell D1 but it prints 0 instead. We have logged this issue in our database. We will look into it and fix this issue if possible. Once, the issue is fixed or we have some other update for you, we will let you know asap.
Only CELLSNET-42038 has got resolved with the latest fix version. I am afraid, your other reported issue CELLSNET-41874 is still unresolved with our development team currently working on it. As soon as we receive any updates in this regard, we will post here for your reference.