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
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.