Freeze from ods [SOLVED] lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- totya · 2016-10-18 22:01 Hi! Latest svn (5266) All other revision are untested. Caution: This topic is only for the FPSpreadsheet  developer! Open attached sample file with this component, for example with spready demo. Ater open file the app will freeze, and as soon freeze computer too, because memory ussage is grow up very quickly. Thanks! Edit.: This file saved with LibreOffice 5.1.0.3 ---------------------------------------------------------------------- wp · 2016-10-19 08:33 Fixed in r5268. This was due to an old bug in LibreOffice, and I wonder why they still did not fix it. The problem is that Calc expands Excel files up the the maximum sheet size. The old versions of fpspreadsheet were able to detect this and stripped the filler rows. In the new version, however, I implemented row and column formats (i.e. formatting applied to an entire row or column). While in Excel this is just a simple attribute applied to row and column records ods fills columns and rows with dummy cells again up to the maximum sheet size (I wonder why they made this awful design decision). The current revision should be able to ignore at least the added rows (1 million!), there is still the issue that up to 1024 columns are added. At least your file does not crash any more. [EDIT] r5269 removes the filler columns as well. Please report any side- effects (I hope that there are none, but you never can tell...) ---------------------------------------------------------------------- totya · 2016-10-19 10:12 Ops I forgot to say, I save excel file to ods format, because I wanted to try it. Thank you for your quick and excellent job!