https://bz.apache.org/ooo/show_bug.cgi?id=126951
--- Comment #7 from randomwalker <[email protected]> --- (In reply to orcmid from comment #2) > (In reply to randomwalker from comment #1) > > Note: on the large spreadsheet, crashes occur with a "bad allocation" > > message. > > With regard to "bad allocation" messages. > > This suggests that you are running into memory-access limitations in > OpenOffice Calc. > > Although Calc was able to build a sheet with such a large number of rows, > the complexity of the sheet is apparently overwhelming with regard to the > memory allocations required to use the sheet. A seemingly-small change may > exhaust the working memory available to Calc. > > One limiting factor is that OpenOffice on Windows is an x86 application, so > the limitation on available memory is fixed at a value less than what a > Windows x64 system might be able to provide. > > Try closing other applications and only having OpenOffice Calc open with the > one document to see if that makes any difference. > > You can also try increasing the Windows swap space (Virtual Memory), > although that might not be a factor. Only do that if you are comfortable > working with the Control Panel > System and Security > System (link) > > Advanced system settings (link on sidebar) > Advanced tab > Performance > (Settings... button) > Advanced tab > Virtual memory. The amount used on > all drives is probably generous already (e.g., nearly 5000 MB or more). Thanks. Increasing virtual memory could perhaps do the job, but the response time is already pretty bad, so I am reluctant to give it a try. My work-around has been to break the spreadsheet in two. Not clean, but it works, although it requires some extra processing. What "surprises" me is that the OO spreadsheet allows some 1'048'576 rows, while I was using only a little over 250'000. -- You are receiving this mail because: You are the assignee for the issue.
