What does Libre Office do to an existing Excel sheet to bloat its size?

Posted by Sn3akyP3t3 on Super User See other posts from Super User or by Sn3akyP3t3
Published on 2012-10-16T16:39:24Z Indexed on 2012/10/16 17:07 UTC
Read the original article Hit count: 258

I try to avoid using Libre Office on existing Excel created workbooks because of the potential for unpleasant results. In this case Libre Office bloated the size of the workbook for some reason unknown to me. I would like to know if Libre Office does this to all Excel workbooks or just something in that workbook that causes it.

Software involved:

  • Microsoft Office Excel 2010
  • Libre Office 3.5.x (exact version unknown)
  • Dropbox (merely to sync changes)

Platforms involved:

  • Office on Windows (master of the obvious on that one I suppose..)
  • Libre Office on Mac OS 10.6

Types of data stored in this workbook:

  • Text
  • Integers
  • 1 column with a simple formula spanning the entire worksheet representing that particular row (=CONCATENATE(A2285,B2285,D2285), =CONCATENATE(A2286,B2286,D2286), etc.)
  • Total of 3,500 plus rows

Here is a photo with details described within, but I'll go ahead and explain the photo as well:

  • This screenshot is from Dropbox history of the .xlsx workbook.
  • Version 61 - 68 were Office Excel.
  • Version 69 - 73 were Libre Office.

Drobox file history.

© Super User or respective owner

Related posts about excel-2010

Related posts about libreoffice-calc