Hi John,

Brian Barker wrote:
At 11:26 30/08/2009 -0700, John Gregson wrote:
Actually I did; I used bold on my comments. I am now using the font 'Arial Black'; we will see if this works.

Have you ever seen formatting in messages distributed by the list? I haven't.

Then immediately copy the material from the Calc spreadsheet.

Ah, you didn't say "Done" to that. Perhaps you missed that important bit?

Yes, I think you are correct. I assume you mean to copy the entire spreadsheet to memory (ctrl-c)?

Er, if you want squillions of empty fields and records, yes. I said to copy "the material": I don't see how you interpret that to mean the entire spreadsheet. Why not copy just the cells you need?

@Brian - granted it is overkill to copy the entire sheet, but the paste will not create "squillions" of empty records.
It will create empty records for gaps in the sheets cells:

Assume the sheet has 3 rows of data with a blank row between each, starting at row 1.
Copy the entire sheet and paste into base.
There will be 5 records created, 2 will have all NULL fields.

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to