Monday, 1 August 2016

Visio: Horizontal scrolling with SHIFT-scroll

Visio can do cool things with the mouse scroll-wheel.

Here's what I like:

  • scroll only: Pan vertically
  • CRTL-scroll: Zoom
  • SHIFT-scroll: Pan horizontally
By default, Visio interprets SHIFT-scroll as zooming. To switch it to my preferred behaviour, do this:


  1. Select Tools, Options, Advanced.
  2. In the Editing section, deselect Zoom on roll with IntelliMouse.

Tuesday, 19 July 2016

Visio: Create an enormous org chart on a huge page

Visio has a lovely wizard that lets you automatically create an org chart from an Excel spreadsheet, or directly from Exchange.

However, if you have a large number of people, the wizard likes to chop up your tree into many pages, based on its own understanding of what will fit.

I actually want one single enormous tree on one enormous page. The wizard does not appear to handle, this, but it's actually really possible.
  1. Create a dummy org chart:
    1. Click New.
    2. Choose the template named Organization Chart Wizard, then click Create.
    3. Follow the steps to create the org chart from your data source.
  2. Delete the org chart that was created.
  3. Click Design, Size, than choose the page size and orientation that you want. For example, switch to A3 landscape.
  4. Create the real org chart:
    1. Click the Org Chart tab.
    2. Click Import to open the Org Chart Wizard again.
    3. On the penultimate wizard page, choose I want to specify how much of my organization to display on each page.
    4. On the last wizard page, ensure that only the most senior person appears in the Employee at Top of Page table.
    5. Click Finish.

Wednesday, 18 May 2016

Confluence: Find pages that use a particular macro

Here are the instructions fro Sarah Maddox: https://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/

It works in Confluence 5.8.

You search for the following, where x is the macro name:
macroName: x
For example:
macroName: excerpt-include


Wednesday, 11 May 2016

Wednesday, 4 May 2016

Confluence: Link to anchor

Here is the Confluence doc for anchors:
https://confluence.atlassian.com/doc/anchors-139442.html

The important bit is this:

Anchor location Link syntax for anchor Examples
Same page #anchor name #bottom
#important information
Page in same space page name#anchor name My page#bottom
My page#important information
Page in different space spacekey:page name#anchor name DOC:My page#bottom
DOC:My page#important information

Choose Advanced and enter the anchor name in the Link field, following the format below.

The anchor name is case sensitive, so you need to use the same pattern of upper and lower case letters as you used when creating the Anchor macro.

You need to enter page and anchor names with spaces when you link to them in the same Confluence site.