We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there a practical limit to spreadsheet size for conversion? [closed]

asked 2013-04-02 17:49:57 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I am seeing a very large number of large spreadsheet that fail to save-as XLSX in Win7. The converter either hangs or crashes or it appears to complete but the XLSX object is corrupted and useless. Moreover, why is it XLSX can only opened as read-only and the name of the object is changed in the Calc window to something like X0000001.ods

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-28 02:29:34.475348


Please Empress Trudy, what is your LIbreOffice version?, and have you try to reset the user profile? https://wiki.documentfoundation.org/UserProfile

m.a.riosv gravatar imagem.a.riosv ( 2013-04-02 22:10:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-04-03 02:29:34 +0200

oweng gravatar image

The simple answer to the question "Is there a practical limit to spreadsheet size for conversion?" is yes, however determining that limit is more complex. Eventually any office document can be made so large or complex as to become cumbersome. Since a lot of XML data can be stored in an XLSX file, you will need to more clearly specify what "large spreadsheet" means. There are various methods of providing details:

  • File (.xlsx) size in kilo/megabytes (kB/MB).
  • XLSX content (/xl/comments1.xml, /xl/sharedStrings.xml, /xl/styles.xml, /xl/workbook.xml, /xl/theme/theme1.xml, /xl/worksheets/sheet1.xml, etc.) size in kilo/megabytes (kB/MB).
  • Number of sheets per 'typical' spreadsheet.
  • Number of row/columns per 'typical' spreadsheet.
  • Extent of formatting (fonts, borders, colours, styles, etc.) in use.
  • Degree and complexity of formula use.
  • Degree and complexity of macros and other complex elements.

That will give others a better idea of where certain limits lie. While LO Calc support of the XLSX format is improving all the time, there are still numerous outstanding bugs (e.g., here is a list for 'FILESAVE+xlsx+hang'. A few bugs with decent example files include:

  • FDO#30770: UI unresponsive during import/export; example file is ~500kB; /xl/styles.xml is 6.5MB.
  • FDO#49120: XLSX corruption on export/save; example file and components are all small.
  • FDO#56394: Unable to export/save; example file is large (9.5MB); /xl/worksheets/sheet1.xml is 32.4MB; /xl/sharesStrings.xml is 6.9MB; /xl/styles.xml is 6.4MB.
edit flag offensive delete link more

Question Tools


Asked: 2013-04-02 17:49:57 +0200

Seen: 1,547 times

Last updated: Apr 03 '13