Reports, Excel and "special="

[svannorden]

G'day all!

I've used REPORT with the "special=onestart/twostar/threestar" option to generate lovely tables that indicate statistically significant test statistics in the usual way.
When I select everything in the report window and use the menu to copy the results in as a TeX table, the table includes the stars.
However, when I attempt to export the report to Excel .xlsx format, all the stars are removed, leaving a lovely table of statistics without any indication of which ones are significant.
I've played with various alternatives ways to try to get my results into Excel without much tedious manual intervention, but without success.

So my questions are
1) Has anyone else run into this behavior? (I'd be happy to provide code to replicate the problem.)
2) Is this behavior documented somewhere?
3) Does anyone know of an alternative way to use the "special" option of REPORT to generate an excel-friendly table of statistics that indicates which ones are statistically significant?

Many thanks for your replies.

Simon van Norden

P.S. Using WinRATS 9.00f under Windows.

[TomDoan]

Those go into Excel as numbers, and I don't believe that Excel has any options to adorn numbers with anything like *'s. If you copy and paste as unformatted text, then it will create everything as text fields, which will include the *'s. (It will also do the rounded representations that are used in the TeX output rather than full-precision). However, the * fields won't be considered numbers in Excel and won't format up the way the other cells do. Don't people typically use colors or bolding to highlight in Excel. (RATS doesn't do color in reports---I'm just thinking of how I've seen that done in the past).