Launchpad has imported 6 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=042496.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2011-11-01T23:37:56+00:00 Serhiy Zahoriya wrote: Created attachment 53034 Screenshot of the long formula that gets in a way Problem description: I often cannot select the adjacent cell to add it to the formula when the last one is too long. It depends on the formatting but I didn't found the formatting that will constrain the formula within it's cell. Steps to reproduce: See the attached screenshot. I cannot add B2 cell to the formula using just a pointer. Expected behavior: The formula should leave cell boundaries only when the formula bar is not visible. Platform (if different from the browser): All platforms Browser: Mozilla/5.0 (X11; Linux i686; rv:7.0.1) Gecko/20100101 Firefox/7.0.1 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/1 ------------------------------------------------------------------------ On 2011-11-01T23:40:26+00:00 Serhiy Zahoriya wrote: (In reply to comment #0) > didn't found *find > add B2 cell *B1 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/3 ------------------------------------------------------------------------ On 2012-04-19T02:06:27+00:00 Sasha-libreoffice wrote: Thanks for bugreport Reproducible in 3.3.4 and 3.5.2 on Fedora 64 bit and Windows 32 bit Currently it is not a bug but functionality request. Something like this: If A1 contains long formula, A2 contains some content, we placed cursor into formula bar (not into cell), then do not expand formula from A1 to A2. @ Сергій Загорія Workaround: According to screenshot, suppose we need add cell B1. First, add C1. Then press arrow to left on keyboard, C1 will changed to B1. But do not place cursor into formula or it method will not work. This works on Windows and Linux. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/7 ------------------------------------------------------------------------ On 2014-07-22T08:37:00+00:00 chris wrote: *** Bug 48383 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/9 ------------------------------------------------------------------------ On 2016-03-14T02:17:26+00:00 TheReaperD wrote: This becomes more of an issue the longer your formulas are. With some of the formulas I am using, it can consume a large portion of the page, hiding many cells I would like to be able to click on to add to the formula. This forces me to save the formula incomplete, lookup the cell addresses that I need to add and re-edit the formula. Since some of them requires 10 cells or more, this is a major pain. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/11 ------------------------------------------------------------------------ On 2018-03-17T12:47:09+00:00 Severoraz wrote: This bug is still present in LibreOffice 6.0.2.1.0. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/885085/comments/12 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Wishlist -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/885085 Title: [upstream] Formula gets in a way while editing and prevents selection of the adjacent cell. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/885085/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs