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]
Re: st: Stata 12 bug report -export excel-
From
[email protected]
To
"[email protected]" <[email protected]>
Subject
Re: st: Stata 12 bug report -export excel-
Date
Fri, 19 Aug 2011 15:56:29 -0500
Daniel Green <[email protected]> wrote :
>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
Daniel has found a bug in -export excel-. As Daniel suggested the bug
occurs when a special graph-only sheet exists before the specified sheet
in the -export excel- command. We have identified the problem and will
release a fix in an upcoming update.
-- James
[email protected]
*
* 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/