Reliable way for getting ranges of visible view #4240
Replies: 1 comment
-
Logged an issue: #4263 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
After filtering a worksheet, I would like to copy the visible cells to another worksheet.
Unfortunately, I get the following error intermittently, depending on how many rows there are to filter.
The stacktrace does not include the actual offending line. It just points to the last
await context.sync()
, but I have narrowed it down to the call toconst toBeCopied = currentWorkseet.getRanges(visibleView.cellAddresses.toString())
.The error occurs with varying frequency depending on the number of rows that are to be filtered:
What could be the reason for this?
Here is the full function:
Also asked on Microsoft Learn Q&A: https://learn.microsoft.com/en-us/answers/questions/1614445/reliable-way-for-getting-ranges-of-visible-view
Beta Was this translation helpful? Give feedback.
All reactions