Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.