SVG Clocks

Display UTC and local time using analogue clocks. This document uses Javascript and inline SVG code in an XHTML document. It can be viewed using a SVG-capable browser such as Chrome. I wrote this page nearly a decade ago and only ported it to Blogger.

Activation context generation failed ... HsxClient.dll

After a server patch, the HFM (Hyperion Financial Management) Windows client could not start. Below is the error message in Event Viewer.

SideBySide,
Activation context generation failed for "... HsxClient.dll". Dependent Assembly Microsoft.VC80.MFC,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.4053" could not be found. Please use sxstrace.exe for detailed diagnosis.

Oracle Support suggested reinstalling VC++ Redistributable 2005. Searching for the version number brings up "Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update". Installing the x86 redistributable package solved the problem.

Excel cannot find the data you're searching for

Sometimes Excel cannot find text in a cell that is clearly visible. Some workarounds and solutions:

• In the "Find and Replace" dialog, untick "Match entire cell contents".
• In VBA, specify the LookAt parameter, .Find(..., lookat:=XlLookAt.xlPart)
• In your worksheet, remove custom formatting from the cell range you are searching.

The last workaround is pretty weird. One would think that formatting shouldn't affect searching for data!

Excel 2010 build multi-criteria search in Autofilter

Excel 2010's search in autofilter can be used to easily build a multi-criteria filter but I found that the steps for adding the first criteria is different from adding the subsequent criteria.

Assuming your started Autofilter for your worksheet, the steps to add the first criteria are:

1. Click on the filter icon in the column.
2. In Autofilter pane, enter your criteria.
3. Autofilter pane displays the reduced list, including your criteria (assuming it is found).
4. Untick "(Select All Search Results)". Excel removes the tick marks from the reduced list, including your criteria. If you don't untick this option, all the rows in your worksheet remain selected.
5. Don't tick "Add current selection to filter". If you tick this option, all the rows in your worksheet remain selected.
6. Tick your criteria.
7. Press the OK button to activate the filter.
8. Excel closes the Autofilter pane and displays only rows containing your first criteria.

To add more criteria to the filter, the steps are:

1. Click on the filter icon in the column.
2. In Autofilter pane, enter your next criteria.
3. Autofilter pane displays the reduced list, including your next criteria (assuming it is found).
4. Leave "(Select All Search Results)" ticked.
5. Tick "Add current selection to filter" to keep the rows previously filtered.
6. Leave your criteria ticked.
7. Press the OK button to update the filter.
8. Excel closes the Autofilter pane and displays only rows containing all your criteria (including the first criteria).

What is confusing is that you can't see your previous criteria in the Autofilter pane; you have to infer it from the list of visible rows.