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.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]