Exporting ListObject with filter

Aspose.Cells Product Family
1

Hi,
I am trying to export ListObject as
ListObject.DataRange.ExportDataTable(new ExportTableOptions() { DataTable = dt, PlotVisibleRows = true, PlotVisibleCells=true, PlotVisibleColumns =true })

Even though i have passed PlotVisibleRows = true, the above call returns me all rows from the ListObject. The data for visible row will be correct but for all invisible rows an empty row is added in the output data table.

Is there any other parameter need to be passed so that i can get only visible rows as output?

ExportDataTable.png (83.9 KB)

2

@SanjayAswale,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46667 - Hidden rows are fetched while using ExportDataTable with PlotVisibleRows = true
3

@SanjayAswale,

This is to inform you that your issue has been resolved. After running QA and incorporating other enhancements and fixes we will provide you the fixed version.

4

The issues you have found earlier (filed as CELLSNET-46667) have been fixed in Aspose.Cells for .NET v19.4. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

5

Thank you. I tried 19.4 dll and it is working as expected.

6

@SanjayAswale,

You are welcome.