Comments (2)
EPPlus did not update formula references for cross-sheet addresses. This commit updates the behavior methods InsertRow / DeleteRow / InsertColumn / DeleteColum.
DeleteRow and DeleteColumn will now set deleted cells in a formula to #REF! if fully deleted or shrink the addresses if partial deleted.
from epplus.
EPPlus RC
from epplus.
Related Issues (20)
- Chart is not copied properly when copying an entire worksheet
- Metadata can be corrupted when workbooks with #calc or #spill errors are saved. HOT 1
- Read and save excel async is not work HOT 2
- English instead of German number seperator signs for German culture HOT 7
- Formula Calculation sometimes incorrectly returns #VALUE! if IsWorksheets1Based = true HOT 1
- Excel formula involving multiple nested functions, an error occurs HOT 3
- German data formats (dates, decimal separator etc.) are not supported HOT 6
- The LET function lacks the FunctionMetadata attribute
- DateOnly Not Fully Supported as a Proper Sortable Date HOT 4
- Calculation errors with dynamic formulas HOT 4
- Can't apply CollapseChildren() after using Group() HOT 7
- Pivot Table Calculation throws exception if a field is sorted and contains empty cells HOT 1
- columns is not fit HOT 25
- InsertRow did not extend some conditionalformattings
- Setting HeaderParsingType CamelCaseToSpace within LoadFromCollection no longer working HOT 4
- Refreshing a pivot table can cause the selected item in a page field to be cleared. HOT 2
- Handling multiple addresses in names is not handled correctly.
- Shared formulas cache expressions is not cleared. HOT 1
- Invalid formatted text HOT 2
- Pivot table caches did not match numeric values correctly. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from epplus.