Reporting several Bugs for Excel 2007 Beta 2

[Sstar99]

So far, I still did not find a proper channel to report these bugs to
Microsoft. Some people suggest me to visit "beta.Microsoft.com". But to get
into the site, I would need to Guest ID, which I still don't have. If you
are from Microsoft, I hope you can help feedback the bugs to the Office
development team as the problem below are most likely bugs.

1. Try to insert to Excel 2007 B2 a smooth line by using FreeForm object
with following sample Macro code does not work as expected any more;

'-----------------------------------------------------------------------------------
Sub testFreeform()

Dim docActive As Worksheet
Set docActive = ActiveSheet

'Build a FreeForm Object
With docActive.Shapes.BuildFreeform(msoEditingCorner, 360, 200)

'Adding several curved segment to this FreeForm object

.AddNodes msoSegmentCurve, msoEditingCorner, _
380, 230, 400, 250, 450, 300
.AddNodes msoSegmentCurve, msoEditingAuto, 480, 200
.AddNodes msoSegmentCurve, msoEditingAuto, 480, 400
.AddNodes msoSegmentCurve, msoEditingAuto, 350, 190
.AddNodes msoSegmentCurve, msoEditingAuto, 400, 150

'Convert the FreeForm to a Shape object
.ConvertToShape

End With

End Sub

'----------------------------------------------------------------------------------

Run the Macro function above, instead of getting a smooth curve, you will
get Shooting lines. The above Macro code works well on Excel 2003/Excel
2002/Excel 2000. The same problem happens to PowerPoint 2007 as well. The
sample Macro code for PowerPoint 2007 is

'------------------------------------------------------------------------------------
'PowerPoint. Insert a smooth line to Slide 1

Sub testFreeform()

Dim docActive As Slide

Set docActive = ActivePresentation.Slides(1)
With docActive.Shapes.BuildFreeform(msoEditingCorner, 360, 200)
.AddNodes msoSegmentCurve, msoEditingCorner, _
380, 230, 400, 250, 450, 300
.AddNodes msoSegmentCurve, msoEditingAuto, 480, 200
.AddNodes msoSegmentCurve, msoEditingAuto, 480, 400
.AddNodes msoSegmentCurve, msoEditingAuto, 350, 190
.AddNodes msoSegmentCurve, msoEditingAuto, 400, 150
.ConvertToShape
End With

End Sub

'-----------------------------------------------------------------------------------


2. Drawing a scribble in Excel 2007 Beta 2 is different from that in earlier
Excel versions. Most likely, it is a bug. Start Excel 2007 -> Goto "Insert"
Tab -> Click on Shapes -> In the drop-down menu, click on Scribble icon.
Found the way to draw sribble is different. And the way to draw scribble is
exactly the same as drawing a FreeForm object.


3. Display problem. Insert a shape to Excel 2007 Document. Found
occationally the inserted Shape cannot be seen at all or partially cannot be
seen. This bug can be easily re-produced. My Excel document is set to Display
from Right to Left, and I am not sure whether the SHAPE display problem is
related to my this setting.


4. The two methods of Excel Application.Window

PointsToScreenPixelsX
and
PointsToScreenPixelsY

do not give correct result under the following to conditions.
- Excel Window is in Split mode;
- "Page Layout View" is selected instead of the "Normal" view .

Actually I have already found improvements on the two functions because in
the earlier versions of Excel, the two functions do not give correct result
under more conditions, e.g. when

- "DisplayRightToLeft" property is set "True", i.e. when Excel window
is viewed from Right to Left;
- The zoom is not set as 100%
- Excel Window is in Split mode;
- "Page Layout View" is selected instead of the "Normal" view.

That problem can be tested out easily. If sample code is needed, I can
provide.


5. Excel 2007 is said to be Backward compatible on CommandBar object. But I
found the CommandBar under Excel 2007's Add-ins tab respond really slow. For
example, if you want to change your CommandBar's control button property from
Visible to Invisible when running a Macro code, I found the CommandBar's
Button does not update visually immediately. Only when your program quits and
when you switch from "Add-Ins" tab to another tab and switch back, you would
be able to see the change. In Excel 2003 and earlier versions, there is no
such a problem. In Excel 2007, create a toolbar called my MyBar and put one
visible button onto it, run the following Macro code, you will be able to see
that it takes 10 seconds for button become invisible.


'-----------------------------------------------------------------------------------------------
Private Declare Function Sleep Lib "kernel32" (ByVal timeout As Long) As Long

Sub test()

Application.CommandBars("MyBar").Controls(1).Visible = False
DoEvents

'sleep for 10 seconds
Sleep 10000
MsgBox "Program Quit"


End Sub
'-----------------------------------------------------------------------------------------------

 

[David Cox]

I lost my ability to read help, and wondered if it was something that I did.
I now remember that I tried Options - resources - get updates before the
change.

I remembered this after trying diagnose to fix it. Maybe a coincidence but
suddenly Outlook is my default mail client instead of OE. Maybe a
coincidence too, but suddenly help works again. :->

 

[Guest]

Hi Sstar99,

Just gave this a try with the most current internal builds of Excel 2007,
and wanted to report the results:

(1) - this does not repro in current builds, and works as expected
(2) - scribble now appears in the Insert | Shapes | Lines menu within Excel,
so it looks like this is fixed
(3) - We've definitely made improvements in this space in current builds -
in fact B2TR is much better than B2. Can you give this a try in B2TR and
report back if you have any problems (you can email me directly)
(4) - Sample code here would be great if you don't mind - especially if the
results are different than running the same code in Excel 2003. Again, you
can email me directly.
(5) - this isn't reproing for me in current builds, but if you have some
sample code I'd be happy to give it a try.

Cheers,
Dan
Excel Team

(fix up my email address if you reply directly, thanks!)

 

[Guest]

Hi Sstar99,

Just gave this a try with the most current internal builds of Excel 2007,
and wanted to report the results:

(1) - this does not repro in current builds, and works as expected
(2) - scribble now appears in the Insert | Shapes | Lines menu within Excel,
so it looks like this is fixed
(3) - We've definitely made improvements in this space in current builds -
in fact B2TR is much better than B2. Can you give this a try in B2TR and
report back if you have any problems (you can email me directly)
(4) - Sample code here would be great if you don't mind - especially if the
results are different than running the same code in Excel 2003. Again, you
can email me directly.
(5) - this isn't reproing for me in current builds, but if you have some
sample code I'd be happy to give it a try.

Cheers,
Dan
Excel Team

(fix up my email address if you reply directly, thanks!)