By user2111042


2013-02-26 12:28:13 8 Comments

I want to lock a cell that has a value calculated by a formula using EPSPlus.

So if a cell used in the formula is changed the cell value will change accordingly however the cell cannot be edited directly, is this possible?

1 comments

@richard hartz 2013-02-26 12:31:06

just protect the worksheet and lock the required cell, this should not affect the formulas

worksheet.Protection.IsProtected = true;
worksheet.Cells["A1:B1"].Style.Locked = true;

Related Questions

Sponsored Content

1 Answered Questions

[SOLVED] EPPlus cell.calculate() error when formula contains TRIM function

  • 2019-03-08 10:20:15
  • Malmee.Weerasinghe
  • 775 View
  • 2 Score
  • 1 Answer
  • Tags:   c# epplus

1 Answered Questions

EPPLus Cell Formula #REF

2 Answered Questions

[SOLVED] Formula not identify cell values

  • 2018-02-09 09:11:03
  • tarzanbappa
  • 603 View
  • 0 Score
  • 2 Answer
  • Tags:   c# excel epplus

2 Answered Questions

[SOLVED] EPPlus Formula Evaluation

  • 2016-06-24 13:38:50
  • telsokari
  • 2818 View
  • 0 Score
  • 2 Answer
  • Tags:   c# excel epplus

6 Answered Questions

[SOLVED] Make column or cells readonly with EPPlus

1 Answered Questions

[SOLVED] EPPlus calculation not working

  • 2016-03-17 17:30:37
  • MJC
  • 4254 View
  • 2 Score
  • 1 Answer
  • Tags:   c# epplus

1 Answered Questions

[SOLVED] EPPlus formatting value from formula

  • 2015-11-21 14:21:55
  • GreenGeckoZA
  • 798 View
  • 1 Score
  • 1 Answer
  • Tags:   c# epplus

1 Answered Questions

[SOLVED] Setting *both* Value & Formula in EPPlus

  • 2014-01-06 09:38:52
  • Andrew Backer
  • 4720 View
  • 2 Score
  • 1 Answer
  • Tags:   excel epplus

Sponsored Content