search

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
https://www.nuget.org/packages/MiniExcel/
Apache License 2.0
2.81k stars 343 forks source link

Combinint @group and Formulas (template) #664

Open unimatrix27 opened 3 months ago

unimatrix27 commented 3 months ago

Excel Type

Upload Excel File

Please attach your issue file by dragging or droppng, selecting or pasting them.

image

MiniExcel Version

1.34.1

Description

I am trying to combine the @group functionality with the $=SUM functionality and I cannot get it to work. I am not sure if it is supported.

What I really would want essentially is the ability to do formulas (just SUMs) of the individual groups and a big SUM of all the data at the bottom.

nelson820125 commented 3 months ago

how to type '@group' tag in your Excel template file?