Toad World® Forums

Trace file browser export to excel


#1

Hi,

When I export data to Excel, and try to find out the longest statement (Max wait time) I get sheet like:

As you see sort is wrong because of non numeric character all around.

Mine ask is:

Could you please invent another export to excel (or make two sheet excel) - only number based, so people can sort data as they want and get proper results.

Brg

Damir


#2

I think the fact that the numeric columns are percent-based may be causing the issue. By default, my Excel template doesn’t apply percentages to the numeric columns, so I’m not seeing this issue when I export trace file browser contents.


#3

Hi Damir,

I’ve added a “Send to Excel (no units)” option on the right-click menu. If you choose that, the “s” for seconds as well as “% of tot” data will be left of and then Excel will let you sort numerically.

-John


#4

Hi John,
Thx that is great

Thank you.
Damir (send from mobile)

On Tue, Mar 13, 2018, 19:39 John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Trace file browser export to excel

Reply by John Dorlon
Hi Damir,

I’ve added a “Send to Excel (no units)” option on the right-click menu. If you choose that, the “s” for seconds as well as “% of tot” data will be left of and then Excel will let you sort numerically.

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.