Translating data into html while retaining formatting and functionality for returning the translated data to a parent application

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.