Android Question Add excel cell without reset the format

[baem]

Hi All,

i got problem when used

[CODE lang="b4x" title="add cell"]cell.InitializeText(9, (10+i), customer.text)
newsheet.AddCell(cell)[/CODE]

the added cell format is reset

 

[Lariliss]

Hi, I had a similar problem and found this thread helpful.

B4A Excel Library

Hello, In order to use an excel xls file like template for report i will to know if is possible modify cell value without lost the format and the borders defined in the template. If i use: cell.InitializeText(colonna, riga, row(r)) sheet1.AddCell(cell) i lost the format of the cell. Thanks in...

www.b4x.com

Hope, this works for you as well.