settextcolor copy to excel

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

bparksb
Posts: 56
Joined: Mon Mar 21, 2011 9:26 pm

settextcolor copy to excel

Postby bparksb » Fri Sep 20, 2013 11:40 am

Consider

Code: Select all

table colorresults colorresults(1,1)="Green" colorresults(2,1)=3 colorresults.settextcolor(1,1) green colorresults.settextcolor(2,1) red
If the entries are copied to Excel, no color. If the entries are copied to Word, color. If the entries are then copied from Word to Excel, color. Note that Gareth's ARIMAsel labels an entry with settextcolor red and has the same behavior.

I doubt this is a bug in Eviews, but I didn't think it was a programming question either so I posted here.

Eviews version 8 Sep 12 2013 build MS Office 2010 (same behavior in Eviews 7 and MS Office 2003/7)

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: settextcolor copy to excel

Postby EViews Jason » Mon Sep 23, 2013 8:13 am

Unfortunately EViews currently does not place on the clipboard a format which is readable by Excel that handles colors. The only format that EViews is providing that contains color is RTF. This is readable by Word but not Excel.

When you copy the table in Word, Word appears to be placing a Microsoft Word Document Object on the clipboard.

We will add this to our list of things to investigate for future versions.

bparksb
Posts: 56
Joined: Mon Mar 21, 2011 9:26 pm

Re: settextcolor copy to excel

Postby bparksb » Mon Sep 23, 2013 3:40 pm

OK Thanks


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests