Bugs in MS-Calendaranalytics?

  1. Is there an Off-by-1 bug in MS-Calendaranalytics pivot chart?
    1. I am hovering (as an example) over the first name in the upper list which displays the right name as tooltip, the first name in the second listimage
    2. I guess I could learn DAX to fix this one myself, but what I have found myself doing is copy/paste the legend control from underneath, which does not exhibit this apparent bug, as a screenshot over the wrong legend (Seems strangely inadequate!).
  2. Cannot run visual basic macro because of a syntax errorimageVersion 1 on Excel 2010 (64-bit) on Windows 7 (64-bit). Restarting (Excel/Windows) made this go away.
  3. This stopped working on load from one day to the next, without the file getting saved and updated in between: System.Runtime.InteropServices.COMException (0x80070490): Element not found. (Exception from HRESULT: 0x80070490)
    at Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IHostItemProvider.GetHostExtender(String extenderType, String extenderCookie, IntPtr& extenderObject)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.Office.Tools.IHostItemProvider.GetHostExtender(Type primaryType, String primaryCookie)
    at Microsoft.Office.Tools.Excel.ControlSiteImpl..ctor(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, UInt32 officeVersion, Control control, _OLEObject extenderControl, Boolean isDynamic)
    at Microsoft.Office.Tools.Excel.FactoryImpl.Microsoft.Office.Tools.Excel.Factory.CreateControlSite(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, Control control)
    at Microsoft.Office.Tools.Excel.Controls.Button..ctor(Factory factory, IHostItemProvider hostItemProvider, IServiceProvider serviceProvider, String cookie, String extenderCookie, Object container, String identifier)
    at ExchangeAnalytics.Sheet4.InitializeControls() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 169
    at ExchangeAnalytics.Sheet4.Initialize() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 55
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.LoadEntryPoints(IntPtr serviceProvider)
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: