Skip to content

Improve computations by caching LastCellUsed and FirstCellUsed #1246

@Pankraty

Description

@Pankraty

When profiling #736 I found that probably we can benefit from caching LastCellUsed value in the same way as we cache cell evaluated value. This function is quite expensive and in some extreme cases may be called for dozens of times during one cell evaluation. So I assume we can save LastCellUsed value and current workbook RecalculationCounter value.

For symmetry, we can also save FirstCellUsed, though I am not sure it will have the same effect.

Since we will cache the value on a worksheet level, this will not affect the memory consumption.

Metadata

Metadata

Assignees

Labels

enhancementFeature already exists, but should be enahanced.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions