Re: [libreoffice-users] Import into a Template

At 12:12 12/01/2014 -0800, J Taylor wrote:
> I have downloaded a c,s.v file from my Bank and created a Template 
> for the Bank listing. I can load the Bank file into a new 
> Spreadsheet and I then have to reformat it. Why can I not Import it 
> into the Template, or is there another way?

At 14:52 12/01/2014 -0800, J Taylor wrote:
> I open the CSV Template then I go to Insert Sheet from File > OK and 
> it creates another sheet either before or after the sheet from the 
> Template. I finish up with a two sheet file, one sheet Formatted and 
> the other sheet with the Bank info.

You are nearly there!

o Select the complete range of data on the new (unformatted) sheet.
o Copy the data.
o Paste the data into your empty (formatted) sheet, but using Edit | 
Paste Special ... (or Ctrl+Shift+V) instead of ordinary Paste.  In 
the Paste Special dialogue, remove the tick from Paste All if 
necessary and ensure that Formats is *not* ticked.
o Delete the imported sheet.

> What I want is a straight Import to wherever I have put the 
> cursor.  No complicated choices either.

Only you can decide if this is "complicated".

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted