We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.cells.griddesktop - SumSelectedRanges - VB.net

In the Aspose.cells.GridDesktop, I have ten columns, out of them, 6 are hidden. We have a function to calculate the total numeric value from the selection part.
i.e.
grd.Worksheets(0).GetLastSelection.Worksheet.SumSelectedRanges()


In our case, we don’t want to consider the values of hidden columns. can you please look into it, as I think, the current version v2.0.50727 does not support it.

Hi,

Please try the attached latest version/fix, if you still find the problem please create a sample windows application using the attached version, zip it and post it here to show the issue, we will check it soon.

Thank you.

Problem is still there.
Attached is the sample project. Grid contains two columns and first column is hidden. On button click it will get the sum selected of selected values. Still doing for hidden one . This is not required.

Hi,

Thanks for sharing the project.

I can find the issue using your project. We will fix your issue soon.

Your issue has been logged into our issue tracking system with an issue id: CELLSNET-18032.

Once the issue is sorted out, we will notify you.

Thank you.

I was wondering if there should be an option to consider the hidden columns or not like

grd.Worksheets(0).GetLastSelection.Worksheet.SumSelectedRanges(byval IshiddenColumnConsidered as boolean)

Hi,

Thanks for the suggestion. A separate issue has been created with an id 18037 for provision of the option you desired. We will look into the possibility for this feature.

We will let you know once there is update on this issue.

Thank you

Hi,

Please try the attached 2.2.0.2002 version of Aspose.Cells.GridDesktop.

We have implemented an overloaded method for SumSelectedRanges() that provides a parameter named isHiddenCellConsidered. Please try it with the following code:

TextBox1.Text =
lSelRange.Worksheet.SumSelectedRanges(False)<o:p></o:p>


Best Regards