On 4 January 2011 08:32, PJH <pj...@pobox.com> wrote: > Gene Young has written on 1/2/2011 11:19 AM: > > On 1/2/2011 11:03 AM, PJH wrote: > >> Brian Barker has written on 1/1/2011 7:03 PM: > >>> 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. > >> > >> At the bottom of the screen, there are 9 tabs, labeled Page 1, Page 2, > >> Page 3, etc. > >> > >>> 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. > >> > >> Easy enough. Thanks. > >> > > > > Even easier, insert a new sheet (call it all or something appropriate.) > > Copy and paste each sheet sequentially into the new sheet. Add the info > > from each sheet at the row immediately following the last row holding > > information. Then export that sheet as a single CSV file. This works > > best if all the sheets are formatted with the same columns and headers. > > This method saves having to concatenate them later. > > Is there a trick to copying a whole sheet? > > > > Click in the white box to the left of the column letters (headings) and above the row numbers; edit>copy; move to new sheet; edit>paste
-- Harold Fuchs London, England Please reply *only* to users@openoffice.org
