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

Free Support Forum - aspose.com

Detailed information about label feature for subtotalN in smart markers?

I found label feature can be used like this: Label"{0}Total",LabelPosition:-3.

  1. The {0} seems represent the group value. Can it be {1} , if can, what does it represent? Is there some other parameters can be used in the Label string.
  2. How to set the LabelPosition’s value?Does the value mean the left shifts from current column?
  3. How to set the style of the label produced like total?The copystyle parameter only works for subtotal values produced.Can the whole row have the same style?


Thanks for your query.

  1. Your understanding is correct.
  2. Label position can be set in the format “LabelPosition:-3”. Here -3 means left shifts 3 columns (backwards).
  3. This is not supported. You may manually format it later on once the Smart Markers are processed and data is filled via Aspose.Cells APIs.

I got it. Thank you for replying.


You are welcome.