Not copying across the A into Excel

Submitted by philipjames on
Planning, Scheduling & Programming Discussion

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Wed, 2018-08-29 18:32
Permalink

copy paste special value ?

Member for

9 years 7 months
Member for 9 years 7 months
Submitted by philipjames on Wed, 2018-08-29 09:56
Permalink

Hi

 

Thank you for the reply.

So.... :-)

1. Yep, the activity is actulised. Both Start and Finish. For what it's worth, the time is the same? (I wonder if this is the issue, bug?)

2. If I copy and paste into Notepad the 'A' is there after the date and time

3. No matter of differing formatting options in Excel does it resolve the issue?

Member for

8 years 1 month
Member for 8 years 1 month
Submitted by StevenA on Tue, 2018-08-28 18:09
Permalink

Philip,

Have you checked the excel formatting to see if it is being pasted in at a date time format?

Check to make sure that the cells where the date field is being pasted into is set to text format then try pasting in the values again.

I’m guessing that the values in Primavera have actual start / finish dates applied and are showing with the A in the date field.

Try pasting the values into notepad to see if it is the same there as well.

It should paste as tab separated text from there.

Steven

Member for

9 years 7 months
Member for 9 years 7 months
Submitted by philipjames on Tue, 2018-08-28 15:59
Permalink

Hi

Thank you for your reply. I've tried that, copying and pasting I've done. CRTL A CRTL V, and other such button bashing.

It's that the A on only some activities isn't copied.

Some actulised Activities, the A is copied. Others. It's not?

Oddly. If you remove the 'time' the A will paste into Excel. However, if you keep the time on. The A is not copied? (and it's not the width of the excel column either.....

Member for

16 years 3 months
Member for 16 years 3 months
Submitted by Zoltan Palffy on Tue, 2018-08-28 14:04
Permalink

you can export the activities or highlight al of them then right click and select copy to excel