A
Aleramo
Guest
Hello to everybody! I have a problem, i am trying to assign a formula to a cell in excel, i read on this link community.progress.com/.../8040 that i have to use the command: w-formula = SUBSTITUTE ("=&1", wp-formula). ch_Worksheet_Dat:Cells(wp-row,wp-col):NumberFormat = 0. ch_Worksheet_Dat:Cells(wp-row,wp-col):Formula = w-formula. but when i go to the excel file, i see the cell is wrong like in the image below, to solve the problem i have to go in the fill in of the Formula, to push Enter and everything goes fine. Where do i wrong while i assign the formula to the cell? Have i to give some more statements?
Continue reading...
Continue reading...