Android Question Add Formula to Excel FIle

ilan · Aug 31, 2025

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 · Aug 31, 2025

It will probably not work but try:

B4X:

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

ilan · Aug 31, 2025

Erel said:
It will probably not work but try:

B4X:

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 · Sep 1, 2025

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

And maybe load a template with the formula.

Android Question Add Formula to Excel FIle

ilan

Expert

Erel

B4X founder

ilan

Expert

Erel

B4X founder

Similar Threads

Android Question Add Formula to Excel FIle

ilan

Expert

Erel

B4X founder

ilan

Expert

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency