[AccessD] Pasting into Excel

Consider that Paste includes some (not all) of the formatting - either actual as
in where Excel recognises dates (well, thinks? It has).
There is paste Special values that will not (well probably not) change the
formatting of cells.

Re dates - you will need to consider the data being posted (as in what is its
format) 
The country code of the OS, the country code of Excel, the defaults set, and
what format is specified for the cells getting the data.

AFAIK Excel  sets Wrap if it finds a newline in the text string

Now you mention Excel 2007, but do not explicitly state what version you are
using, or what OS, which could also have some effect on the clipboard handling.

Re your question: 
No! It's MS software!

JimB  
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, August 21, 2014 6:18 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Pasting into Excel

I know this question should really go to Excel-L rather than Access-D, but
you're all a smart bunch so I figured I'd ask here first. ;)


A pet peeve of mine is pasting data from and Access Query or SQL Server
Management Studio into Excel and the data is wrapped and dates always show
up weird.

I don't remember this occurring before Office 2007 (but I can't remember
past last weekend much less 7 years ago).

So every time I paste a big grid of data, I have to toggle "wrap text"
three times.

If I choose "Short Date" from the formatting drop down in the number
toolbar (in the ribbon) the dates will change to short dates.

If I past the same (or different) data from the clip board it reverts back,
losing the short data and non wrapped text formatting.

Am I silly to think it didn't work this way in earlier versions?

Thanks,
David
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com