[upstream] Formula gets in a way while editing and prevents selection of the adjacent cell.

[Serhiy]

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 find the formatting that will constrain the formula within it's cell.

Steps to reproduce:
See the attached screenshot. I cannot add B1 cell to the formula using just a
pointer.

Expected behavior:
The formula should leave cell boundaries only when the formula bar is not
visible.

ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: libreoffice-calc 1:3.4.3-3ubuntu2
ProcVersionSignature: Ubuntu 3.0.0-12.20-generic-pae 3.0.4
Uname: Linux 3.0.0-12-generic-pae i686
NonfreeKernelModules: nvidia
ApportVersion: 1.23-0ubuntu3
Architecture: i386
Date: Wed Nov 2 08:41:20 2011
ProcEnviron:
 LANGUAGE=uk:en
 PATH=(custom, no user)
 LANG=uk_UA.UTF-8
 LC_MESSAGES=uk_UA.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[Serhiy (xintx-ua)]

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

[Serhiy (xintx-ua)]

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

[Serhiy (xintx-ua)]

(In reply to comment #0)
> didn't found
*find

> add B2 cell
*B1

[Serhiy (xintx-ua)]

(In reply to comment #0)
> didn't found
*find

> add B2 cell
*B1

[Sasha-libreoffice (sasha-libreoffice)]

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.

[Sasha-libreoffice (sasha-libreoffice)]

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.

[chris (ign-christian)]

*** Bug 48383 has been marked as a duplicate of this bug. ***

[chris (ign-christian)]

*** Bug 48383 has been marked as a duplicate of this bug. ***

[TheReaperD (djones)]

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.

[TheReaperD (djones)]

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.

[Severoraz (severoraz)]

This bug is still present in LibreOffice 6.0.2.1.0.

[Marcus Tomlinson (marcustomlinson)]

Synchronising bug status with upstream.