公开(公告)号：US06613098B1

公开(公告)日：2003-09-02

申请号：US09333815

申请日：1999-06-15

Applicant: Terri L. Sorge ,  Kevin J. Fischer ,  Anna V. Timasheva ,  Russell S. Johnson ,  Rajeev S. Misra ,  Juha Niemisto ,  Robert W. Coffen ,  Ramakrishnan Natarajan

Inventor： Terri L. Sorge ,  Kevin J. Fischer ,  Anna V. Timasheva ,  Russell S. Johnson ,  Rajeev S. Misra ,  Juha Niemisto ,  Robert W. Coffen ,  Ramakrishnan Natarajan

IPC: G06F1700

CPC classification number: G06F17/246 ,  G06F17/2264

Abstract: A spreadsheet program saves data into a hypertext markup language (HTML) document that can be viewed with a browser program, but persists all of the information associated with that data necessary to maintain formatting and functionality of the data if reintroduced into the spreadsheet program. The HTML document can then be used both for displaying the data over the Internet or other network in a browser program, and also for opening the data in the spreadsheet program. The information necessary for preserving the format and functionality of the data in the spreadsheet program is incorporated into the HTML document using HTML, Cascading Style Sheets (CSS), and Extended Markup Language (XML). HTML is used for expressing cell data information that is displayed in the browser program, CSS are used for expressing cell-level properties of the data, and XML is used for expressing information that is not displayed in the browser program, but which is necessary for some functionality of the data when used in the spreadsheet program. If any formatting of the data are changed to enable display of the data in the browser program as displayed in the spreadsheet program, the original formatting information is retained in a supporting file that is ignored by a browser program.

Abstract translation: 电子表格程序将数据保存到可以使用浏览器程序查看的超文本标记语言（HTML）文档中，但如果重新引入到电子表格程序中，则会保留与维护数据格式和功能所必需的所有信息相关的所有信息。 然后可以将HTML文档用于通过互联网或浏览器程序中的其他网络显示数据，以及打开电子表格程序中的数据。 使用HTML，级联样式表（CSS）和扩展标记语言（XML）将维护电子表格程序中数据格式和功能所必需的信息合并到HTML文档中。 HTML用于表示浏览器程序中显示的单元格数据信息，CSS用于表示数据的单元级属性，XML用于表示浏览器程序中未显示的信息，但这是必需的 在电子表格程序中使用数据的一些功能。 如果数据的任何格式化被更改以使得能够在电子表格程序中显示浏览器程序中的数据的显示，则原始格式化信息被保留在被浏览器程序忽略的支持文件中。

公开(公告)号：US06565609B1

公开(公告)日：2003-05-20

申请号：US09333755

申请日：1999-06-15

Applicant: Terri L. Sorge ,  Kevin J. Fischer ,  Rajeev S. Misra ,  Anna V. Timasheva

Inventor： Terri L. Sorge ,  Kevin J. Fischer ,  Rajeev S. Misra ,  Anna V. Timasheva

IPC: G06F1200

CPC classification number: G06F17/30569 ,  G06F17/30893

Abstract: A method for enabling data generated in a parent application to be translated into another format, such as hypertext markup language (HTML), so that formatting functionality unique to the parent application is retained, and so that the data reintroduced into the parent application from an HTML document has all its original formatting and functionality restored. As the data are translated into the other format, formatting information specific to the parent application is included with the data, but in such a manner that the formatting information is ignored by applications such as web browsers that are compatible with the other format. While translating the data into the other format, any formatting commands in the data that are not fully supported in the other format are identified, and if found, are translated so as to emulate the form of the data in the parent application. Included in the translated data is a marker identifying changes in the formatting commands. When the translated data are reintroduced to the parent application, the parent application ignores the non-identical formatting indicated by the marker and instead uses the original formatting information that was included in the translated data. The method can be used to reduce the size of an HTML file that includes translated spreadsheet data by abbreviating the HTML code for empty cells, while ensuring that when translated spreadsheet data are reintroduced into a parent spreadsheet application, the original formatting and functionality of the spreadsheet data are maintained.

Abstract translation: 一种用于使在父应用程序中生成的数据能够被转换成另一种格式的方法，例如超文本标记语言（HTML），使得保留对父应用程序特有的格式化功能，从而将数据从 HTML文档已恢复所有原始格式和功能。 由于数据被转换为其他格式，因此数据中包含特定于父应用程序的格式化信息，但是格式化信息被诸如与其他格式兼容的web浏览器之类的应用程序忽略。 在将数据转换为其他格式的同时，识别出数据中格式化的其他格式不完全支持的格式化命令，如果找到，则转换为在母应用程序中模拟数据的形式。 翻译后的数据中包含一个标识符，用于标识格式化命令中的更改。 当翻译的数据被重新引入父应用程序时，父应用程序忽略由标记指示的不相同的格式，而是使用包含在翻译数据中的原始格式化信息。 该方法可用于通过缩写空白单元格的HTML代码来缩小包含翻译的电子表格数据的HTML文件的大小，同时确保将翻译的电子表格数据重新引入父级电子表格应用程序时，电子表格的原始格式和功能 保持数据。