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 -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 ----- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/
