Smart Markers and SubTotal row formatting

Aspose.Cells Product Family
1

MarkChandler> basically, we have a flat file
style report which has subtotal rows grouped by a region for
example
MarkChandler> what I’d like to
do is format the entire subtotal row and not just the cell that the value is
stored in
MarkChandler> is that
possible?
MarkChandler> as well as
possibly have “RegionName Total” in the first cell of the row
amjad sahi> do you use smart markers
MarkChandler> yes
MarkChandler> at the moment, I have the values and
subtotals correctly displaying but the formatting of the subtotal row is only
copied for the subtotal cell
amjad sahi>
let me check
MarkChandler> I can send
you an example of my template as well as what I’m trying to do if that would
help?
MarkChandler> not sure if the
above makes sense, kinda tricky to explain :stuck_out_tongue:
amjad sahi> well after checking it
amjad sahi> I think you should paste the subtotal
markers in a separate row and then format the row as per your
demand
amjad sahi> it will be formatted
dynamically as it per the template row formattings where you paste the smart
markers for subtotal
amjad sahi> for
reference please check the 6th picture in the document:
amjad sahi> http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/smart-markers.html
amjad sahi> here the marker i.e. "&=subtotal9:Order
Details.OrderID " is set to bold font
amjad
sahi> could you try
MarkChandler> the problem with doing that is that it
only copies the formatting for that exact cell, not the entire
row
MarkChandler> I basically want a
dark black border around the entire row rather than just the
cell
amjad sahi> yes i am afraid it will
copy the cell formatting at the moment
amjad
sahi> because the subtotal rows are dynamically added
amjad sahi> so it will be as per subotal cell’s
formatting only
amjad sahi> and no other
cell in the row are formatted
amjad
sahi> we can look into it in future though
MarkChandler> cool, just wanted to check if it was
possible at the moment before I started manually editing the
spreadsheet
MarkChandler> if it’s not
possible, it’s all good

This message was posted using Email2Forum by Amjad Sahi.
2

Hi,

We will enhance the Smart Markers feature in our future versions. I have logged your feature request into our issue tracking system with an issue id: CELLSNET-17518.

Once is it sorted out, we will inform you.

Thank you.

3

Hi,

Please try the attached version, we have enhanced the Smart Markers feature in this version for your need.

Thank you.

4

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product's API Reference.