Data processing: presentation processing of document – operator i – Presentation processing of document – Layout
Reexamination Certificate
1999-06-15
2003-05-20
Hong, Stephen S. (Department: 2176)
Data processing: presentation processing of document, operator i
Presentation processing of document
Layout
C715S252000, C715S252000
Reexamination Certificate
active
06565609
ABSTRACT:
FIELD OF THE INVENTION
The present invention generally pertains to a method for translating data produced in a first program into a format required for use in a second program, and more specifically, to a method for ensuring that data translated from a program used to create the data into a hypertext markup language (HTML) format retain formatting and functionality during the translation.
BACKGROUND OF THE INVENTION
A characteristic of many applications programs is that they produce data in a format that is specific to some functionality of the application program. Loss of functionality in data translated from one format to another will not always be immediately apparent. For example, in Microsoft Corporation's EXCEL™ spreadsheet program, a red color font may be applied to a number in a cell to indicate that the value is negative, in accord with defined Number Formatting Rules. However, a value may be shown in a red color font in another cell of the spreadsheet simply because a user arbitrarily selected red formatting for the font in that cell. If this spreadsheet is then translated to HTML format under prior art methods, the functional formatting indicative of a negative value will be lost. Although any values that were in a red font in the spreadsheet cells will also be in a red font in the translated data within an HTML document, the HTML document will not associate a negative value with the red font in those cells where this functionality existed in the original spreadsheet. If it becomes necessary to transfer the translated data from the HTML document back into a spreadsheet, the loss of the negative value functionality in those cells where the red font was originally used to indicate a negative value will cause the resulting spreadsheet to inaccurately represent the data. Understanding how this problem might be addressed requires a brief discussion of the use and format of HTML documents.
With the widespread use of the Internet and of corporate or business intranets, it is becoming increasingly common to translate data from application-specific file formats into HTML file formats, to enable the data to be readily transmitted over a network and viewed in browser programs. HTML documents or files have thus become the universally accepted format for sharing data “on-line.” An on-line information system typically includes a server computer system that makes information available so that client computer systems can access the information. The server and client computer systems are usually connected in either a local area or a wide area private intranet system, or via the public Internet. A unique uniform resource locator (URL) is associated with each HTML document, enabling client computer systems to request a specific HTML document from a server computer system.
An HTML document includes a hierarchical set of markup elements; most elements have a start tag, followed by content, followed by an end tag. The content is typically a combination of text and nested markup elements. Tags, which are enclosed in angle brackets (‘<’ and ‘>’), indicate how the document is structured and how to display the document, i.e., its format. There are tags for markup elements such as titles and headers, for text attributes such as bold and italic, for lists, for paragraph boundaries, for links to other documents or other parts of the same document; for graphic images, for non-displayed comments, and for many other features. Further details regarding HTML may be found in reference books such as “HTML For Dummies,” by Ed Tittel and Steve James (1996).
The following lines of HTML briefly illustrate how the language is used:
Here we start a new paragraph <P>.
Some words are <B>bold</B>, others are <I>italic</I>.
The viewer of the document will see:
Here we start a new paragraph.
Some words are bold, others are italic.
As noted above, a user who wishes to retrieve and display an HTML document generally uses a Web browser program. Two of the popular Web browser programs are: NAVIGATOR™ from NetScape Communications Corp. of Mountain View, Calif., and INTERNET EXPLORER from Microsoft Corporation of Redmond, Wash. The primary functionality of web browsers is directed to finding, retrieving, and displaying documents. A browser is generally not intended for word processing or data manipulation of the information contained within an HTML document, but can display documents or data generated by word processing or spreadsheet applications, once converted into an appropriate HTML compatible format.
A wide variety of data may be shared among different users in a network environment using HTML. Typical HTML documents include images, text, and data. HTML documents can be created using programs specifically designed for that purpose, such as Microsoft Corporation's FRONTPAGE™ Web Page publishing program. Additionally, some applications, such as Microsoft Corporation's WORD 97™ word processing program, allow a user to save a text document as an HTML document. Microsoft Corporation's EXCEL 97™ spreadsheet program also enables a user to save a data table or chart created in a workbook as an HTML file.
As noted above, a characteristic of many application programs is specific formatting of data that is unique to some functionality of that application. It would be desirable to persist application-specific formatting information when translating data from one file format to a different file format, such as the HTML format, so that the data could be reintroduced into the original application with all its original formatting and functionality intact.
In addition to the functionality related to indicating negative numbers with a red font noted above, there are additional EXCEL spreadsheet functions that may be similarly adversely affected by translation into another format such as HTML. In EXCEL 97, text that exceeds the width of a column may be displayed as spilling into an adjacent cell to the right, without actually being merged into that adjacent cell. HTML does not support this function, and will instead treat the text displayed across two cells as being merged into the two cells. It would be desirable that when such “spilled text” is translated into HTML, the “spilled text” formatting information is retained in the HTML file, even if it is not supported in HTML, so that if the HTML file is translated back into the parent EXCEL spreadsheet application, the “spilled text” is correctly formatted as being associated with only one cell.
Currently when a data table is translated into HTML, any empty cells or white space in the data table require a significant amount of coding to be correctly represented in the HTML document. Data tables can often have a significant amount of such empty space. Thus, a table containing relatively little data, yet many empty cells, can generate a relatively large HTML document when translated into HTML format. Clearly, it would be desirable to improve the speed with which the translated data table inserted in an HTML document is rendered by a browser and reduce the amount of HTML coding data (file size) required to define empty cells in a block of cells imported into a web page, while at the same time ensuring that the spreadsheet specific formatting is retained if it becomes necessary to reintroduce the data table from the HTML document back into an EXCEL spreadsheet.
Another aspect of translating a data table from a spreadsheet file format into HTML format is that the appearance of a data table as displayed in the HTML document is often less aesthetic than the appearance of the data table in its parent application. This loss of appearance quality is primarily due to the positioning of the text in the data tables as displayed in HTML. Generally, the text is displayed immediately next to a border of a cell, often making the text difficult to read, because it runs into the contents of the adjacent cell. It would be desirable to be able to add padding (empty spaces) so that text in data tables is easier to read when translating a data tabl
Fischer Kevin J.
Misra Rajeev S.
Sorge Terri L.
Timasheva Anna V.
Anderson Ronald M.
Microsoft Corporation
Romero Almari
LandOfFree
Translating data into HTML while retaining formatting and... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Translating data into HTML while retaining formatting and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Translating data into HTML while retaining formatting and... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3074240