XL98: HTML: Multiline File Description Changes to a Single Line (181897)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181897

SYMPTOMS

When you use the Internet Assistant Wizard in Microsoft Excel 98 Macintosh Edition, you can enter two lines of text in the Description Below Header box in step 3 of the wizard. However, when you subsequently view the resulting Hypertext Markup Language (HTML) document in an Internet browser, the two lines of text that you originally typed appear as one line of text.

CAUSE

This problem occurs when you use the Internet Assistant Wizard and you enter multiple lines of text in the Description Below Header box in step 3 of the wizard. This behavior occurs because the Internet Assistant Wizard does not enter an HTML line break tag (a <br> tag) in the document between the lines.

WORKAROUND

To work around this problem, open the HTML document in an HTML editor or in a text editor and add the line break tag. To enter the tag, type the following

<br>

in the location in which you want the line break.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Example

To see an example of the problem that is described in this article, follow these steps:
  1. Start Microsoft Excel 98.
  2. On the File menu, click Save As HTML.
  3. Click Next on steps 1 and 2 of the Internet Assistant Wizard.
  4. In step 3 of the Internet Assistant Wizard, type This is a test in the Description Below Header box. Press SHIFT+RETURN for a new line. Type This is a test also on the second line. Click Next.
  5. On step 4 of the Internet Assistant Wizard, note the name of the file, and then click Finish.
  6. Start Microsoft Word 98. Open the file that the Internet Assistant Wizard created in Microsoft Excel.

    NOTE: Open the file in Word by using the Open command on the File menu.

    All the description text is on one line.
  7. On the View menu, click HTML Source.

    The <br> tag is missing after "This is a test."

Inserting the <BR> Tag

To insert a <br> tag after "This is a test," follow these steps:
  1. With the HTML code displayed in Microsoft Word, find "This is a test."
  2. Move the insertion point after the words "This is a test" and type <br>.
  3. Click Exit HTML Source. When you are prompted, save the document.

    Word saves the file and returns to normal view, and the document appears correctly.

REFERENCES

For more information about HTML, click Contents and Index on the Help menu. Click the Index button, and type the following text:

HTML

and then double-click the selected text to go to the "Publish Microsoft Excel data on a web" topic.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kbweb KB181897
©2002 Microsoft Corporation. All rights reserved.