Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | jhassell@stata.com |
To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
Subject | Re: st: Stata 12 bug report -export excel- |
Date | Fri, 19 Aug 2011 15:56:29 -0500 |
Daniel Green <Daniel.Green@ny.frb.org> 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 jhassell@stata.com * * 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/