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.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy