Category: howto

Flare: Open Full Help From Single Topic

If you have HTML help (specifically Tripane), sometimes someone will create a link directly to a specific topic. This link opens the topic without the TOC or the header.

Use the following procedure to automagically open the full help when a single topic is accessed:

  1. In the skin Setup tab, enable Show navigation link at top of topic.
    If a single topic is opened, this adds a link to open the full help.
  2. In your master page, add this script before the closing </body> tag:
<script>
	/* <![CDATA[ */
	$(document).ready(function () {
	if (($('.MCWebHelpFramesetLink:visible').length))
	{
	window.top.location = $('.MCWebHelpFramesetLink>a').attr('href');
	}
	});
	/* ]]> */
</script>

Republish and try it!

Adding Newlines in Excel

There are several issues with newlines in Excel. First, how do you add one as you are typing in a cell. And second, how can you use Find and Replace to add newlines?

When Typing

Simply use “Alt+Enter” to add a newline in the current cell.

      Using Find and Replace

      To add a newline with Find and Replace, let’s assume we have the following cell:

      First, open the Find and Replace window (using Ctrl+h).

        In our case, we have a semicolon between each letter. So, enter “; ” as the Find what.

        In the Replace with field, press Alt. Then type 010. Then let go of the Alt key. You won’t see anything different in the field, but trust me, it is there.

        Click Find Next and then Replace or just click Replace All.

        Note that to see your results better, you might need to select your cells, and then click Format > Autofit Row Height.