At 17:53 01/01/2011 -0500, Ponly Jonly Honly wrote:
I have a spreadsheet that has 9 pages (sheets). How do I save the entire thing to a single CSV file?
You do mean sheets, not pages, don't you? The number of (printed output) pages is irrelevant, of course.
I think the simple answer - as you have no doubt discovered - is that you don't. But you can easily save all the material in one of two ways:
o Save each sheet separately as a CSV file. Note that saving in CSV format saves the current sheet, so you can save each sheet by displaying it in turn. These CSV files are plain text files, so you can then very easily concatenate them in any text editor (even in Writer, if you like) to achieve what you probably need.
o Alternatively, you could copy all the material (using copy-and-paste) into a single (new?) sheet first and then save that in CSV format. It may be simpler to use Paste Special, so that you can paste values and not formulae. It would not matter that you lose such formulae and the connections they embody, since these would not be saved in the CSV format anyway. There is no need to modify or destroy the original sheets or file, of course.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
