Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Stata 12 bug report -export excel-


From   Daniel.Green@ny.frb.org
To   statalist@hsphsun2.harvard.edu
Subject   st: Stata 12 bug report -export excel-
Date   Fri, 19 Aug 2011 15:01:59 -0400

Hi,

I have been very excited to try the new export excel feature in Stata but 
have unfortunately already found a large (for my uses) bug.  It seems bad 
things happen when I try to modify an excel file that has a chart moved to 
its own sheet.   I have reproduced this with the auto dataset below:

sysuse auto, clear
export excel using "test.xlsx", sheetmodify sheet("SheetOne") 
firstrow(varl)
//open the file in Excel and make a graph, move it to its own sheet by 
right clicking and select move, to new sheet.  Then save the file.
replace p
rice = -1*price
export excel using "test.xlsx", sheetmodify sheet("SheetOne") 
firstrow(varl)

Note the commented instructions to create a graph in Excel.   The second 
export statement crashes Stata.   This seems to only happen if the graph 
is moved to a special "graph only" sheet.  There are no issues if you copy 
the graph to another regular excel sheet or leave the g

I am using Windows XP SP3, Stata 12.0 (Aug 8, 2011 update), and Excel 
2007.

Can anyone reproduce this error on a different setup?

Thanks,

Daniel







This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential or proprietary information.  If you are not the intended recipient, immediately contact the sender by reply e-mail and destroy all copies of the original message.
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index