Hi,
I tested your scenario with our latest version v5.3.3 using the following code, it works absolutely fine. I have attached the output file here for your reference too.
Sample code:
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
ws.Cells[“B1”].PutValue(100);
ws.Cells[1, 1].Formula = “=B1/10”;
wb.CalculateFormula();
MessageBox.Show(ws.Cells[“B2”].StringValue); //10 fine.
wb.Save(“e:\test2\ouputcellvaluetest.xlsx”);
Thank you.
Ya i am sorry that is working fine for me as well but i cant use cell a formula as there is a issue in your platform with ID 28365 in which i cant use cell as formula as it wont display its bas when i use OLE frame so i want to assign the value of one cell to the other without formula like
cells(1, 0).PutValue("=B1")
or
cells(1, 0).value="=B1"
or anything else as i need a workaround to this when till u people solve the 2836
Thanks & Regards
Lakdawala Zaid
Hi,
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
ws.Cells[“B1”].PutValue(100);
ws.Cells[“C1”].PutValue(ws.Cells[“B1”].Value);
ws.Cells[“D1”].PutValue((int)ws.Cells[“B1”].Value / 10);
wb.Save(“C:\temp\out.xlsx”);
I understand this but i have one doubt suppose i want a value from the cell for which the value i will insert after this cell for e.g
Cell(0,0)=10
cell(0,1)=cell(“B2”).value
cell(1,0)=20
cell(1,1)=30
in the above the Cell B2 i am creating on the 4th line,in this case it will not give me the value 30 but will give me nothing
this case use to work fine with formula
Cell(0,0)=10
cell(0,1).Formula = “=B1”
cell(1,0)=20
cell(1,1)=30
But i cant use formula and about issue 28365 your executive Mudassir Fayyaz send me the number u can check this link please
Ole frame doesnt work when cells haing Formula
Thanks & Regards
Lakdawala Zaid
Hi Zaid,
Hello,
i have used the latest dll 6.0.0 of aspose.cells and still that issue exist
this issue is taking my head off i am not getting the proper solution for it neither from cells team not from slides team
Kindly communicate with the concern person and provide me at least some work around.
Thanks & Regards
Lakdawala Zaid
Hi Zaid,