I know in Excel you can Copy Values, Formulas, formatting, etc. But in Open Office I am not immediately finding any similar functionality.
Yes I know you can Paste Special values in Open Office but I need to be able to Copy a formula concatenation of cells into another file (non-Spreadsheet).
Basically I have a SQL Statement that is producing a data-set and from that data-set I am copy it to a spreadsheet (which is OpenOffice Calc), created a column that concatenates the data-set into an insert statement. I then want to take the resulting Insert Statement produced and copy it into a SQL Script file.