2009-05-10

Office 2007 Service Pack 2 (SP2) Excel

The SP2 has been release recently.

For excel, As mentioned in summary, including compatability with Office 2003, most of the update are focused on the graphic and charts manipulation.
Why they have not included the shapes handling in marco recording? I think there should be some issue XD.

Besides, in my opinion, there are some fixes that are critical too. Not sure why they just skip it...:
Usage:
1. "Remove Duplicates" on a range of cells misses some duplicate string values.
(Not sure they fixed it completely or not, but I had see this happened :P)
2.The order of member properties in a PivotTable's Property Fields dialog box is incorrect.
It does not follow the order set by the user.
(Not met this before, just try sp2 if you see any problem)
3.Tooltips may display the wrong information about chart values.
(Holy...)

VBA: Programmatically setting activecell.Borders.ColorIndex to xlNone fails.
(Well done...)

SSAS:
AutoComplete fails in the CUBEMEMBER function for a member name that includes quotation marks, and a user cannot access the children of that member by using AutoComplete.
(Not try this out yet.)

Let's try SP2 if you feel confused XD

No comments:

Post a Comment