Smart Markers and Grouping

Hi
I am trying to use Grouping with SmartWorkers and would like to know if producing an output like sheet ‘Grouped_Expected’ from LongShort Ownership Report.xlsx is possible or not?
I am using Template.xlsx as my designer file with smart markers in it. When I use this file I get an output like in sheet ‘Grouped’ from LongShort Ownership Report.xlsx. Can you update this file with the correct use of smart workers so I can get an output as in the sheet ‘Grouped_Expected’.

Thanks

LongShort Ownership Report.zip (19.6 KB)

@aferriere2,

Thanks for the sample file.

Well, Aspose.Cells’ Smart Markers has its own specifications, rules and formattings. You cannot always do accomplish the task in your own way. Please see the documents for your reference and understanding:

Now create your template file with Smart Markers for grouping data accordingly. You might get better results.

If you still find any signicant issue, kindly do create a simple console demo application (you may zip the project prior attaching) and provide us here with input and output files. We will check it soon.

I have attached a sample demo app AsposeTest.zip. Please let me know if I can use smart markers to create the desired output.
Also the code under Adding Custom Labels is not correct

I think line 15 should be
d.Workbook = designer;
If I do that then the code throws an error for line d.Process();
Can you guys update your code so that it works correctly.

AsposeTest.zip (406.2 KB)

@aferriere2,

Well, it might not be possible to accomplish the task exactly the same as per your expectations. But you may do it to certain extent. Could you try the attached updated template file instead and check if the output results are ok for you.
Template.zip (7.4 KB)

You are right, we will fix the issue in code for the document soon.

Hi
Is it possible to show the subtotal row at the top instead of the bottom of a group?

@aferriere2,

I am afraid, this is not possible but still we will check it.

By the way, I think you may try using Subtotal feature upon the data, see the document for your reference: