Notes: ------ When setting cell contents in code use the setformula method instead of: spread1.cells[1,1] := 'somedata'; do this spread1.setformula(1,1,'somedata'); Using spread1.cells[1,1,'somedata'] will result in the cell being blanked when the cell is entered at runtime and subsequently exited.