Android Question Add Formula to Excel FIle

[ilan]

hi

i am adding a formula to an excel file using initializeFormula method.
everything works fine but the only issue is that for some reason a number appear at that cell BUT after clicking on enable editing the correct value appears.

before "enable editing"

after "enable editing"

this is a simple HYPERLINK formula but also other formulas like SUM ... give the same results.
why is it like this?

thanks

 

[Erel]

It will probably not work but try:

Dim wcf As WritableCellFormat
wcf.Initialize
wcf.As(JavaObject).RunMethod("setLocked", Array(False))
YourCell.SetCellFormat(wcf)

 

[ilan]

It will probably not work but try:

Dim wcf As WritableCellFormat
wcf.Initialize
wcf.As(JavaObject).RunMethod("setLocked", Array(False))
YourCell.SetCellFormat(wcf)

thanks erel for your answer
as you already assumed the code is not working, i still get 4 before enable editing but now after enable editing i am getting an error for the file and a NA value.

 

[Erel]

You can make a test with POI + XLUtils (B4J). I don't remember encountering such issue.

And maybe load a template with the formula.