Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Logout splits long value names across many cells in Excel


From   Ángel Rodríguez Laso <angelrlaso@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Logout splits long value names across many cells in Excel
Date   Mon, 26 Oct 2009 13:36:24 +0100

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 <roywada@gmail.com>:
>> 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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index