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

Free Support Forum - aspose.com

Smart Markers and SubTotal row formatting

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.

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.

Hi,

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

Thank you.

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.