I am using you closedXML for reading and updating excel file using .NET. Its a good and very helpfull concept to read Excel file.
I am facing problem to shifting the range of SUM function when I insert some rows above it. Is there any solution for it?
I have put formula of SUM(B6:B7) at the CELL NO B8, then I am inserting some rows with the numeric values in B Column but when rows are inserted, I require to shift my range of SUM formula i.e not shifting but its remain same as I have write. If I insert
3 rows above the formula my formula should be SUM(B6:B10).
Please give me any proper solution for it.