search

arikdan / as3xls

Automatically exported from code.google.com/p/as3xls
0 stars 0 forks source link

Unable to SET formula's when creating a spreadsheet #10

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Create a new sheet
2. Create a new cell sheet.setCell(0, 0, "=1+10");

What is the expected output? What do you see instead?
I would expect to see the value 11 in that cell, but instead i am left with the 
string =1+10

Please provide any additional information below.
Can you please tell me how i can achieve this, or if you have plans to support 
this? Am very keen to 
get this to work, happy to implement myself, if you can offer me a couple of 
pointers.

Original issue reported on code.google.com by rawjam.d...@googlemail.com on 27 May 2009 at 5:10

GoogleCodeExporter commented 9 years ago 
just write 
cell sheet.setCell(0, 0, Number(1+10));

Original comment by brad.ins...@gmail.com on 26 Mar 2010 at 12:07

GoogleCodeExporter commented 9 years ago 
Hi,all.
   I would like to writing formula to the excel file.For example: '=A1+A2'.
I mean that if I change the values in A1 Cell or A2 Cell in the excel file,the 
cell which hold the formula accordingly could change.
How can I implement that functionality?

Regards,
Daniel,Liu

Original comment by liumm0...@gmail.com on 10 Jun 2010 at 2:50

GoogleCodeExporter commented 9 years ago 
Hi Daniel,

I am also trying to do the same, any luck with you ?

Thanks!

Original comment by seth.vai...@gmail.com on 5 Feb 2011 at 12:23