In pursuit of the question How do I delete rows with a known value in a spefic field? I decided to create a new example for an old project.
The attached .ods isn’t claiming to be an actual solution to the mentioned question, and was therefore not presented there.
Background:
-
Over decades I learned to dislike formulas with output to locked ranges.
-
About 10 years ago I was engaged with mathematical considerations and in testing methods working with lots of large intermediary arrays.
-
This stimulated me to develop a concept for something like “output an array to a single cell” or “create a variable representing an intermediary array by a Calc formula”.
-
An implementation by user code was less complicated and worked better than I had expected.
-
Since then I completed my “BackStageMemory” (BSM) package on occasions, and added some helpers.
-
For more than 6 years now there is the feature request tdf#127808 with currently 29 CC, but without any progress. It is about something told to exist in Excel and named “Dynamic Array” there.
-
I haven’t access to any Excel and will leave it at that, but I suspect that dynamic arrays are something like my BSM, but implemented the “MS way”.
-
Now I am interested in comments by users
– knowing Excel’s dynamic arrays, and being able to make comparisons.
– ready to take the time to learn about my concept, and to critisize it reasonably. -
I’m 81 know, and need to decide if I should just trash what I made or make it accessible to others.
-
Studying an example should be a good start Explanations are contained in the hidden sheets.
The example:
BSMdemo_DeleteMatchingRows.ods (190.2 KB)
Interested in your comments and criticism.
I’m definitely not interested in arrogant, graevly biased, or hostile comments.