Toad World® Forums

Saving in EXCEL 2007, weird grid behavior


#1

Saving in EXCEL 2007, weird grid behavior


#2

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 toad@yahoogroups.com, 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.

-John

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of pknowles9
Sent: Thursday, October 08, 2009 2:24 PM
To: toad@yahoogroups.com
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: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

Your email settings:
Individual Email | Traditional

To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

To change settings via email:
mailto:toad-digest@yahoogroups.com
mailto:toad-fullfeatured@yahoogroups.com

To unsubscribe from this group, send an email to:
toad-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/


#3

color:#1F497D’>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.

color:#1F497D’>

From:
style=‘font-size:10.0pt;font-family:“Tahoma”,“sans-serif”’>
toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of pknowles9

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

To: toad@yahoogroups.com

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 toad@yahoogroups.com, 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.

-John

From: toad@yahoogroups.com
[mailto:toad@yahoogroups.com] On
Behalf Of pknowles9

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

To: toad@yahoogroups.com

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: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htm`

  Your email settings: Individual Email|Traditional

  [Change settings via the Web](http://groups.yahoo.com/group/toad/join;_ylc=X3oDMTJmMmJ0b2hwBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNTUwOTY0Mzk-) (Yahoo! ID required)

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

       [
    Visit Your Group
  ](http://groups.yahoo.com/group/toad;_ylc=X3oDMTJkMjBvZ2pmBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjU1MDk2NDM5) |
  [
    Yahoo! Groups Terms of Use
  ](http://docs.yahoo.com/info/terms/) |

   Unsubscribe

,.,_


#4

Hey Paul,

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.

Perhaps a temporary alternative would be to save to CSV for importing into
Excel? It adds one more (minor) step, but it wouldn’t get in your way while
you were in Excel, either. You’d also lose the auto-formatting that Toad
does, but I’d venture a guess that you don’t have folks that are interested
in scrolling through each of those >64K rows either.

Just a thought…

Rich – [TeamT]

Disclaimer: I’d rather win a noble prize than a Nobel one.


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

Your email settings:
Individual Email | Traditional

To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

To change settings via email:
mailto:toad-digest@yahoogroups.com
mailto:toad-fullfeatured@yahoogroups.com

To unsubscribe from this group, send an email to:
toad-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/


#5

I do this regularly, but there are quite a few people who do scroll through huge spreadsheets here (don’t ask me why), so they do need to be formatted as some of them are at the VP level or above.

Thanks for the suggestion, but I again I strongly request the option to save in the 2007 version directly, with full formatting.

Thanks. Paul

— In toad@yahoogroups.com, “Rich Jesse” wrote:

Hey Paul,

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.

Perhaps a temporary alternative would be to save to CSV for importing into
Excel? It adds one more (minor) step, but it wouldn’t get in your way while
you were in Excel, either. You’d also lose the auto-formatting that Toad
does, but I’d venture a guess that you don’t have folks that are interested
in scrolling through each of those >64K rows either.

Just a thought…

Rich – [TeamT]

Disclaimer: I’d rather win a noble prize than a Nobel one.


Questions? Try the on-line FAQ: http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more - http://www.toadsoft.com/maillist.htmYahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

Your email settings:
Individual Email | Traditional

To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

To change settings via email:
mailto:toad-digest@yahoogroups.com
mailto:toad-fullfeatured@yahoogroups.com

To unsubscribe from this group, send an email to:
toad-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/