Free Support Forum - aspose.com

Experience with Cells as a backend .NET component in mono

I am new to this product, but I'm trying to evaluate if what I need to do is possible. I'll be developing in an OEM environment where the component appears in the UI of a Windows based client, but the backend (which also must use this component) may be running in Windows .NET or on Linux using Mono. What I need to do is ...

Define an instance of your component via some UI that does something like...
AsposeCellsSpreadsheet sheet = new AsposeCellsSpreadsheet();
sheet.Cells(0,0).Value = 1.0;
sheet.Cells(0,1).Formula = "=2*$a$1";

Now in my running application, I have code that works on a Windows or Linux-based compute environment...

AsposeCellsSpreadsheet sheet = the one I defined above;
sheet.Cells(0,0).Value = 2.0;
double newValue = sheet.Cells(0,1).GetRawValue();

Can you confirm if this should work in Mono on Linux?

Thanks!

Hi John,


Thank you for considering Aspose APIs.

I have tested the following piece of code in Ubuntu 15.10 under mono environment against the latest major release of Aspose.Cells for .NET 16.10.0, and I was not able to observe any problem.

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook();
Aspose.Cells.Worksheet worksheet = workbook.Worksheets [0];
Aspose.Cells.Cells cells = worksheet.Cells;
Aspose.Cells.Cell cell = cells [“A1”];
cell.PutValue (2);
cell = cells [“A2”];
cell.PutValue (2);
cell = cells [“A3”];
cell.Formula = “A1*A2”;
workbook.CalculateFormula ();
Console.WriteLine (cell.DoubleValue);