https://bz.apache.org/ooo/show_bug.cgi?id=126951
--- Comment #5 from randomwalker <[email protected]> --- (In reply to orcmid from comment #3) > (In reply to randomwalker from comment #0) > > On a large 56MB spreadsheet with a data set of 247506 rows, the subtotal > > function fails to respond to standard filter settings. The function result > > remains unchanged after activating the filter, for all the subtotal > > functions. > > > > The problem disappears after reducing the size of the data set. It works > > fine on a data set of some 50'000 rows. > > This might be related to the problem of memory exhaustion, where some > functions fail silently in order to not crash and the function does not > operate properly. > > In that case, it might be time to consider using a personal database of some > kind. Are you familiar with the OpenOffice Base application? Thank you.(In reply to orcmid from comment #3) > (In reply to randomwalker from comment #0) > > On a large 56MB spreadsheet with a data set of 247506 rows, the subtotal > > function fails to respond to standard filter settings. The function result > > remains unchanged after activating the filter, for all the subtotal > > functions. > > > > The problem disappears after reducing the size of the data set. It works > > fine on a data set of some 50'000 rows. > > This might be related to the problem of memory exhaustion, where some > functions fail silently in order to not crash and the function does not > operate properly. > > In that case, it might be time to consider using a personal database of some > kind. Are you familiar with the OpenOffice Base application? (In reply to randomwalker from comment #4) > Thank you for your help. > > Memory exhaustion is a probable reason. I have had many crashes with this > spreadsheet, with an ominous "bad allocation" message. > > The data I'm working on is provided by a legacy Delphi program, so I could > include the filters in that program, or indeed, try the OO Base. Either > option requires significant more work. > > As it is, I have opted for the quick and dirty way out, which is breaking > the file in two. Not exactly clean, but it's doing the job. -- You are receiving this mail because: You are the assignee for the issue.
