How can I save only some columns of a spreadsheet in csv format?
The situation arises because I need to transform a spreadsheet by modifying a single column according to a formula (which is =MOD(A1-152, 360) ), and then save the spreadsheet with the modified column but not the original one. In more detail, the method is to create a new column, enter the formula into it, and then (hopefully) save as csv. If I delete the original column before saving, the formula becomes an error. If I hide the original column and then save as csv, the original column is saved along with the modified one.
What to do?
I think that post-processing is your best bet here:
There are a number of different methods of removing that extra column, depending upon what OS you're on and what scripting languages you have available. Here are some good examples in Python:
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-06-19 16:41:54 +0200
Seen: 190 times
Last updated: Jan 28
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
