Aspose beginner :)

[8-|]Hi guys…

I just started out with Aspose Excel…so I needed some information regarding the type of calculation engine aspose.excel is…

1. Is it multithreaded?
2. Is it pure .net?
3. When do you guys plan to grow the list of formulae supported to the list which excel supports?
4. What about automatic and manual recalcs?
5. Is the source code available(free/paid) to developers?

Thanks again for your time…

-safee

Dear Safee,

Thanks for considering Aspose.Excel.

1. Aspose.Excel can be used in a multithread environment. You can create several threads concurrently and manipulate files in each thread. However, we don’t guarantee concurrently manipulating a single file to be thread safe.

2. Aspose.Excel is totally written by C# code. And it make some Win32 API calls in a very small part of code.
To us, a pure .net component means it’s not a .NET wrapper around old ActiveX or DLL control. Many vendors I know did that when .NET just appeared.

The .NET Framework had tons of API calls in it, so is no ‘pure’. Please check http://www.hanselman.com/blog/content/radiostories/2003/05/13/theMythOfnetPurity.html

3. We will add this list per user’s request. If you have any requests on formulae, please let us know. We will add it to our work list and implement them ASAP.

4. We don’t provide automatic recalcs for it’s too time consuming. You can manually recalculate the formulas by calling Excel.CalculateFormula method.

5. For source code issue, please contact our sales team. They can be reached at sales@aspose.com.

Thanks Laurence for the prompt reply…

Also i had a query abt named references…

I am doing this in my code:

//start of test
m_SS = new Aspose.Excel.Excel();
Aspose.Excel.Cells cells = m_SS.Worksheets[0].Cells;
Aspose.Excel.Range range = cells.CreateRange(0,0,9,9);
range.Name = “Var”;
cells[“B3”].Formula = “=Var”;
Aspose.Excel.Cell cell1 = m_SS.Worksheets[0].Cells[0, 0];
cell1.PutValue(“Hello World!”);
m_SS.Save(“C:\file1.xls”,Aspose.Excel.FileFormatType.Default);
//end of test

and when i open the file file1.xls it shows #NAME instead of the value of the variable…


What may be going wrong in this case?

Thanks

Sorry, I made a mistake while mentioning the error…its not #NAME rather #VALUE!

and also i have moved the formula reference out of the range of the variable which is defined on 0,0 -? 9,9

-safee

Hi safee,

Please manually input the formula in a cell. You will also get this error.

So please change your code to:

Excel m_SS = new Aspose.Excel.Excel();
Aspose.Excel.Cells cells = m_SS.Worksheets[0].Cells;
Aspose.Excel.Range range = cells.CreateRange(0,0,1,1);
range.Name = “Var”;
cells[“B13”].Formula = “=Var”;
Aspose.Excel.Cell cell1 = m_SS.Worksheets[0].Cells[0, 0];
cell1.PutValue(“Hello World!”);
m_SS.Save(“C:\file1.xls”,Aspose.Excel.FileFormatType.Default);

Hello Laurence,

What do you mean by manually inputting the formula in the cell??

I read your code and its the same as mine…Please mention where have you modified the code…

Its still rerturning #VALUE!

Surprise[8-|]

-safee

Hi Safee,

This #VALUE error means you input a invalid formula. You can verify it by this:
1.Running MS Excel
2.Create a range named “Var” extending from A1 to I9.
3.In formula bar of Cell A11, input formula "=Var"

Then you will get #VALUE error.


My code is:

Aspose.Excel.Range range = cells.CreateRange(0,0,1,1);

And your code is:
Aspose.Excel.Range range = cells.CreateRange(0,0,9,9);

Hello Laurence,

The thing is, i have pasted your code in my application, and yet the same error value is visible when i open the file in excel…

Is this anything to do with recalc? or something else?

kind regards
safee

Hi Safee,

Which version are you using? Could you please upload your file here?

Thanks for the ultimate support services guys, keep it up! Yes

I am attaching my xls file here…

Also if i set the formula manually it works fine, but it shows the value error programmatically…

The version which i am using is 2.9.7.0…

I download this trial version from your website…

Thanks and Regards
safee

Hi safee,

You are very welcome.

This problem is already fixed. Please download the latest v3.0.2 at

Swashbuckling Support Guys!!

Thanks…

It worked just fine!!!

Yes

kindest regards
safee