Android Question Error on write Formula to Excel File

[incendio]

Hi guys,

I am trying to write formula in Excel file via this library https://www.b4x.com/android/forum/threads/read-write-excel-files-on-android.25632/

I have formula =sum(D7: D22), wrote with this code

CL.InitializeFormula(i,Row,"sum(D7:D27)")

It didn't work. Opening excel file, the cell with that formula shows #N/A.

Anyone can help me to solve this ? Thanks in advance.

 

[DonManfred]

I have formula =sum(D7: D22), wrote with this code

D22 and D27 are different....

 

[incendio]

Sorry, it was typo, but event corrected to D22, formula still error.

 

[Erel]

Test the code posted here with the change I suggested: https://www.b4x.com/android/forum/threads/create-a-formulae-in-excel-spreadsheet.39652/#content

 

[incendio]

I end up to do all calculation & formating in B4A for 3 reasons :
1) Only use Sum formula, so it is easy to do calculation in B4A

2) Numeric value write with InitializeText recognize by Excel as numeric, so it is good, cause users can do another calculations if needed.

3) Excel library do not support numeric formatting to format 1000->1,000.00. In order to do this, I use template file, but if there is another formatting to cell, for example, add border, numeric formatting for that cell is gone. So I format 1000 to 1,000.00 in B4A, write it using InitializeText to Excel, and it all good.