Re: Re: Saving in EXCEL 2007, weird grid behavior

Im Not sure but i use toad for db2

If i use Export to Excel instance - toad requires an Open Excel, but opens a New Excel instance.

So First i cannot copy beteten One of them but secondly it wont Crash My First One on failure.

rgba(77, 128, 180, 0.230469); ">So actually in Sight of tdb2 there os nothing to do :slight_smile:

Ok One Thing:

There should Be an Option like:

0.296875); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); ">"Run this quer and Save instantly As excel"...


If you Poll about 1 gb Data (Excel file) and toad
has to View this Data in program there are two Problems

A) if i have forgotten to deaktivate fetch first 1000 Ries only -> for Export i Need a rerun

B) program slows down an Takes huge Memory ...

Powered by Apple iPhone

On 09.10.2009, at 15:53, John Dorlon wrote:

I will try to get to it for this beta cycle. I can also add an
option to the Excel instance format to always create a new workbook instead of
attach to the current one.

From: [] On Behalf Of pknowles9

Sent: Friday, October 09, 2009 8:46 AM


Subject: [toad] Re: Saving in EXCEL 2007, weird grid behavior

Great, how soon will you release a version to
do this? Some of my saves take quite a while, and I am often working on EXCEL
in the interim. Using an instance means that it will save to whatever workbook
I am currently working on, not a new workbook, which can be a disaster.

Please release a new version, soon. I am sure I'm not the only one hitting this
limit (and there have been requests for this for years).

Thanks. Paul

--- In, John
Dorlon <john.dorlon@...> wrote:

Yes, this is now an option for us after upgrade to the newest version of
our excel writing component.

In the meantime, just save to the Excel instance format. If it detects
that you have Excel 2003 or newer installed, it will write more than 65k rows
per sheet.


[] On
Behalf Of pknowles9

Sent: Thursday, October 08, 2009 2:24 PM


Subject: [toad] Saving in EXCEL 2007, weird grid behavior

TOAD 10 still saves in the ancient 2003 format even though 2007 is
installed. I am regularly saving files with > 65K records and this is a
major pain (EXCEL 2007 has been out for a LONG time now).

Are we ever going to have TOAD export to 2007?

Also, a while ago, I chose F4 to describe a table and clicked on a cell.
The cursor became a flickering hourglass, and never let me access TOAD. I was
forced to force-quit it.

Opening TOAD again, F4 on the same table worked fine.

Thanks. Pauly


Questions? Try the on-line FAQ:

Trouble downloading or running the freeware update? See

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more -`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](;_ylc=X3oDMTJmcmpodmszBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUxMDA5OTU-) (Yahoo! ID required)

  Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured

    Visit Your Group
  ](;_ylc=X3oDMTJkNzhjajZyBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MTAwOTk1) |
    Yahoo! Groups Terms of Use
  ]( |