https://help.libreoffice.org/Calc/Entering_Values Area Selection wrong. That would end up editing E7 first.
I need UX-advice for this one. I think that highly depends of the use case. And because I'm not an intensive calc users, I need some advice from more experienced users :). Kind regards, Joren
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.