Showing posts with label bunch. Show all posts
Showing posts with label bunch. Show all posts

Friday, March 23, 2012

fill down formulas without selecting the sheet

At the moment I have a bunch of formulas along the top row of a sheet and I
wish to copy them down a predfined number of rows. At the moment I activate
the sheet and then select the rows I want to copy down with the row
containing the formulas at the top. It would be much er if I could
accomplish this in the background as it were without having to select the
sheet. Is there a way of effectively filling down the formula without having
to activate the sheet?
Any help much appreciated, kind regards, MarkAre you sure you posted in the right NG ? That should go for the excel ng as
I hear from your problem ?!
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mark Stephens" wrote:

> At the moment I have a bunch of formulas along the top row of a sheet and
I
> wish to copy them down a predfined number of rows. At the moment I activat
e
> the sheet and then select the rows I want to copy down with the row
> containing the formulas at the top. It would be much er if I could
> accomplish this in the background as it were without having to select the
> sheet. Is there a way of effectively filling down the formula without havi
ng
> to activate the sheet?
> Any help much appreciated, kind regards, Mark
>
>

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

sql