Various ms Office vs Open Office issues in Word/Openword and Excel/Calc

Further info on converting a number of Word and Excel documents from MS to OpenOffice.
Had a lot of issues with both text and spreadsheet documents in terms of formatting, layout and graphs.
Some issues resolved through saving in open format (.odt for word, .ods for excel).
This works well for Word Documents.
For excel documents, however, the graphs do not translate well in ods and it is better to just save in ms as excel, then open in open office. However this is currently still a one way process (not really 'open') as then re-opening the document in ms has the graphs disappear altogether! Looks like ms may have implemented ods more for internal purposes more than the real intent. Not sure.
Some of the issues in excel/calc ods to watch for are:
charts referencing data on other worksheets (big one!)
axis label rotation not saving (change manually)
connecting lines for missing values not copied (but can be set manually in "plot missing values – continue line -")

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s