Indeed, the DataPilot won't be of much help. Remind me in future not to respond to emails on 3:30 am bathroom breaks :)
It looks like John got his z's and answered your questions.. Dave On 11/14/05, David Pettersson <[EMAIL PROTECTED]> wrote: > > Ok, I found it. > > /David Pettersson > > David Pettersson wrote: > > > I can't see how to use DataPilot for this. > > > > What I need to now to do what I want is: > > Is there a function to test if a cell is empty? > > How do I concat a constant string to a cell content? > > When I copy a formula, how do I prevent cell H4 to change to H5, H6, > > H7 ... > > (while H6 in the same formula still should change this way)? > > > > If I get the last questions answer I can complete my work, if I get > > all answered I can understand what I have done next month as well :) > > > > /David Pettersson > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
