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

Free Support Forum - aspose.com

Problem with subtotal(smart markers)

in smart markers, when using (noadd/shift)&group&subtotal, parameters work strange.

the original subtotal row doesn’t copy the style from the data row.

if using noadd&copystyle, the other created data rows are not style-up…


We recommend you to kindly see the document for your reference on Smart Markers especially under “Grouping Data” sub-topic that you use for your needs:
Also, check the document for your reference:

If you still find the issue, kindly create a sample console application (runnable) to reproduce the issue on our end, also attach your input and output files here. Moreover, attach your expected output file here, we will check your issue soon.

Thank you.

i’ve been familiar with thease features. but should here need a demo?.._!!!

as you see, the third row in second sheet. it loses the format. even though i use (shift) or (noadd,copystyle).
if i use (noadd,copystyle) and the cells below already been formated. when the markers put data into them, the cells’ format didn’t covered…

only when no parameters (create new row) it performs the right way.


Thanks for providing us further details.

It looks like some sort of limitation regarding formatting when using more parameters like shift etc. in the smart markers having dynamic formulas. We need your template file, please create it in MS Excel with smart marker and also post your expected file, we will log a ticket for it and look into it later on.

Thank you.

this is the sample. ^)^


Thanks for the sample project and template file.

I can notice the issue as you have mentioned by running your sample project with your template file. I find the following issues in the generated file:

i) The original subtotal row doesn’t copy the style of the data row.

ii) If using noadd&copystyle, the other created data rows are not style-up.

iii) When the markers put data into them, the cells’ numbers formatting didn’t cover fully.

I have logged a ticket with an id “CELLSNET-41642” for your issue. We will look into it soon.

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

Thank you.

thanks for marking up…~

the other thing is what i’ve chatted with you before in (http://www.aspose.com/docs/display/cellsnet/Named+Ranges)

i hope that the Aspose.Cells supports DeleteRange(name, shift) API.

as you see my sample above. i create a method to judge the range contains whole row or column. but it can not do if the range contains some row/column and other cells.

and once if one range is deleted, other ranges below it (or by the right side) should not change the original cells they keep.


Well, we think you may try to use:
Cells.DeleteRange()” method having corresponding ShiftType enumeration member e.g ShiftType.None.

If you still find any problem, we recommend you to kindly start a new thread om Aspose.Cells forums and post us with all the details, sample console application, template files etc. We will check and reply you there.

Thank you.

all i meant is to produce an API to delete a named range…
not the existing API for deleting a specified cells area.

and i’ve found another problem, i’ll create a new thread to describe…


We got your project that you used to demonstrate your issues in your other thread. Please follow up your other thread for updates there:
<a href="https://forum.aspose.com/t/94509

Thank you.


Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.4.3.2 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-41642) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.