Update cell formula to include inserted rows

Home › Forums › SpreadsheetML › Update cell formula to include inserted rows

Tagged: 

This topic contains 1 reply, has 2 voices, and was last updated by  Eric White 8 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • May 10, 2016 at 1:14 am #3385

    smishra80
    Participant

    I have a formula that is summing up column values for a few rows.

    I am inserting new rows and would like to update the formula to include the new rows.

    Is there a way to do this generically for different types of formula?

    May 13, 2016 at 9:59 am #3393

    Eric White
    Keymaster

    Hi,

    I have not written any code to do this, and am unaware of any open source code to do this, although there probably is something out there.

    In preparation to go down this road, quite some time ago, we built a formula parser for formulas in SpreadsheetML – this parser is in Open-Xml-PowerTools. Take a look at the Formulas01 example. However, due to a variety of reasons, after completing the formula parser, we have not continued on this path. These were business reasons, not technical reasons.

    -Eric

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.