I don't know of a way to do that in Calc. You could do that in a mail merge; create a data source from the spreadsheet, then drag the fields you want to see into a Writer document. You might also try using reports.
Dig deeper on Enterprise applications for Linux
Related Q&A from Solveig Haugland
Our expert tells you how to use search to find strings in OpenOffice.org's Calc.continue reading
An office suite expert describes how to use ODBC with OpenOffice 2.0.continue reading
An office suite expert describes where to find information on OpenOffice 2.0's use in the enterprise worldwide.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.