View ods file using GroupDocs.Viewer cause to out of memory

GroupDocs.Viewer Product Family
, ,
1

Hello,
In certain ods files, during viewing using GroupDocs.Viewer RAM memory grows quickly, even to out of memory error (on our machine that has good specification).

We have found that probably cause of sudden increase in RAM causes in ods file that has set autofilter on column.

 var viewer = new Viewer(stream, loadOptions);  
 ...
 viewer.View(pdfViewOptions, cancellationToken);

Moreover fired cancellationtoken it has no effect during this operation.
Can you give us the solution to this problem or can you fix it?

I Use .NET 8 and GroupDocs.Viewer 23.11.0

I am attached a sample file (compressed to 7z).
oom-example.7z (15.3 KB)

2

Hi @D04486411

Thank you for the provided file. We successfully reproduced the issue with it (high memory usage and actually hanging out while opening) using latest version 24.11 of GroupDocs.Viewer for .NET and already to started to work on it. It is logged under the VIEWERNET-5126 moniker in our internal tracking system. We will notify you here if any new will appear.

Sorry for the inconvenience.

With best regards,
Denis Gvardionov

3

Hi @denisgvardionov

do you have any information on this case?
I noticed that a new release has been published, but it doesn’t include this fix.
We’re waiting for this fix.

Best regards

4

@D04486411

This issue is still not fixed.

Because the style is applied to the entire column G, the sheet is rendered completely.

There are a couple of workarounds that we can propose at the moment:

  1. Modify the spreadsheet and remove the style that is applied to column G.
  2. Set a print area only to the section that you want to render.
  3. Render a section in case you know the range.

The Split a worksheet into pages article shows different options on worksheets rendering.

As a fix, we’re considering handling this case when SkipEmptyRows is set to true. Learn more here.

In case you have other similar files that we could use for testing, please share them too.