incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Adams <>
Subject Re: question RMSD
Date Fri, 28 Oct 2011 21:24:51 GMT
On Saturday 29 October 2011 04:11, Martin Hediger wrote:
> Dear List
> How do I export the values in columns A, B and F to an ASCII
> formatted file with white space separation?

Assuming Calc:
I would copy these columns to a new sheet in the same spreadsheet, 
formatted as desired.
cell a1 on sheet 2 has the formula "=Sheet1.A1"
cell b1 on sheet 2 has the formula "=Sheet1.B1"
cell c1 on sheet 2 has the formula "=Sheet1.F1"
(drag the formulas down as desired

Then export this second sheet as CSV.


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message