Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Stata 12 bug report -export excel-
From
[email protected]
To
[email protected]
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/