1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Summarize more than one column in Excel COM object

Discussão em 'StackOverflow' iniciado por fdantas, Setembro 11, 2020.

  1. fdantas

    fdantas Administrator Moderador

    I'm using SubTotal in a Openedge generated Excel book for my first time.

    The example of the KB (https://knowledgebase.progress.com/articles/Article/Sample-Code-to-do-Excel-Grouping) is: chWorksheet:Range("A1"):CurrentRegion:Subtotal(1, -4112, 2, True, False, False).

    The parameters for SubTotal are: GroupBy , Function:, TotalList, Replace:, PageBreaks:, SummaryBelowData:

    In "TotalList" the example is 2, which means column 2 is totalized.

    In VBA, TotalList can be an array. For example, Array(14, 15) indicates totaling columns 14 and 15.

    But I can't make ABL to accept that. It only receives an integer, for one column. Which is sad.

    Does anybody if it's possible to totalize more than one column?

    Thank you

    Continue reading...

Compartilhe esta Página