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

Free Support Forum - aspose.com

When using subtotalN in smart markers, the source data must be ordered already?

The source data must be ordered already when use subtotalN in smart markers? Even if use the ascending parameter, the result is not expected? The ascending parameter works after the subtotals have been calculated?

@xuanniao,

We are not sure about your issue regarding Smart markers. Could you create a simple sample program (standalone app) and provide us to show the issue. We will check your issue soon. Also provide your template file and output file to evaluate your issue.

subtotal-order.zip (96.5 KB)
Here is the code and files.

@xuanniao,

Thanks for the source code, template file, output file and expected file.

Please notice, we need to evaluate your issue in details. I have logged an investigation ticket with an id “CELLSJAVA-43174” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@xuanniao,

We evaluated your issue in details. Please note, Aspose.Cells cannot support sorting data if the smart marker is grouped. We have to directly sort original data from your end in order to support this feature. But we are not allowed to operate original data. So, please sort your data by yourself (using your own code) before setting it as the data source for Smart Markers.