PC Review


Reply
Thread Tools Rate Thread

2007 PlotArea.Left

 
 
RB Smissaert
Guest
Posts: n/a
 
      7th Oct 2006
Just testing on Excel 2007 and in a simple graph I get the following error:
Method 'Left' of object 'PlotArea' failed
When I do PlotArea.Left = 0

This works fine in 2000 to 2003.

I can do simply On Error Resume Next and that solves it, but I wonder if
these
kind of bugs will be resolved in the final release.
Should I just ignore these bugs (I had some similar) and wait for the final
release?

RBS

 
Reply With Quote
 
 
 
 
Tom Ogilvy
Guest
Posts: n/a
 
      8th Oct 2006
"Beta" means that - the point is to discover the bugs and possibly fix them.
I say Possibly because it would depend on the degree of difficulty involved
and how the change might affect other features. I believe they have
finalized the bugs they are going to fix, so you would now wait to see what
the final product looks like. The fact the bug exists in the Beta at this
late date does not mean it will not be addressed and you won't know until
the final product is released.

> Should I just ignore these bugs (I had some similar) and wait for the
> final release?

Yes. (ignore but not forget - you will need to ascertain their status when
it is released if it affects you)

--
Regards,
Tom Ogilvy



"RB Smissaert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Just testing on Excel 2007 and in a simple graph I get the following
> error:
> Method 'Left' of object 'PlotArea' failed
> When I do PlotArea.Left = 0
>
> This works fine in 2000 to 2003.
>
> I can do simply On Error Resume Next and that solves it, but I wonder if
> these
> kind of bugs will be resolved in the final release.
> Should I just ignore these bugs (I had some similar) and wait for the
> final release?
>
> RBS



 
Reply With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      8th Oct 2006
OK, will just wait then.
Not sure it helps, but have uploaded with the smiley thing.

RBS

"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Beta" means that - the point is to discover the bugs and possibly fix
> them. I say Possibly because it would depend on the degree of difficulty
> involved and how the change might affect other features. I believe they
> have finalized the bugs they are going to fix, so you would now wait to
> see what the final product looks like. The fact the bug exists in the
> Beta at this late date does not mean it will not be addressed and you
> won't know until the final product is released.
>
>> Should I just ignore these bugs (I had some similar) and wait for the
>> final release?

> Yes. (ignore but not forget - you will need to ascertain their status
> when it is released if it affects you)
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "RB Smissaert" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Just testing on Excel 2007 and in a simple graph I get the following
>> error:
>> Method 'Left' of object 'PlotArea' failed
>> When I do PlotArea.Left = 0
>>
>> This works fine in 2000 to 2003.
>>
>> I can do simply On Error Resume Next and that solves it, but I wonder if
>> these
>> kind of bugs will be resolved in the final release.
>> Should I just ignore these bugs (I had some similar) and wait for the
>> final release?
>>
>> RBS

>
>


 
Reply With Quote
 
RB Smissaert
Guest
Posts: n/a
 
      8th Oct 2006
Another one:

Now you can do in Workbook_Open:

If Cells(1) = "stop" then
Stop
End If

But this fails in 2007 with an error message about focus.

RBS

"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Beta" means that - the point is to discover the bugs and possibly fix
> them. I say Possibly because it would depend on the degree of difficulty
> involved and how the change might affect other features. I believe they
> have finalized the bugs they are going to fix, so you would now wait to
> see what the final product looks like. The fact the bug exists in the
> Beta at this late date does not mean it will not be addressed and you
> won't know until the final product is released.
>
>> Should I just ignore these bugs (I had some similar) and wait for the
>> final release?

> Yes. (ignore but not forget - you will need to ascertain their status
> when it is released if it affects you)
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "RB Smissaert" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Just testing on Excel 2007 and in a simple graph I get the following
>> error:
>> Method 'Left' of object 'PlotArea' failed
>> When I do PlotArea.Left = 0
>>
>> This works fine in 2000 to 2003.
>>
>> I can do simply On Error Resume Next and that solves it, but I wonder if
>> these
>> kind of bugs will be resolved in the final release.
>> Should I just ignore these bugs (I had some similar) and wait for the
>> final release?
>>
>> RBS

>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PlotArea.Left Question Richard Weatherly Microsoft Excel Programming 4 18th Sep 2008 09:02 PM
PlotArea is different between Excel 2003 and Excel 2007 bill Microsoft Excel Charting 5 21st Nov 2007 02:14 PM
PlotArea question gromit12@gmail.com Microsoft Excel Charting 1 1st May 2007 07:30 AM
PlotArea picture from wbk? Charley Kyd Microsoft Excel Programming 2 31st Dec 2003 06:53 AM
cannot set plotarea.height Henning Winkler Microsoft Excel Charting 1 6th Nov 2003 05:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:45 PM.