Thanks for your support for this issue. We are planning to work on it soon, and we recognize that it has gone a long time without being addressed.
Please answer a short survey about this topic to help make sure we get to the best solution – https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR6Vq1--mcHNHh95T6_DZcJFURDg2NlNBTFZUSkJRNUEyQzVFRTQ0T0hHSi4uGuy Miller commented
Agreed, it is bad enough that Microsoft has included this non-logical "bug" in Excel - very poor quality work. Microsoft should be more ashamed of itself though for not do anything about fixing it! These comments date back to 2015!