Paul wrote:
On 9/14/07, Brian Barker <[EMAIL PROTECTED]> wrote:
At 10:03 13/09/2007 -0700, Rick Knight wrote:
I have a spreadsheet template that I fill and then export/save to
csv format. The template has 5 columns that have formulas in them.
The formulas check for the presence of data in column A and if it
exists, make a calculation and fill the cell. If it doesn't exist,
the cell is empty (except for the formula). Sometimes I may have 2
or 3 rows of data, other times 500 rows or more. When I export to
csv, the default behavior is to place double quotes in all of the
empty cells where calculations were performed. I can suppress the
double quotes, but the cells still contain the formula and every
possible row is exported whether it's has data or not. I end up with
csv file that has 64,000 rows, mostly blank. Is there a way to not
export/save empty rows that only contain formulas?
There is a workaround.
o Select the first empty row under your data. (Click on the row label.)
o Press Ctrl+Shift+End; this extends the selection to the block of
rows and columns below your data that contain anything (even just
formulae).
o Press backspace; this deletes the contents of those cells.
o Be patient: wait for Calc to do its work!
o Now save the data as CSV as before.
Since you are working from a template, you will start with a full
sheet of formulae next time, of course.
I trust this helps.
Maybe I'm missing something, but when I export to .csv I have a tick box
that says "save cell content as shown"... when ticked this makes sure that
the formulas are not exported into the .csv even if they are in the cell
themselves.
/paul
Brian,
Your work around looks like it'll work for me, I'm trying it now. It
does work, however the selected range seems to stay selected even though
it has been deleted. When I return to the top of the sheet everything
looks good. Thanks for the great tip.
Paul.
The "Save Cell Contents as Shown" doesn't have any eefect for me. I
actually tried that first. I guess the formulas throw it off.
Thanks,
Rick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
