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]