Apache OpenOffice Community Forum

Am using this line to store a value in a cell:
'ocell = oSheet.getCellrangeByname("E1").SetString(txtFlowrateCase1.Text) 'set string
but i have 5 records t and am printing all the records together
It only prints the record which is displayed.(data which is currrently displayed in the textbox)What about the record which i have already stored from the same textbox?
How do i Print them all together?
The data is Different in each record accepted by the same textbox

Do you want to store the five values in E1 or do you want them to be in five separate cells?

That doesn't make sense. You are talking about printing and storing as if it's the same thing. I suppose that you want to store the data in Record 1, currently displayed in a text box, in cell E1, the data in Record 2 in cell E2, etc. If so, you have to navigate through your database table, fetching one record at a time, then grabbing the data. Repeat until end of table.