XL98: HTML: Multiline File Description Changes to a Single Line

Last reviewed: March 2, 1998
Article ID: Q181897
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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" (without the quotation marks) in the Description Below Header box. Press SHIFT+RETURN for a new line. Type "This is a test also" (without the quotation marks) 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>" (without the quotation marks).

  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.


Additional query words: XL98
Keywords : xlweb xlwiz kbtool kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbnofix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.