Document interoperability in Lotus Symphony

Wei Guo SHI, Development Manager  |  Apr 19, 2009 11:30 PM
Profile image for Wei Guo SHI In current Office market, there are a number of document formats, includes not only traditional binary formats, e.g. Microsoft Office binary format, Lotus SmartSuite format, but also XML based open standard document formats, e.g. ODF(ISO26300), UOF(China national Office standard format), and OOXML(ISO29500), as well as other popular formats, e.g. HTML, PDF etc.

For each document format, there are multiple implementations, a large number of end users, and a huge amount of existing documents. With the requirements of exchanging document and sharing information across different formats, interoperability for documents in different formats implemented in different Office applications are becoming more and more important and challenging as well. Some of the big challenges we face in supporting interoperability are:

1. Multiple standards and formats. E.g. ODF and MS Office format.

2. Different interpretation to specification due to standard ambiguities. E.g. some default values are not defined explicitly in specification.

3. Implementation difference or limitation.( functional subsets or functional supersets )

The following are approaches we are taking to meet the nature of the challenges:

1. There are different features set defined in different standards or formats, direct mapping may not exist for some of features, e.g. graphic in text box, text box can contain graphic in MS Office format but not allowed in ODF, in this case we translate the text box into frame while do conversion. The goal is to keep the meaning of content same even though it may look different for some cases.

2. As to XML based open standard document format , we work proactively in standard committee to address interoperability issues in specification to ensure interoperability between different vendor implementations. As an example, we join the work in advocating and supporting the formation of ODF Interoperability and Conformance (OIC) TC, we have been working within the TC on building ODF test suites as implementation reference. We also submit the proposals and get accepted in ODF TC while developing new features not in ODF specification to ensure that document generated conforms to standard.

3. With regards to non open standard document format, we have been focusing on improving native filters that does the mapping to ODF format, for example, the MS Office native filter, Lotus SmartSuite native filter. We keep striving for better interoperability. We have made improvements in each release focusing on most commonly used objects.

Since MS Office format is widely used today, interoperability with MS Office has been one of our top priorities. We have done the following enhancements in previous releases :

   Common:

      Word, Excel file encryption/decryption ( coming release this quarter)

      OLE support - Convert Office OLE into Symphony OLE if MS Office is not installed

   Excel:

      Enable Pivot table support ( coming release this quarter )

      Enable Data validation

      Enlarge row limitation from 32768 to 65535

      Chart enhancement

      More chart type support, like XY scatter chart

      Support discrete data source in Excel document

   Word:

      More advanced word table support

      Complex table merge and split

      Table embedding

      Table row crossing page

      Numbering&bullet enhancement

      More bullet style support

      Better numbering&bullet formatting

      More consistent numbering display ( coming release this quarter )

   Powerpoint:

      Enable PPT table support

      Enrich PPT animation effects

Now we are working on plan for next few releases, here are candidate items :

   MS Office VBA support

   Word/Powerpoint content layout improvement, such as line spacing, character spacing, fly objects position etc

   Excel chart enhancement, including more chart support types, char rendering effect

   Robust font information parsing and mapping

   Better graphic rendering quality ( EMF format enhancement )

We would love to hearing from you on prioritization. Your feedback and suggestions will be appreciated very much!

12 Comments
  • Guest said on Apr 20, 2009 2:13 PM:

    Before I investigate on my own, how is this material,as far as compatability is concerned,with OpenOffice?
  • Guest said on Apr 20, 2009 9:50 PM:

    We'll rebase Symphony to current OpenOffice code which will bring much improvement in document interoperability with OpenOffice 3.
  • Tom Cone Jr said on Apr 21, 2009 3:41 PM:

    I hope you'll give high priority to being able to read and write DOCX formatted documents. Thanks.
  • Gopal said on Apr 21, 2009 9:08 PM:

    Nice to see some plans/roadmap for Symphony. Can we have a permanent page showing some approx timelines and plans.
  • Ajay said on Apr 22, 2009 3:49 AM:

    OOo 3 codebase with Symphony UI cannot arrive to soon.

    MS Word and excel interoperability should be highest priority.

    VBA support should go a long way in that area, flawless .doc and .xls support will also be of great help
  • Wei Guo SHI said on Apr 22, 2009 9:04 AM:

    Office 2007 ( OOXML ) import support will be in the next release this quarter.
  • Bill Jarvis said on May 2, 2009 11:48 AM:

    WordPerfect still has a large legal base. Gov't bought 50,000 copies a few years ago. Might want to coosider at least the word documents.
  • Vyhonena Pica said on May 3, 2009 1:20 PM:

    It would be cool if you will add database (Approach) into package. Lot of people are asking for it!
  • Matthew said on Jul 8, 2009 6:40 AM:

    Dear Lotus Symhony Team,

    My sugestions for further developing the Symphony suite include:

    -For the entire suite - please improve the keyboard shortcuts capabilities;

    -For Spreadsheet: more advanced filtering capabilities (ie the use fo wildcards, display the formula structure when entering formulas, the intruduction of Paretto type of charts (double 'Y' axes), more colours for charts (with a more appealing look);

    -For Presentations - please enable the introduction of 'Slide Master' facility;

    -A database application would also be useful.

    Looking forward for your next version.
  • Emmanuel D. said on Aug 7, 2009 8:21 PM:

    what about the SYLK format ?
  • pka said on Oct 5, 2009 11:20 AM:

    SYLK-support of symphony would be great - at least for opening SLK-files (it is still an important file format for spreadsheets)
  • JmS said on Oct 17, 2009 11:01 AM:

    I'm trying Symphony 1.3 out and the very first thing that needs to be added for me is the ability to change default templates for new documents. Arial font will never work for me :)

    That being said, overall I'm pleasantly surprised with the nice UI and I can't wait for the update to OO 3 code. I hope that would take care of strangness of cursor not moving by a space after a word but appearing glued to the last character, or the typed text looking strange for a few seconds initially before blending in with the rest.

    Like others have said, as close to flawless import/export to MS Office formats (xlsx, docx for me) you could possibly get, the better. My personal vote would go for the import side.
Add Your Comment

Comments are not monitored for the purpose of providing support. If you have issues with Lotus Symphony, visit the Support Forums.

* indicates required fields

Optionally include your email address so that if we need to, we can follow up your comment for more clarity. After you submit your comment, your email address will not be displayed and only your name will be displayed on the web.


750 Character maximum