Copy table (Ctrl+Shift+C) and paste issue in Stata 15

[Rasool Baloch]

Dear Statalist,

I am facing an issue in copying tab command results to excel using shortcut menu Copy table (Ctrl+Shift+C) and paste in Excel 2015. It is omitting negative sign from the numbers.

clear
input num
-3.2568
3.23658
-2.3657
6.3987
-5.3698
end

tab num

I am selecting the results and using copytable from shortcut mene and pasting in excel it eliminate negative sign. Please suggest me in this regard.

Thanks\Rasool Bux

[Marcos Almeida]

I can copy from the Data Editor and paste in Excel without any problem.

Maybe you should prefer to export the data, instead.

[William Lisowski]

I have confirmed on my Mac that the problem occurs there as well, both with Copy table and with Copy table as HTML.

To be honest, I was unable to find documentation for these two menu command in the Stata PDFs. It seems to me their emphasis is now on using the Data Editor. That doesn't solve the problem of conveniently grabbing output from the Results window to use for other purposes. The problem appears to be limited to having a minus sign in the first column.

I encourage you to report this apparent bug to Stata Technical Services at https://www.stata.com/support/tech-support/

[Rasool Baloch]

There is another solution for this. We can use -tab2xl- package (net install tab2xl) for oneway table and -tab2xl2- for twoway tables to export in excel.

https://github.com/leonardoshibata/tab2xl2

Best Regards,
Rasool Bux