Dear Roy,
Thank you for your answer.
I'm not sure I've understood how fixcut works. I imagine the figures
refer to position of columns.
Following your example, when I type:
logout, save(C:\mytable) tex excel replace range(10/.) fixcut(27 38
45 50 67): tab dose function, col
I get exactly the same result than when I write:
logout, save(C:\mytable) tex excel replace range(10/.) fixcut(11
16 27 38 45 50 67): tab dose function, col
This is a silly example, but in longer tables I would expect that
changing figures in fixcut would modify where labels are split in
excel, but it is not the case: logout keeps breaking the labels in the
same points.
Angel Rodriguez-Laso
2009/10/14 Roy Wada <[email protected]>:
>> is split across two cells with two columns bellow it, one with blanks
>> and another one with the numbers. This is specially annoying when
>> copying cells inside Excel.
>>
>> Is there any way to correct this behaviour?
>
> The current help file says something about the need to let the user
> manually apply infix.
>
> A new option, fixcut( ) will handle this. The new version also comes
> with range( ) option that is basically -chewfile- running from the
> inside.
>
> -logout- will now display something like the following after every
> fixed method so that if you don't like it then you can change the
> numbers the next time around.
>
> fixcut(11 16 27 38 45 50 67)
>
> I should add that they should CONSECUTIVE NUMBERS.
>
> The new version should be up on ssc.
>
> Roy
>
> * The following three are equivalent:
> webuse dose, clear
> tab dose function, col
> chewfile using mylog.txt, begin(10) end(.) save(chewed.txt) replace
> logout, use(chewed.txt) clear fix
> logout, save(C:\mytable) tex excel replace
>
> webuse dose, clear
> logout, save(C:\mytable) tex excel replace range(10/.) fix: tab
> dose function, col
>
> webuse dose, clear
> logout, save(C:\mytable) tex excel replace range(10/.) fixcut(11
> 16 27 38 45 50 67): tab dose function, col
> *
> * 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/
>
*
* 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/
