Problem with Excel 2007 and DNS 10.1?

Submitted by mdl on Thu, 06/25/2009 - 18:12.

NaturallySpeaking

I can't seem to change a chart title, either by dictating or typing, while DNS is running. It works fine when DNS isn't running.

Has anyone else seen this problem?

(vista 32 bit enterprise, SP

Submitted by mdl on Thu, 06/25/2009 - 18:57.

(vista 32 bit enterprise, SP 1, DNS 10.1, Vocola, NatLink)

An ugly workaround: select

Submitted by mdl on Fri, 06/26/2009 - 00:18.

An ugly workaround: select the chart title, use the mouse to click on the function bar, dictate a new chart title , press enter (macro or key).

An equally ugly workaround:

Submitted by BruceCyr on Mon, 06/29/2009 - 16:57.

An equally ugly workaround: Click once in the area of the chart title, wait for the screen to adjust and then click inside the area again, then say "press Home key", "press Shift End key", then dictate a new title.

Bruce

This doesn't work; the

Submitted by mdl on Thu, 07/02/2009 - 21:53.

This doesn't work; the dictated replacement replaces the last cell selected before selecting a chart part, not the title.

Macros to Change Chart Titles in Excel

Submitted by BruceCyr on Fri, 07/03/2009 - 01:47.

You're right, I mispoke: You RIGHT-CLICK in the Chart Title area, then left-click within it, etc. Here's a script that does it:

Sub Main

    'You have to position the insertion point over the charts existing title
    ButtonClick 2,1
    ButtonClick 1,1
    Wait 1
    SendKeys "{Home}+{End}{Del}"

End Sub

However, in considering the limitations of having to put your mouse over the chart title in order to make the script work, I wondered how you would do it if the chart had no title at all. That's when I discovered a more or less complete chart title script:

Sub Main

    'Start by selecting the chart whose title you want to change
    SendKeys "%ci%t"
        '%c opens the Chart Menu
        'i selects the Chart Options dialog
        '%t selects the existing title (if any)
        'Now dictate the new Chart Title
        '   format it as desired,
        '   and say OK or enter etc.

End Sub

BTW, it may be a "deficiency" of DNS 10.1 re: support of Excel, but this is the first time in working with DNS and Excel since the introduction of DragonDictate Pro that I have heard anyone ask for such an abstruse command. In the end, there is no substitute for knowing how an application works. Its covered in Economics 101: No demand => no supply.

HTH,
Bruce

I think you're using Excel

Submitted by mdl on Fri, 07/03/2009 - 04:51.

I think you're using Excel 2003 by mistake; there is no chart menu in Excel 2007.

That said, the above method is exactly what I used in Excel 2003.

mdl wrote: I think you're

Submitted by BruceCyr on Sat, 07/04/2009 - 19:30.

mdl wrote:

I think you're using Excel 2003 by mistake; there is no chart menu in Excel 2007.

That said, the above method is exactly what I used in Excel 2003.

Oh, my mistake. Still, I don't see how M$'s dropping access to a Chart menu can lead to a charge that Nuance is to be blamed for failing to support that application!

BTW, I came across some utility that restored pre-2007 menus to Excel 2007. If you're interested, I can comb through my web history and see if I can pull it up again.

Bruce

PS: Here it is:

http://www.blogsdna.com/3548/get-back-office-2003-...

"Get Back Office 2003 Classic Menu & Toolbar on Office 2007 with UBitMenu"

PPS: Then the right/left-click macro should work.

Some experimentation

Submitted by mdl on Thu, 07/02/2009 - 21:55.

Some experimentation indicates that a macro dictating {space}{backspace} once the chart title is selected will also put you on the formula bar so you can dictate a new title.

The final workarounds I came

Submitted by mdl on Fri, 07/03/2009 - 04:58.

The final workarounds I came up with can be found at http://www.speechcomputing.com/node/2651.

view recent posts

Speech Computing

User login