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.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.