Re: Table Challenge

2010-01-22 Thread Steve Sidney

Hi Rob and list

After posting the same message on the Latex Community forum I was informed 
of a relatively new tool called datatool which appears to solve the problem.


Unofrtunately I can't seem to get this package to work in Lyx.


Has anybody had any experience with datatool and Lyx

Any help would really be appreciated

Regards
Steve

- Original Message - 
From: Rob Oakes lyx-de...@oak-tree.us

To: 'SteveSB' sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-22 Thread Steve Sidney

Hi Rob and list

After posting the same message on the Latex Community forum I was informed 
of a relatively new tool called datatool which appears to solve the problem.


Unofrtunately I can't seem to get this package to work in Lyx.


Has anybody had any experience with datatool and Lyx

Any help would really be appreciated

Regards
Steve

- Original Message - 
From: Rob Oakes lyx-de...@oak-tree.us

To: 'SteveSB' sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-22 Thread Steve Sidney

Hi Rob and list

After posting the same message on the Latex Community forum I was informed 
of a relatively new tool called datatool which appears to solve the problem.


Unofrtunately I can't seem to get this package to work in Lyx.


Has anybody had any experience with datatool and Lyx

Any help would really be appreciated

Regards
Steve

- Original Message - 
From: "Rob Oakes" <lyx-de...@oak-tree.us>

To: "'SteveSB'" <sbsid...@mweb.co.za>
Cc: <lyx-users@lists.lyx.org>
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-20 Thread Steve Sidney

Rob

Thanks. Although I haven't used the longtable package, I am aware of its 
exsistence.


My report is already some 30 odd pages and if I allow each table to take 2 
pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then importing 
it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.

Regards
Steve


- Original Message - 
From: Rob Oakes lyx-de...@oak-tree.us

To: 'SteveSB' sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-20 Thread Steve Sidney

Liviu

Thanks for the response and the interest

I currently do it manually but copy/paste from Excel into Word. I use R to 
do the analysis and then write a csv file which I manipulate in Excel and 
paste into Word


I am aware of long tables and xtable but that does not solve the problem of 
splitting the number of rows in half and placing them side by side on one 
page


Also see my response to Rob

Regards
Steve


- Original Message - 
From: Liviu Andronic landronim...@gmail.com

To: SteveSB sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Wednesday, January 20, 2010 12:01 AM
Subject: Re: Table Challenge



Hello

On 1/19/10, SteveSB sbsid...@mweb.co.za wrote:

 I have managed to get the Sweave/Lyx link in MS Windows working but my
 problem is the follows.


In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy  paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


 d33ww   2.933.000.62-1.66   tatc4   2.65 
2.64-1.09   0.10
 dml25   2.782.78-0.39   -0.12   u3dd5   2.62 
2.69-1.04   -1.68
 e33ws   2.953.020.73-1.69   u6d33   2.72 
2.72-0.71   -0.30
 f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.09 
1.21-0.68
 f3s5t   2.832.900.09-1.73   v44h6   2.72 
2.73-0.66   -0.29
 f44ee   2.792.77-0.39   0.20wa5hh   #   # 
N/A N/A

 g2a44   2.762.77-0.45   -0.28

 My question is there way a that Lyx/Latex can do this without my manual
 intervention.


Again, how do you manually split  it? Copy  paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu





Re: Table Challenge

2010-01-20 Thread Daniel Lohmann


On 20.01.2010, at 11:25, Steve Sidney wrote:


Rob

Thanks. Although I haven't used the longtable package, I am aware of  
its exsistence.


My report is already some 30 odd pages and if I allow each table to  
take 2 pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then  
importing it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.



Another quick shot idea: Use longtables in combination with multicol  
to let your table break over two columns on the same page.


Don't know if this exactly works, though.

Daniel



Re: Table Challenge

2010-01-20 Thread Steve Sidney

Rob

Thanks. Although I haven't used the longtable package, I am aware of its 
exsistence.


My report is already some 30 odd pages and if I allow each table to take 2 
pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then importing 
it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.

Regards
Steve


- Original Message - 
From: Rob Oakes lyx-de...@oak-tree.us

To: 'SteveSB' sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-20 Thread Steve Sidney

Liviu

Thanks for the response and the interest

I currently do it manually but copy/paste from Excel into Word. I use R to 
do the analysis and then write a csv file which I manipulate in Excel and 
paste into Word


I am aware of long tables and xtable but that does not solve the problem of 
splitting the number of rows in half and placing them side by side on one 
page


Also see my response to Rob

Regards
Steve


- Original Message - 
From: Liviu Andronic landronim...@gmail.com

To: SteveSB sbsid...@mweb.co.za
Cc: lyx-users@lists.lyx.org
Sent: Wednesday, January 20, 2010 12:01 AM
Subject: Re: Table Challenge



Hello

On 1/19/10, SteveSB sbsid...@mweb.co.za wrote:

 I have managed to get the Sweave/Lyx link in MS Windows working but my
 problem is the follows.


In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy  paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


 d33ww   2.933.000.62-1.66   tatc4   2.65 
2.64-1.09   0.10
 dml25   2.782.78-0.39   -0.12   u3dd5   2.62 
2.69-1.04   -1.68
 e33ws   2.953.020.73-1.69   u6d33   2.72 
2.72-0.71   -0.30
 f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.09 
1.21-0.68
 f3s5t   2.832.900.09-1.73   v44h6   2.72 
2.73-0.66   -0.29
 f44ee   2.792.77-0.39   0.20wa5hh   #   # 
N/A N/A

 g2a44   2.762.77-0.45   -0.28

 My question is there way a that Lyx/Latex can do this without my manual
 intervention.


Again, how do you manually split  it? Copy  paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu





Re: Table Challenge

2010-01-20 Thread Daniel Lohmann


On 20.01.2010, at 11:25, Steve Sidney wrote:


Rob

Thanks. Although I haven't used the longtable package, I am aware of  
its exsistence.


My report is already some 30 odd pages and if I allow each table to  
take 2 pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then  
importing it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.



Another quick shot idea: Use longtables in combination with multicol  
to let your table break over two columns on the same page.


Don't know if this exactly works, though.

Daniel



Re: Table Challenge

2010-01-20 Thread Steve Sidney

Rob

Thanks. Although I haven't used the longtable package, I am aware of its 
exsistence.


My report is already some 30 odd pages and if I allow each table to take 2 
pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then importing 
it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.

Regards
Steve


- Original Message - 
From: "Rob Oakes" <lyx-de...@oak-tree.us>

To: "'SteveSB'" <sbsid...@mweb.co.za>
Cc: <lyx-users@lists.lyx.org>
Sent: Tuesday, January 19, 2010 11:24 PM
Subject: RE: Table Challenge



Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview 
on

how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table 
on

every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za]
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure 
the

table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 
col


lab_id A B ZBW ZWI
4er66 3.60 3.30 3.26 6.49
4gcyi 2.96 2.91 0.47 1.10
5d3hh 3.08 3.11 1.34 -0.88
5d3wt 1.79 1.85 -5.60 -1.56
5ycya # # N/A N/A

Middle rows removed to save space

t5ee2 2.43 2.45 -2.23 -0.46
t9455 3.00 2.97 0.74 0.67
ta4ww 2.46 2.47 -2.09 -0.41
tatc4 2.65 2.64 -1.09 0.10
u3dd5 2.62 2.69 -1.04 -1.68
u6d33 2.72 2.72 -0.71 -0.30
v3s8f 3.06 3.09 1.21 -0.68
v44h6 2.72 2.73 -0.66 -0.29
wa5hh # # N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id A B ZBW ZWI lab_id A B ZBW
ZWI
4er66 3.60 3.30 3.26 6.49 h2o42 3.00 2.95 0.69
0.89
4gcyi 2.96 2.91 0.47 1.10 h5s22 3.86 3.79 5.30
1.44
5d3hh 3.08 3.11 1.34 -0.88 h7ss2 2.48 2.00
-3.32 10.35
5d3wt 1.79 1.85 -5.60 -1.56 i8s4b 2.90 2.86 0.16
0.64
5ycya # # N/A N/A ky3sn 2.94 2.93 0.47
0.21

Middle rows removed to save space

d33ww 2.93 3.00 0.62 -1.66 tatc4 2.65 2.64
-1.09 0.10
dml25 2.78 2.78 -0.39 -0.12 u3dd5 2.62 2.69
-1.04 -1.68
e33ws 2.95 3.02 0.73 -1.69 u6d33 2.72 2.72
-0.71 -0.30
f3c4g 2.72 2.74 -0.66 -0.65 v3s8f 3.06 3.09 1.21
-0.68
f3s5t 2.83 2.90 0.09 -1.73 v44h6 2.72 2.73
-0.66 -0.29
f44ee 2.79 2.77 -0.39 0.20 wa5hh # # N/A
N/A
g2a44 2.76 2.77 -0.45 -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions 
please

shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.






Re: Table Challenge

2010-01-20 Thread Steve Sidney

Liviu

Thanks for the response and the interest

I currently do it manually but copy/paste from Excel into Word. I use R to 
do the analysis and then write a csv file which I manipulate in Excel and 
paste into Word


I am aware of long tables and xtable but that does not solve the problem of 
splitting the number of rows in half and placing them side by side on one 
page


Also see my response to Rob

Regards
Steve


- Original Message - 
From: "Liviu Andronic" <landronim...@gmail.com>

To: "SteveSB" <sbsid...@mweb.co.za>
Cc: <lyx-users@lists.lyx.org>
Sent: Wednesday, January 20, 2010 12:01 AM
Subject: Re: Table Challenge



Hello

On 1/19/10, SteveSB <sbsid...@mweb.co.za> wrote:

 I have managed to get the Sweave/Lyx link in MS Windows working but my
 problem is the follows.


In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy & paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


 d33ww   2.933.000.62-1.66   tatc4   2.65 
2.64-1.09   0.10
 dml25   2.782.78-0.39   -0.12   u3dd5   2.62 
2.69-1.04   -1.68
 e33ws   2.953.020.73-1.69   u6d33   2.72 
2.72-0.71   -0.30
 f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.09 
1.21-0.68
 f3s5t   2.832.900.09-1.73   v44h6   2.72 
2.73-0.66   -0.29
 f44ee   2.792.77-0.39   0.20wa5hh   #   # 
N/A N/A

 g2a44   2.762.77-0.45   -0.28

 My question is there way a that Lyx/Latex can do this without my manual
 intervention.


Again, how do you manually split  it? Copy & paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu





Re: Table Challenge

2010-01-20 Thread Daniel Lohmann


On 20.01.2010, at 11:25, Steve Sidney wrote:


Rob

Thanks. Although I haven't used the longtable package, I am aware of  
its exsistence.


My report is already some 30 odd pages and if I allow each table to  
take 2 pages it will make it even more bulky.


There seems to be two alternatives.
1) Carry on preparing the table by hand as I currently do and then  
importing it directly into Lyx.

2) Attempt to create the table in R.

Do you think it's worth the effort to do this in R.



Another quick shot idea: Use longtables in combination with multicol  
to let your table break over two columns on the same page.


Don't know if this exactly works, though.

Daniel



Table Challenge

2010-01-19 Thread SteveSB

Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW 
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00-3.32   
10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64-1.09   
0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69-1.04   
-1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72-0.71   
-0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73-0.66   
-0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A 
N/A
g2a44   2.762.77-0.45   -0.28   

My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve 
-- 
View this message in context: 
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.


RE: Table Challenge

2010-01-19 Thread Rob Oakes
Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview on
how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table on
every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za] 
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00
-3.32   10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64
-1.09   0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
-1.04   -1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72
-0.71   -0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73
-0.66   -0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A
N/A
g2a44   2.762.77-0.45   -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.



Re: Table Challenge

2010-01-19 Thread Liviu Andronic
Hello

On 1/19/10, SteveSB sbsid...@mweb.co.za wrote:
  I have managed to get the Sweave/Lyx link in MS Windows working but my
  problem is the follows.

In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy  paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


  d33ww   2.933.000.62-1.66   tatc4   2.652.64
 -1.09   0.10
  dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
 -1.04   -1.68
  e33ws   2.953.020.73-1.69   u6d33   2.722.72
 -0.71   -0.30
  f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21 
-0.68
  f3s5t   2.832.900.09-1.73   v44h6   2.722.73
 -0.66   -0.29
  f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A  
N/A
  g2a44   2.762.77-0.45   -0.28

  My question is there way a that Lyx/Latex can do this without my manual
  intervention.

Again, how do you manually split  it? Copy  paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu


Table Challenge

2010-01-19 Thread SteveSB

Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW 
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00-3.32   
10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64-1.09   
0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69-1.04   
-1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72-0.71   
-0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73-0.66   
-0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A 
N/A
g2a44   2.762.77-0.45   -0.28   

My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve 
-- 
View this message in context: 
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.


RE: Table Challenge

2010-01-19 Thread Rob Oakes
Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview on
how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table on
every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za] 
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00
-3.32   10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64
-1.09   0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
-1.04   -1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72
-0.71   -0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73
-0.66   -0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A
N/A
g2a44   2.762.77-0.45   -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.



Re: Table Challenge

2010-01-19 Thread Liviu Andronic
Hello

On 1/19/10, SteveSB sbsid...@mweb.co.za wrote:
  I have managed to get the Sweave/Lyx link in MS Windows working but my
  problem is the follows.

In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy  paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


  d33ww   2.933.000.62-1.66   tatc4   2.652.64
 -1.09   0.10
  dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
 -1.04   -1.68
  e33ws   2.953.020.73-1.69   u6d33   2.722.72
 -0.71   -0.30
  f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21 
-0.68
  f3s5t   2.832.900.09-1.73   v44h6   2.722.73
 -0.66   -0.29
  f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A  
N/A
  g2a44   2.762.77-0.45   -0.28

  My question is there way a that Lyx/Latex can do this without my manual
  intervention.

Again, how do you manually split  it? Copy  paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu


Table Challenge

2010-01-19 Thread SteveSB

Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

>From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW 
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00-3.32   
10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64-1.09   
0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69-1.04   
-1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72-0.71   
-0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73-0.66   
-0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A 
N/A
g2a44   2.762.77-0.45   -0.28   

My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve 
-- 
View this message in context: 
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.


RE: Table Challenge

2010-01-19 Thread Rob Oakes
Hi Steve,

Yes, you can automatically insert page breaks into a long table.  This is
done through the use of the longtable package.  There is a good overview on
how to use longtable in the LyX user manual.  Longtable has a few nice
features, such as the ability to automatically add a  header to the table on
every page.

I am not, aware of a way to automatically split a given table into two
sections, however.  Perhaps others on the list might be able to provide
additional recommendations?

Cheers,

Rob Oakes

-Original Message-
From: SteveSB [mailto:sbsid...@mweb.co.za] 
Sent: Tuesday, January 19, 2010 1:48 PM
To: lyx-users@lists.lyx.org
Subject: Table Challenge


Dear list

As very much a Lyx/Latex newbie, I hope that this is not too difficult a
problem to be resolved.

I produce a multi-col table of data in R and at the moment I reconfigure the
table in Excel so that I can copy/paste it into a report in Word.

I have managed to get the Sweave/Lyx link in MS Windows working but my
problem is the follows.

>From the R code the table looks like this - up to 80 rows or more and 5 col
 
lab_id  A   B   ZBW ZWI
4er66   3.603.303.266.49
4gcyi   2.962.910.471.10
5d3hh   3.083.111.34-0.88
5d3wt   1.791.85-5.60   -1.56
5ycya   #   #   N/A N/A

Middle rows removed to save space

t5ee2   2.432.45-2.23   -0.46
t9455   3.002.970.740.67
ta4ww   2.462.47-2.09   -0.41
tatc4   2.652.64-1.09   0.10
u3dd5   2.622.69-1.04   -1.68
u6d33   2.722.72-0.71   -0.30
v3s8f   3.063.091.21-0.68
v44h6   2.722.73-0.66   -0.29
wa5hh   #   #   N/A N/A

Since this does not fit on a single A4 page (portrait), I then manually
split the table in half and it looks like this

lab_id  A   B   ZBW ZWI lab_id  A   B   ZBW
ZWI
4er66   3.603.303.266.49h2o42   3.002.950.69
0.89
4gcyi   2.962.910.471.10h5s22   3.863.795.30
1.44
5d3hh   3.083.111.34-0.88   h7ss2   2.482.00
-3.32   10.35
5d3wt   1.791.85-5.60   -1.56   i8s4b   2.902.860.16
0.64
5ycya   #   #   N/A N/A ky3sn   2.942.930.47
0.21

Middle rows removed to save space

d33ww   2.933.000.62-1.66   tatc4   2.652.64
-1.09   0.10
dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
-1.04   -1.68
e33ws   2.953.020.73-1.69   u6d33   2.722.72
-0.71   -0.30
f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21
-0.68
f3s5t   2.832.900.09-1.73   v44h6   2.722.73
-0.66   -0.29
f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A
N/A
g2a44   2.762.77-0.45   -0.28


My question is there way a that Lyx/Latex can do this without my manual
intervention.

I hope that the post is clear enough, but if there are any questions please
shout

Regards
Steve
--
View this message in context:
http://n2.nabble.com/Table-Challenge-tp4422819p4422819.html
Sent from the LyX - Users mailing list archive at Nabble.com.



Re: Table Challenge

2010-01-19 Thread Liviu Andronic
Hello

On 1/19/10, SteveSB  wrote:
>  I have managed to get the Sweave/Lyx link in MS Windows working but my
>  problem is the follows.
>
In the original post it wasn't clear whether you were transferring the
results to LyX manually (copy & paste) or via Sweave (using xtable()
or latex() commands). In case of the latter, the two commands allow to
convert R objects into LaTeX long-tables. As Rob already mentioned,
these tables would automatically break at the end of the page.


>  d33ww   2.933.000.62-1.66   tatc4   2.652.64
> -1.09   0.10
>  dml25   2.782.78-0.39   -0.12   u3dd5   2.622.69
> -1.04   -1.68
>  e33ws   2.953.020.73-1.69   u6d33   2.722.72
> -0.71   -0.30
>  f3c4g   2.722.74-0.66   -0.65   v3s8f   3.063.091.21 
>-0.68
>  f3s5t   2.832.900.09-1.73   v44h6   2.722.73
> -0.66   -0.29
>  f44ee   2.792.77-0.39   0.20wa5hh   #   #   N/A  
>N/A
>  g2a44   2.762.77-0.45   -0.28
>
>  My question is there way a that Lyx/Latex can do this without my manual
>  intervention.
>
Again, how do you manually split  it? Copy & paste or by manipulating
the R object? The later might be an acceptable solution.

Regards
Liviu